Parameters › XSETLINE Statement › XSETLINE Syntax

XSETLINE Syntax

[XSETLINE  field name,field name...]

where:

field name,field name... — indicates the field name (or series of field names) to be included in the set description. See Table 2.2 for a complete list of possible field names.

Rules:

• XSETLINE statements must follow PROCESS, OPTIONS, CHARDEF, DRECLINE, XRECLINE and DSETLINE statements and must precede INCLUDE AREA and LOCATE statements.
• The maximum number of characters allowed for each line of a set description is 120.
• Enter XSETLINE field names in the order in which you want them to appear in the Cross-Reference Report. When two or more field names are used per line, they must be separated by a comma.
• You cannot use a field name more than once (except for BLANK or SET-ORDER with unique subscripts).

For compatibility with earlier versions, any SETLINE statements appearing in the input file are treated as XSETLINE statements, and CA IDMS Schema Mapper issues a warning message.

Default: The default XSETLINE values are:

XSETLINE SET-NAME
XSETLINE POINTERS,MEM-OPT
XSETLINE SET-ORDER

 CA IDMS Schema Mapper: mm/dd/yy hh:mm:ss    SUBSCHEMA DBRR1016, SCHEMA DSRR1016, VERSION 1, DICTNAME=TKIT, DBNAME=

                         SET/INDEX CROSS-REFERENCE LISTING

   SET
 NUMBER  SET OR INDEX NAME            OWNER                LOCATION    / PAGE        MEMBER            LOCATION    / PAGE
 ------  -----------------            ---------------------------------------        ------------------------------------
     1    ACTIVITY-TYPES              ACTIVITY             94,    27   / AA          ARTS              150,   27   / BA
                                                                                         ACTIVITY-TYPES
                                                                                         NP OA
                                                                                         LAST

                                                                                     MUSIC             150,   48   / BA
                                                                                         ACTIVITY-TYPES
                                                                                         NP OA
                                                                                         LAST

                                                                                     SPORTS            150,   74   / BB
                                                                                         ACTIVITY-TYPES
                                                                                         NPO OM
                                                                                         LAST

     2    CLASS-SCHEDULE              CLASS                94,    74   / AB          SCHEDULE          150,   12   / BA
                                                                                         CLASS-SCHEDULE
                                                                                         NPO MA
                                                                                         ASC ROSTER-NO DL
 ──────
 CA IDMS Schema Mapper: mm/dd/yy hh:mm:ss    SUBSCHEMA DBRR1016, SCHEMA DSRR1016, VERSION 1, DICTNAME=TKIT, DBNAME=

                         SET/INDEX CROSS-REFERENCE LISTING

   SET
 NUMBER  SET OR INDEX NAME            OWNER                LOCATION    / PAGE        MEMBER            LOCATION    / PAGE
 ------  -----------------            ---------------------------------------        ------------------------------------
     1    ACTIVITY-TYPES              ACTIVITY             94,    27   / AA          ARTS              150,   27   / BA
                                                                                         ACTIVITY-TYPES
                                                                                         NP OA
                                                                                         LAST

                                                                                     MUSIC             150,   48   / BA
                                                                                         ACTIVITY-TYPES
                                                                                         NP OA
                                                                                         LAST

                                                                                     SPORTS            150,   74   / BB
                                                                                         ACTIVITY-TYPES
                                                                                         NPO OM
                                                                                         LAST

     2    CLASS-SCHEDULE              CLASS                94,    74   / AB          SCHEDULE          150,   12   / BA
                                                                                         CLASS-SCHEDULE
                                                                                         NPO MA
                                                                                         ASC ROSTER-NO DL

     3    DEPT-ACADEMIC               DEPT                 39,    48,  / AA          SUBJECT            39,   74   / AB
                                                                                         DEPT-ACADEMIC
                                                                                         NO MM
                                                                                         NEXT

     4    DEPT-GENERAL                DEPT                 39,    48  / AA           SUBJECT            39,   74   / AB
                                                                                         DEPT-GENERAL
                                                                                         NO MM
                                                                                         NEXT
     5    DEPT-TEACHER                DEPT                 39,    48  / AA           TEACHER            94,   48   / AA
                                                                                         DEPT-TEACHER
                                                                                         NPO OM
                                                                                         LAST

Exhibit 2.7: Sample Cross-Reference Reports Before and After Using XSETLINE Statement