DataManager Batch Processing and Reporting › The Parameter Files › CAIKSPAR Parameter File › Database-Related Keywords

Database-Related Keywords

The following five parameters are used to specify the database product your installation uses. CA PMA Chargeback supports Advantage CA Datacom and IBM's DB2. Note that DATABASE_NAME is defined during installation. Use the table below as a guide in specifying the following parameters:

DATABASE_NAME=

Indicates which database name to use for documentation purposes only. Up to 8 characters are permitted.

PLAN_ID=

This 1- to 8-character DB2 parameter is site-dependent.

• If you are using DB2 and require the PLAN_ID, uncomment the PLAN_ID and enter the PLAN_ID.
• If you are using DB2, but do not use the PLAN_ID, the PLAN_ID must remain as a comment.
• If you are using CA Datacom, the PLAN_ID must remain as a comment.

SQL_TYPE=

Specifies which type of SQL statements will be used by PMA. Valid choices are DB2 or DATACOM.

SUBSYSTEM_ID=

A 1- to 4-character SSID or driver used when DB2 links to data. For CA Datacom, SUBSYSTEM_ID should be the owner's ID.

EURODB2 =

Determines what value DB2 uses for the decimal point indicator and applies only to DB2 databases.

• If NO is specified or defaulted to, a period (.) is used as the decimal point indicator and a comma (,) is used to separate large whole numbers so they are presented in a more readable form.
• If YES is specified, a comma (,) is used as the decimal point indicator and a period (.) is used to separate large whole numbers so they are presented in a more readable form.