HDB Extract command

The HDB(EXTRACT) operand requests CICS PA to generate extract data sets from HDB data.

The command format is:
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),...),...))])
The options are:
EXTRACT
The name of the HDB. The HDB must be defined in the Repository (DDname CPAHDBRG).
OUTPUT
DDname for the Recap report output. The CICS PA dialog assigns the default DDname HXTS0001.
DDNAME
DDname for the extract data set. The CICS PA dialog assigns the default DDname HDBX0001.
INTERVAL
Applicable to Summary HDBs. Optionally, specify the time interval for summarizing transaction activity. The default is the Time Interval used to create the data (as defined in the Template).

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.

DELIMIT
The field delimiter used to separate each data field in the extract records. Note that the specified delimiter is enclosed in quotes. The default field delimiter is a semicolon (;).

CICS PA extracts the data values from the HDB records, formats them, and then adds a field delimiter after each field.

LABELS|NOLABELS
LABELS indicates that the first record to be written to the extract data set is to be a field labels record. This is the default.

NOLABELS indicates that you do not want field labels written.

FLOAT|NOFLOAT
Specify FLOAT format to write numeric fields to the extract data set in S390 FLOAT format. This is necessary if you plan to import the extract into a DB2® table. When the DB2 Load Utility is used, it will interpret all numerical fields reliably and consistently in FLOAT format.

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.

FIELDS
Specifies which fields are exported to the extract data set, the order in which they appear in the extract record, and their summarization presentation. If any of the requested data fields were not collected in the HDB, a message is issued and the field in the extract record contains blanks (List HDB) or Missing (Summary HDB).
SELECT, SELECT2
Specifies what data to include or exclude from the extract based on data field values.

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.


Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//cparr202.htm