File-AID/RDX Extract/Load/Delete request file

00

blank

This record type contains the Db2 SELECT statement(s) generated by the Db2 Object Selection Criteria screen. This record type has no record-type number associated with it.

40n

This record type provides information whether the request includes an Input (external) Key file and/or summary file, creates a record layout and/or XREF file, which layout language is to be used. It also includes the CCSID of the terminal saving request, whether to use Db2 parallelism, whether to create a Topaz Extract Visualizer file, and whether Checkpoint/Resumption is enabled. The third digit n specifies the file type. See type 28 for a list of the file types.

28n

This record type specifies file name and disposition information for the different files in the current request. The third digit n specifies the file type:

n
1 = Extract file
2 = Request file
3 = Extract summary file
4 = Record layout file
5 = XREF file
6 = Relationship file
7 = Profile file
8 = Input (External) Key file
B = Disguise Control file (DCF)
D = Topaz Extract Visualizer file
E = Checkpoint Control file
F = Checkpoint Data file
Y = GDG file

27

This record type contains the request description (50 bytes).

29n

This record type specifies file allocation information for the corresponding type 28 files in the current request. The third digit n specifies the file type. See type 28 for a list of the file types.

56

56 DRIVING: This record type identifies the driving object type (D=Db2, M=MVS), and object name of the driving object at the end of the record to accommodate long object names. For Db2 objects it also includes the location and creator ID, each providing space for the maximum length. In addition, the type 56 record contains the value specified in the Lock Table field on the Extract Scope - Object View screen, with FUNCTION LOCK enabled (see also L (Lock Table) and FUNCTION LOCK) and the Db2 subsystem ID.

54

This record type is only included if record type 56, 52P or 52D is an MVS object. It follows each MVS 56, 52P or 52D record to identify the object’s layout type (S=Single, X=XREF), layout file name, member name, and IO exit name.

54A

This record type is a continuation record for record type 54. It identifies the 01 level record name.

55

This record type is only included if the preceding record type 54 is an XREF type (54X). It follows each 54X or 54A record to identify the object’s XREF file name, and member name.

44

This record type identifies the location, subsystem, creator, and table name of the base table associated with the view you specified as the driving table. This record type occurs only when you specify a view as the driving table. When the 44 record type occurs, it follows the 56 Driving: record type and precedes the 56 Related: record type.

18

This record type identifies the type and name of the Input (external) Key file specified as selection input to the driving object. Valid types are Standard and Delimited. For delimited key files type 18 record includes the delimiter options as specified during the selection criteria specification: 1 or 2 for single (1) or double (2) quotation marks, the column delimiter (, is default), Y or N for quotes on character data, and Y or N for quotes on numeric data. See also Input Key File Specification.

14

Db2 Driving object only. This record type contains

• C= cycle limit for the object;
• M= maximum number of records to extract from this object;
• N= select every n^th record from this object;
• X= object excluded status:
  • N object not excluded;
  • Y1 object excluded by user;
  • Y2 object excluded by line command "A" (All);
  • Y3 object excluded by object not found;
  • Y4 object excluded by scope;
• P= Passthru status:

  • ALL extract all records (line command "A");

    PASSTHRU don’t extract records (line command "P");

  • NONE extract related records as applicable;
• I= satisfy AR/RI indicator Y or N
• nnn/nnn Set number of Total Set number;

57

70

Identifies the data disguise information for this extract request.

• DISG=disguise extract option 1 (DCF), 2 (DPR) or 3 (no)
• RETAIN= retain pre-disguise extract file Yes or No
• AUDIT= create data disguise audit trail files Yes or No
• PREFIX= identifies the prefix for the data disguise audit trail files

45

17

This record type contains the part of the SELECT statement generated by the key file selection input to the driving object. It contains the Db2 column or MVS field name and the location and type of the selection value in the key file. For delimited files, the INDSN parameter specifies the field number, for standard files, it specifies the starting position, length, and type.

56

56RELATED: This record type identifies the object type (D=Db2, M=MVS), and object name of a related object at the end of the record to accommodate long object names. For Db2 objects it also includes the location and creator ID, each providing space for the maximum length. In addition, the type 56 record contains the value specified in the Lock Table field on the Extract-Scope-Object-View-panel screen, with FUNCTION LOCK enabled (see also L (Lock Table) and FUNCTION LOCK) and the Db2 subsystem ID. A type 56 Related: record exists for every related object included in the extract.

58

58Clone: This record type identifies the cloned objects. There can be many 58 record types listed per request. They list the original and new names. The type of clone change is identified with a five digit code XYnnn, where:

X is the major type:
G = global parameter
U = object identification
S = SSID
L = location

Y is the minor type:
D = DSN change
N = object name
L = layout
X = XREF
I = IMS and Output key file
nnn only applies to major/minor type GD
000 = Extract file
001 = Extract request file
002 = Extract summary file
003 = Extract Record layout file
004 = Extract XREF file
005 = Relationship file
006 = Profile file
007 = Input (External) Key file
008 = Disguised Extract file
009 = Disguise Criteria file
010 = Disguise Control file (DCF)
011 = Business Rules file

15

Db2 Non-Driving objects. This record type contains

• C= cycle limit for the object;
• M= maximum number of records to extract from this object;
• N= select every n^th record from this object;
• X= object excluded status:
  • N object not excluded;
  • Y1 object excluded by user;
  • Y2 object excluded by line command "A" (All);
  • Y3 object excluded by object not found;
  • Y4 object excluded by scope;
