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 ArchitectFormat 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 ArchitectFormat 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 ArchitectFormat 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 ArchitectFormat 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.