DEDB Data Extract record layout

This section describes the record layout for the DEDB Data Extract file produced using the EXTRACT command as discussed in the Fast Path Online Suite documentation Open link and the Fast Path Offline Suite documentation . It also shows the default output format of the EXTRACT command, which is EXTRACT_FORMAT=EXTRACT.

Related topic

Layouts

For more information, see the following tables:

DEDB Data Extract record layout 1: DBD control information record definition for SORT=NO

Click here to expand...

Field name	Size	Description
XDR1RDW		RDW LL Field
XDR1RDW		RDW ZZ Field
XDR1TYP	X(1)	X’40’ - Flag indicating SORT=NO
	X(1)	X’00’ - Alignment Byte
XDR1SC	X(2)	X’0000’ - Segment Code
XDRIST#E	X(2)	Number of Segment Table Entries in this record
XDR1STE		Table Entry occurs four times
XDR1STSC	X(2)	Segment Code
XDR1STHL	X(2)	Segment Hierarchical Level
XDR1STPS	X(2)	Segment Parent Segment Code
XDR1STNM	CL8	Segment Name

DEDB Data Extract record layout 2: extracted segment record definition for SORT=NO

Click here to expand...

Field name	Size	Description
XDR1RDW		RDW LL Field
XDR1RDW		RDW ZZ Field
XDR1TYP	X(1)	X’40’ - Flag indicating SORT=NO
	X(1)	X’00’ - Alignment Byte
XDR1SC	X(2)	Segment Code
XDR1DCKL	X(2)	Concatenated Key Length (ckl)
XDR1DCKY	X(ckl)	Concatenated Key Data
XDR1DSDL	X(2)	Extracted Segment Data Length (sdl)
XDR1DSD	X(sdl)	Extracted Segment Data

DEDB Data Extract record layout 3: DBD control information record definition for SORT=YES

Click here to expand...

Field Name	Size	Description
XDR2RDW		RDW LL Field
XDR2RDW		RDW ZZ Field
XDR2TYP	X(1)	C’S’ - Flag indicating SORT=YES
	X(1)	X’00’ - Alignment Byte
XDR2BCF	X(2)	Base Correction Factor Add to XDR Base Register to map data part of record
XDR2SCSQ	variable	SCSQ Table. The number of entries is one less than the number of hierarchical levels defined in the DMB. (There is no entry for the root segment.) 1st byte is Segment Code of segment in this record. 2nd-4th bytes are a sequential counter of the occurrence of this segment type in this database record.
XDR2DATA		Data Portion of Record
XDR2ST#E	X(2)	Number of Segment Table Entries in this record
XDR2STE		Table entry occurs four times
XDR2STSC	X(2)	Segment Code
XDR2STHL	X(2)	Segment Hierarchical Level
XDR2STPS	X(2)	Segment Parent Segment Code
XDR2STNM	X(8)	Segment Name

DEDB Data Extract record layout 4: extracted segment record definition for SORT=YES

Click here to expand...

Field name	Size	Description
XDR2RDW		RDW LL Field
XDR2RDW		RDW ZZ Field
XDR2TYP	X(1)	C’S’ - Flag indicating SORT=YES
	X(1)	X’00’ - Alignment Byte
XDR2BCF	X(2)	Base Correction Factor Add to XDR Base Register to map data part of record
XDR2RKL	X(2)	Root Segment Key Length
XDR2RKV	variable	Root Segment Key
XDR2SCSQ	variable	SCSQ Table. The number of entries is one less than the number of hierarchical levels defined in the DMB. (There is no entry for the root segment.) 1st byte is Segment Code of segment in this record. 2nd-4th bytes are a sequential counter of the occurrence of this segment type in this database record.
XDR2DATA		Data Portion of Record
XDR2SC	X(2)	Segment Code
XDR2DCKL	X(2)	Concatenated Key Length (ckl) excluding root key
XDR2DCKY	X(ckl)	Concatenated Key Data excluding root key
XDR2DSDL	X(2)	Extracted Segment Data Length (sdl)l
XDR2DSD	X(sdl)	Extracted Segment Data

DEDB Data Extract record layout

Comments