• P= Passthru status:

  • ALL extract all records (line command "A");

    PASSTHRU don’t extract records (line command "P");

  • NONE extract related records as applicable;
• U= unrelated object Y or N
• I= satisfy AR/RI indicator Y or N
• nnn/nnn Set number out of Total Sets

07

This record type contains global navigation and sampling controls as well as other extract options.

• DPSI= The status Y, N, or - (not relevant) is given for the global Navigation controls DPSI (Direct Path, Parent Path, Sibling Path, and Indirect Path). Direct Path status can also be C for All Children only and P for Plus (see also Direct).
• C= global cycle limit;
• M= maximum number of records to extract for entire execution;
• MAX= Q (Quiesce) or S (Stop);
• UR= uncommitted read (Y or N)
• IMAGE= image copy (Y or N)
• V= capture View DDL (Y or N)
• F= Db2 Format (1=Unicode, 2=Conversion to EBCDIC, default)
• A= capture Alias DDL (Y or N)
• S= capture Synonym DDL (Y or N)
• COMPRESS= compress extract file (C, V or N)
• KT_EMEM= key tree in 64 bit memory (E or blank)
• CK_EMEM= chase keys in 64 bit memory (E or blank)
• KT_DEGR= key tree usage degree n (1-9)
• GH= extract IMPLICITLY HIDDEN columns (Y or N)

09

This record type contains Temporal Table Business or System Time information.

• B or S Business Time or System Time
• D Dual (Bi-temporal)
• 1, 2, or 3 Time period: AS OF (1), FROM (2), or BETWEEN (3)
• Y active or N inactive
• Date/Timestamp 1
• Date/Timestamp 2

23

Description of extract selective column and delimited file options. Db2 single table extract only. This record type contains

• Data set format: 1=standard, 2=delimited;
• Delimited quotation marks: 1=single, 2=double;
• Delimited column delimiter: , (default);
• Delimited quotes on character data: Y or N;
• Delimited quotes on numeric data: Y or N;
• Delimited extract column names: Y or N;
• Delimited date format: as specified, for example, YYYMMDDYYYY
• Delimited number of columns in table, for example, 0013

24

Description of extract selective column and delimited selection and sort order. Db2 single table extract only. This record type contains:

• Column number from the catalog, for example, 00001
• Selected column: S or numerical order number;
• Column sort order: 1 indicates the primary sort column;
• Sort direction: A=ascending (default), D=descending

52P

53

This record type exists only if record type 52P or 52D is a Db2 object. It follows each Db2 52P or 52D record to identify the Db2 object’s subsystem, DBMS version, release, modification level, and delimiter identifier.

52D

13

This record type contains the individual navigation and sampling controls for each relationship as well as other extract options.

• DPSI= The status Y, N, or - (not relevant) is given for the Navigation controls DPSI (Direct Path, Parent Path, Sibling Path, and Indirect Path) for each relationship.
• C= cycle limit for the relationship;
• M= maximum number of records to extract for this relationship;
• D= select n dependents from this parent;
• X= relationship excluded status:
  • N relationship not excluded;
  • Y1 relationship excluded by user;
  • Y2 relationship excluded by line command "A" (All);
  • Y3 relationship excluded by object not found;
  • Y4 relationship excluded by scope;
• E=YY check extract validation status:
  • Y_ (first Y) possible RI violation;
  • _Y (second Y) ignore parent missing;
• A or R identifies relationship type:
  • A application relationship (AR);
  • R Db2 RI;
• The remaining characters identify either the RELNAME (8 bytes) if the relationship is Db2 RI, or the relationship description for AR.

59C

This record type identifies a conditional application relationship (AR-C) and includes the name of the conditional AR Criteria data set and parent criteria member name (Pnnnnnnn).

16

This record type contains the relationship’s creation and last modified time, date, and user ID.

50

Source column. This record type contains information about the source object column or field that participates in a column/field relationship with the target object column/field described by the type 50Target column immediately following the type 51 record for the source column/field. The type 50Source column record identifies the source object’s column/field name, data type, and length.

51

This record type is a continuation record for all type 50 records. The type 51 record identifies the column/field offset, values for subscripts 1, 2, and 3, the total number of subscripts (0, 1, 2, or 3), precision, and scale defined for the relationship.

50

Target column. This record type contains information about the target object column or field that participates in a column/field relationship with the source object column/field described by the type 50Source column immediately preceding the type 51 record for the source column/field. The type 50Target column record identifies the target object’s column/field name, data type, and length. It is always followed by a 51 record type to specify the column/field values for offset and subscripts.

31

This record type contains the relationship description for this KEY relationship.

32

33

This record type contains the Output Key File data set details.

01

This record type contains the value specified in the Maximum rows to select from Driving object field on the Selection Criteria Specification screen. For multiple selection criteria sets, the set number is located on the right, for example 001/003 (set# out of total sets).

02

This record type contains the request description.

03

This record type contains the value specified in the Maximum rows from all tables field on the Extract Scope Screen screen.

08

The Max Cycles record type corresponds to the values specified in the Cycle Control window. It lists the number of allowed extract cycles and whether orphan records are acceptable (Get Parents of Orphans:N) or (Get Parents of Orphans:Y).

02

04

05

06

11

10

12

21

22

30