The HDB(EXTRACT) operand requests CICS PA to generate extract data sets from HDB data.
CICSPA HDB(EXTRACT(hdbname),
[OUTPUT(ddname),]
[DDNAME(ddname),]
[INTERVAL(hh:mm:ss),]
[DELIMIT('field-delimiter'),]
[LABELS|NOLABELS,]
[NOFLOAT|FLOAT,]
[FIELDS(field1[(options)],...),]
[SELECT(PERFORMANCE(INCLUDE|EXCLUDE(field1(values1),...),...)),]
[SELECT2(PERFORMANCE(INCLUDE|EXCLUDE(field1(values1),...),...))])
You can specify any interval greater than or equal to the Template Interval in the range 00:00:01 (1 second) to 24:00:00 (24 hours). For example, if you are reviewing many days worth of data then you might specify 24:00:00 so that you can analyze the daily trend.
CICS PA extracts the data values from the HDB records, formats them, and then adds a field delimiter after each field.
NOLABELS indicates that you do not want field labels written.
If FLOAT is not specified, the numeric fields are written in a mixture of integer, real and exponential using character digits. This is the default and is suitable when importing the extract data into a PC spreadsheet tool.
SELECT and SELECT2 can both be specified to perform record filtering. The CICS PA dialog generates SELECT2 statements in the command deck when you use a Report Form that has active Selection Criteria. If both SELECT and SELECT2 are specified, then the record must pass selection by both specifications for it to be included in the report.