WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Preferences window

Use the Preferences window to set preferences for Classic Data Architect.

Under Classic Integration Mapping, the following pages are listed:

Adabas page

Use this page to set defaults for mapping data from Adabas databases.

Predict dictionary
Type the name of the Predict system dictionary to use by default for views that are defined to describe the contents of an Adabas file. Classic Data Architect retrieves the Adabas Field Description Table information for the Adabas file the view references.
Date format
Select the default format to use for Adabas DATE fields.

You can specify an alternate format for the DATE data type if you do not want to use the default format MM/DD/YY.

The following DATE formats are supported by Classic Data Architect, where DD is the day of the month, MM is the month of the year (as in "01" for January), YY is a two-digit year (as in "06" for 2006) and YYYY is century and year information (as in "2006"). The examples that follow each format are for January 31, 2006.

Table 1. Date formats that are supported by Classic Data Architect
Format of DATE data type Rendering of January 31, 2006
DD/MM/YY 31/01/06
DD.MM.YY 31.01.06
YY-MM-DD 06-01-31
DD/MM/YYYY 31/01/2006
DD.MM.YYYY 31.01.2006
YYYY-MM-DD 2006-01-31
MM/DD/YYYY 01/31/2006
MM/DD/YY 01/31/06
YYYYMMDD 20060131
Instead of being rendered as two digits, the month can be rendered with the first three characters of its US English name or its full US English name in lowercase:
Table 2. US English name date formats that are supported by Classic Data Architect
Format of DATE data type Rendering of January 31, 2006
DD mmm YYYY 31 Jan 2006
DD mmmmmmmmm YYYY 31 January 2006

Classic Data Architect also supports representing the month and day in Julian format using the DDD syntax:

Table 3. Julian date format that is supported by Classic Data Architect
Format of DATE data type Rendering of January 31, 2006
YYYYDDD 2006031
Time format
Select the default format to use for Adabas TIME fields.

You can specify an alternate format for the TIME data type if you do not want to use the default format HH/MI/SS.

The following TIME formats are supported by Classic Data Architect, where HH is the hour of the day in 24-hour clock notation, MI is the minute of the hour, and SS is the seconds. The examples that follow each format are for 3:29:45 PM, January 31, 2006.

Table 4. Date and time formats supported by Classic Data Architect
Format of TIME data type Rendering of 3:15 PM, January 31, 2006
DD/MM/YYYY HH:MI:SS 31/01/2006 15:29:45
DD.MM.YYYY HH:MI:SS 31.01.2006 15:29:45
YYYY-MM-DD HH:MI:SS 2006-01-31 15:29:45
YYYYMMDD HH:MI:SS 20060131 15:29:45
YYYYDDD HH:MI:SS 2006031 15:29:45
MM/DD/YYYY HH:MI:SS 01/31/2006 15:29:45
MM/DD/YY HH:MI:SS 01/31/06 15:29:45
DD mmm YYYY HH:MI:SS 31 Jan 2006 15:29:45
Default VARCHAR length
Type the default maximum length to allow for VARCHAR fields.
Default LVARCHAR length
Type the default maximum length to allow for LVARCHAR fields.
Maximum Occurs
Type the default maximum number of occurrences for all fields that occur multiple times in an Adabas file. If you do not specify a value, the occurrence count value from Predict is used. If Predict is not available, the value 0 is used.
Use synonyms
Select to use the User Synonym field from the Predict Dictionary when this field is defined. Leaving this box unchecked specifies to use the Predict Dictionary field name.

CICS® VSAM page

Use this page to set defaults related to mapping data from CICS VSAM files.

data server LUNAME
Type a short identifier of 1 to 8 characters that designates the VTAM® LU 6.2 definition that a CICS region is listening on for connection requests. The CICS LUNAME corresponds to the value of the APPLID parameter that is specified in the system initialization definition (DFHSIT macro) of the target CICS subsystem where the VSAM file is located. The CICS LUNAME follows VTAM naming conventions.
CICS APPLID
Type an identifier of 1 to 8 characters that designates the VTAM LU 6.2 definition that a CICS region is listening on for connection requests. This identifer corresponds to the value of the APPLID parameter that is specified in the system initialization definition (DFHSIT macro) of the target CICS subsystem where the VSAM file is located. This identifier follows VTAM naming conventions.
Logmode
Type a short identifier of 1 to 8 characters that designates the name of the VTAM logon mode table that is used to control the session parameters for the conversation that is established between the local LU and the CICS LU. The logon mode table name corresponds to a z/OS® load module that is accessible to VTAM. The definition for a logon mode table is supplied in SASCSAMP member CACCMODE.
Transaction ID
Type a short identifier of 1 to 4 characters that designates the name of the supplied CICS transaction that is used for data access and validation purposes. The CICS transaction ID corresponds to the CICS TRANSACTION definition. Sample CICS transaction, connection, program, and session definitions are supplied in SCACSAMP member CACCDEF. The sample CICS transaction ID is EXV1 and can be modified.
Network name
Type a short identifier of 1 to 8 characters that designates the name of the network where the CICS LUNAME resides, which corresponds to the CICS subsystem that is used to access a VSAM file. The network name is identified on the NETWORK VTAM macro definition on the local image to identify the remote SNA network where the CICS subsystem resides. The network name follows VTAM naming conventions.

FTP Options page

If you use double-byte characters, use this page to set an FTP subcommand so that the data remains unaltered when you transfer the data between Classic Data Architect and a data server.

FTP subcommand
Type the subcommand that you want to use.

PIC9(n) Options page

Use this page to specify a default data type when mapping unsigned numbers to columns in tables.

Character
Select to map unsigned numbers as characters by default.
Decimal
Select to map unsigned numbers as decimal numbers by default.


Feedback

Update icon Last updated: 2006-12-15