Creating information objects using the IO Design perspective
Introducing the IO Design perspective
About information objects
About creating information objects
Working with the IO Design perspective
Displaying hidden messages
Creating projects, data connection definitions, and maps
Creating an Actuate BIRT project
Propagating column and parameter renaming and deletion
Creating a data connection definition
Creating a data connection definition for a database
Creating a data connection definition for an ODA data source
About connection properties
About the IANAAppCodePage property
About Informix database connections
Specifying a production database schema
Encrypting and decrypting data source connection property values
Understanding the encryption extension point plug‑in
Extending the encryption extension point plug‑in
Troubleshooting an encryption extension
Externalizing data source connection property values
About the data source connection configuration file
Externalizing connection property values for a preconfigured connection type
Externalizing connection property values for a configurable connection type
Externalizing connection property values for an ODA connection type
Creating maps
Creating a map of a database table or view
Updating a map of a database table or view
Creating a map of a native SQL query
Creating a map of a stored procedure result set
Creating a map of an ODA data source query result set
Creating information objects
Creating an information object
Creating a graphical information object query
Using the expression builder
Choosing maps and information objects
Defining output columns
Creating a filter for use in report designs
Specifying a join
Filtering data
Grouping data
Filtering on an aggregate column
Defining parameters
Creating a textual information object
Displaying output columns
Displaying parameters
Displaying information object output
Displaying a data source query
Understanding query execution plan operators
Understanding node operators
Understanding leaf operators
Storing a query plan with an information object
Saving an information object’s query plan
Saving query plans for source and dependent information objects
Deleting an information object’s query plan
Localizing an information object
Building and publishing a project
Building a project
Propagating column and parameter property values
Publishing a project
Publishing information object files as resources
Publishing information object files as non-resources
Downloading files from a volume
Assessing the impact of project changes
About project dependencies
Searching for data connection definitions, maps, and columns
Displaying the project model diagram
Assessing the impact of a change on files in a volume
Downloading files from a volume
Determining the dependencies between project files
Generating an impact report
Actuate SQL reference
About Actuate SQL
Differences between Actuate SQL and ANSI SQL-92
Limitations compared to ANSI SQL-92
Extensions to ANSI SQL-92
Database limitations
Actuate SQL syntax
Actuate SQL grammar
Using white space characters
Using keywords
Using comments
Specifying maps and information objects in Actuate SQL queries
Using identifiers in Actuate SQL
Using column aliases in Actuate SQL
Specifying parameter values
Using subqueries in Actuate SQL
Using derived tables in Actuate SQL
Data types and data type casting
Facets
Casting rules
String comparison and ordering
Functions and operators
Comparison operators: =, <>, >=, >, <=, <
Range test operator: BETWEEN
Comparison operator: IN
Arithmetic operators: +, -, *, /
Numeric functions
Null test operators: is [not] null
Logical operators: and, or, not
String functions and operators
Timestamp functions
Aggregate functions: COUNT, MIN, MAX, SUM, AVG
System function: CURRENT_USER
Providing query optimization hints
Indicating that a table in a join is optional
Specifying the cardinality of a join
Using pragmas to tune a query
Disabling cost-based optimization
Disabling indexing
Specifying a threshold value for indexing
Configuring database types
Understanding database types
About database types
About connection types
About mappings
About preconfigured database types
DB2 data type mapping and issues
Informix data type mapping and issues
Oracle data type mapping and issues
SQL Server data type mapping and issues
Sybase data type mapping and issues
About configurable database types
Working with XML files
Configuring connection types
About configuring connection types
JDBC driver requirements and installation
JDBC driver requirements
Installing a JDBC driver
Working with datasources.xml
Configuring connection types: ConnectionTypes element
Configuring database types: DatabaseTypes element
Mapping data types
About data type mapping
DataTypeMapper element
MaxSize attribute
DataType child element: Aliases
Mapping functions and operators
About mapping functions and operators
About ODBC escape sequences
Disabling the default mapping for a function
Differences between Actuate SQL functions and database functions
About Generic_ODBC mappings.xml
Syntax for mapping functions and operators
Mapping functions and operators: FunctionMapping element
Mapping Boolean operators: BooleanOpMapper element
Mapping comparison operators: ComparisonOpMapper element
Mapping arithmetic operators: ArithOpMapper element
Mapping numeric functions: NumericFuncMapper element
Mapping string functions: BasicStringFuncMapper element
Mapping substring functions: SubStringFuncMapper element
Mapping the LIKE operator: LikeOpMapper element
Mapping DATEPART functions: DatePartMapper element
Mapping date subtraction functions: DateDiffMapper element
Mapping date addition functions: DateAddMapper element
Mapping date serialization functions: DateSerialMapper element
Mapping NULL functions: NullFuncMapper element
Mapping conditional functions: CondFuncMapper element
Mapping aggregate functions: AggrFuncMapper element
Mapping multi-row Boolean operators: MultiRowBoolFuncMapper element
Mapping cast functions: CastFuncMapper element
Using operators in a mapping
Symbolic operators require parentheses
Negative sign must be followed by a space
Less than (<) and greater than (>) symbols must be escaped
Example: Mapping the not-equal-to operator
Example: Mapping the CONCAT function
Example: Mapping the DATEDIFF function
Example: Mapping the CHAR_LENGTH function
Example: Mapping the negative sign (‑)
Using initialization statements
Example: Specifying the behavior of concatenation with NULL
Mapping literals and clauses
Mapping literals: LiteralMapper element
Template format for VARCHAR literals
Template format for TIMESTAMP literals
Example: Mapping VARCHAR and TIMESTAMP literals
Mapping clauses
Mapping the ORDER BY clause: OrderByClauseMapper element
Mapping the GROUP BY clause: GroupByClauseMapper element
Working with collations and byte-based strings
Working with collations
About Integration service collations
About database collations
About collation implementations
Working with byte-based strings
Creating information objects using the IO Design perspective
Working with byte-based strings
filter
parameter