DB Data Provider Index Load Properties List

DB Data Provider Index Load properties list identifies the connection parameters and other items you must define for the component.

Required Properties

Property

Description

Interface

Identify the method or driver to use to connect to the datasource.

Host Name

Identify the datasource. The options that appear in the Host Name list depend on the interface you select.

Query
Create a query that retrieves information from the datasource. Use the predefined variable LoadIndex to qualify the selection criteria in the WHERE clause. Enclose LoadIndex with square brackets, because it is evaluated before the query is sent to the database, for example:
select * FROM SALES
WHERE SA_DELIVERYDATE >'[LoadIndex]'
ORDER BY SA_DELIVERYDATE
Note:

Quote characters differ between database systems. In Microsoft Access databases, use # for datetime values.

Use the Query window to create a simple query, or click the Query Designer icon to open the Query Designer.

Ascending Index

Select the attribute that contains the ascending index for delta load.

Optional Properties

Property

Description

User and Password

Identify an authorized database user and protect the database against unauthorized access.

Load Index Value
The maximum value of the ascending index attribute is automatically used and stored when executing a Sybase IQ InfoPrimer job or schedule. The Load Index Value simulates the project using the specific value provided by the user. For example: 
2005-01-19100

Read Block Size

Determine the number of records retrieved by the component in a single step.

Pre Processing SQL

Create a script that runs during component initialization. Scripts can include one or more SQL statements. If you use multiple statements, separate them with a semicolon (;).

Post Processing SQL

Create a script that runs after all components execute. Scripts can include one or more SQL statements. If you use multiple statements, separate them with a semicolon (;).

Database

Identify the database to use as datasource. If you select this option, you must also select an appropriate interface, and in some cases, specify an appropriate user ID and password.

Schema

Identify the schema or owner you want to use as datasource. The objects that appear are restricted accordingly and new tables are created in the schema you specify.

Standardize Data Format

Convert incoming DATE and NUMBER information into a standard format that Sybase IQ InfoPrimer can move between systems that support different formats.

Dates are converted into this format: YYYY-MM-DD hh:mm:ss.s. For example:
2005-12-01 16:40:59.123
Numbers are converted using a period (“.”) as the decimal separator.

Database Options

Set options that override performance defaults and control the behavior of some transactions.

Transactional

All work performed by the component, including preprocessing SQL statements and postprocessing SQL statements, is done in a single database transaction that is committed when the project finishes normally. Select this option to roll back the transaction, if this component encounters an error.

Parent topic: DB Data Provider Index Load