Options

The ODBC and Type 2 JDBC drivers use the following information:

Data Source: Specifies the data source name. To add a new data source, enter a character string of up to 32 characters in this field. Use a combination of letters, numbers, spaces, or special characters. When modifying an existing data source, the name cannot be changed.
Dictionary: (Optional) Specifies the DBNAME or segment name of the dictionary containing the definitions of the tables you want to access. This name must be defined in the DBNAME table on the CA IDMS system identified by the server name. The default is the first eight characters of the Data Source.
Server: Specifies a user-defined name which represents the CA IDMS system you want to access. Enter a new 1-to-32 character name or select an existing name from the pull-down list. This field is required. 'Server' is a logical construct, which contains various options needed to access your IDMS CV.
Default Schema: Specifies the name of the default SQL Schema. This is an optional 1-to-18 character field. When specified, this field is used as the schema qualifier for all SQL table references that do not contain an explicit schema qualifier. The default is blank (unspecified).
Program Name: Specifies a program name that are associated with the task on the CA IDMS system. This name is recorded in the CA IDMS journal and allows you to correlate a database update to a specific application. The default Program Name is IDMSODBC.