After printing the report, CA Dataquery exports the data as indicated in the query to the named data set. Each set of data is labeled by its set name specified in the export control card or on the BATCH EXECUTION panel. It is important that you give each set a unique name so that it can be easily located in the data set.
A sample variable length EXPORT file contents display follows:
HEADER,DOCUMENT1,DETAIL,042887,144204,RECORD,CAI-DETAIL-REC,DTL,000,
KEY,ITMID-ORDID-KEY,02,C,0010,00,N,N,005,00,N,FIELD,ORD-QTY,N,007,
00,Y,FIELD,SHIP-QTY,N,007,00,Y,FIELD,UNIT-PRICE,N,007,02,Y,
FIELD,DISC-PCT,N,003,01,Y,FIELD,ACT-DT,C,0006,00,N
DATA,"C10000 01008",2,2,29.50,.0,"991106"
DATA,"C10001 01008",4,4,21.00,.0,"991106"
DATA,"C10002 01008",6,6,14.00,.0,"991106"
DATA,"C10005 01008",2,2,66.75,.0,"991106"
DATA,"A60005 01009",1,1,219.99,.0,"991106"
DATA,"A60008 01009",2,2,179.99,.0,"991106"
DATA,"A70000 01009",4,4,99.99,.0,"991106"
DATA,"H10000 01010",2,2,59.99,.0,"991106"
DATA,"H10002 01010",10,10,4.99,.0,"991106"
DATA,"H20001 01010",3,3,21.99,.0,"991106"
DATA,"H20002 01010",5,5,39.99,.0,"991106"
DATA,"H20004 01010",2,2,21.99,.0,"991106"
DATA,"H20006 01010",5,5,12.99,.0,"991106"
DATA,"H30000 01010",4,4,124.99,.0,"991106"
DATA,"H30002 01010",6,6,69.99,.0,"991106"
DATA,"H30003 01010",3,3,59.99,.0,"991106"
DATA,"H40000 01010",15,15,15.99,.0,"991106"
DATA,"H70001 01010",100,100,38.99,.0,"991106"
DATA,"H80002 01010",20,20,73.99,.0,"991106"
DATA,"H80004 01010",10,10,23.99,.0,"991106"
TRAILER,0022
Header Format for Variable-Length Output
The following is the format of the header statement from the sample z/OS EXPORT report:
HEADER FIELD FIELD DESCRIPTION
Header Describes the data records
SET-NAME Name of the output set
SET-TYPE DETAIL or TOTALS
FIND DATE Date that data was found
FIND TIME Time that data was found
Descriptors Name of the records, keys or fields
Record Record descriptor follows
RECORD-NAME Name of the record
DB-NAME 3-character DB file name
DB ID Database ID for the file
Key Key descriptor follows
KEY-NAME Name of a key whose value was exported
COUNT Number of the fields in the key
*DATATYPE Type of data exported:
C = Character field, not nullable
N = Numeric field, not nullable
K = Nullable character
M = Nullable numeric
*LENGTH Length of field if TYPE=C
or no. of digits if TYPE=N
*DECIMALS Number of decimal places if TYPE=N
or no. of zeros if TYPE=C
*SIGN Y if signed, TYPE=N default is N
(Fields marked with * repeat if KEY COUNT is greater than 1)
Field Field descriptor follows
FIELD-NAME Name of the output field
DATATYPE Type of data exported:
C=character, N=numeric
LENGTH Length of field if TYPE=C
or no. of digits if TYPE=N
DECIMALS Number of decimal places if TYPE=N
or no. of zeros if TYPE=C
SIGN Y if signed, TYPE=N default is N
FIELDS IN DATA RECORDS:
Data Indicates data values follow
DATA Comma separated values, as
described by the Header
FIELDS IN TRAILER RECORDS:
Trailer Indicates this is a trailer record
COUNT A count of total number of records
|
Copyright © 2014 CA.
All rights reserved.
|
|