HDB Extract to CSV

The HDB(EXTRACT) operand requests CICS PA to generate CSV extracts from HDB data.

The command format is:
CICSPA HDB(EXTRACT(hdbname),
          [OUTPUT(ddname),]
          [DDNAME(ddname),]
          [STATnnnn(ddname),]
          [HSTGnnnn(ddname),]
          [DELIMIT('field-delimiter'),]
          [LABELS|NOLABELS,]
          [FLOAT,]
          Start of change [SUFACTOR(hdbname(nnnnn.nnn)),] End of change
          [INTERVAL(hh:mm:ss),]
          [FIELDS(field1[(options)],...),]
          [SELECT(PERFORMANCE(INCLUDE|EXCLUDE(field1(values1),...),...)),]
          [SELECT2(PERFORMANCE(INCLUDE|EXCLUDE(field1(values1),...),...))])
The options are:
EXTRACT
Specifies the name of the HDB from which to extract data. The HDB must be defined in the Repository (DDname CPAHDBRG).
OUTPUT
Specifies the DDname for the Recap report output. If not specified, the CICS PA dialog assigns a DDname in the format HXTS0001 to uniquely identify the output.
DDNAME (performance HDBs only)
Specifies the DDname for the performance extract data set. Dialog default: HDBX0001
STATnnnn, HSTGnnnn (statistics HDBs only)
Specifies the DDname for the extract data set for each statistics report that you want to extract, where nnnn is the statistics ID. STATnnnn identifies a CICS® Transaction Server statistics report; HSTGnnnn identifies a CICS Transaction Gateway statistics report. For example, HSTG000A(TGCMCSV) instructs CICS PA to extract CICS Transaction Gateway Connection Manager statistics report data to the extract data set identified by the DDname TGCMCSV. Dialog default: DDname matches keyword; for example, STAT010A(STAT010A).
FLOAT (performance HDBs only)
Write numeric fields in the extract in S390 FLOAT format.
Start of change SUFACTOR End of change
Start of change

Specifies a CPU SU conversion factor to apply to the HDB container. The SUFACTOR operand includes two keywords to identify the HDB name and its associated conversion factor. The value must be a decimal number or integer in the range 1 - 999999999 (nine 9s).

End of change
INTERVAL
This operand applies to Summary HDBs. It specifies a time interval when the extract summarizes transaction activity over time. The interval is in the range 1 second to 24 hours in the format hh:mm:ss for hours, minutes, and seconds. The HDB Summary data is already summarized by time. You can omit the INTERVAL operand to use the data's interval, or specify an interval that is longer than the data interval. For example, specify 00:15:00 if you want to summarize transaction activity over 15 minute intervals.
FIELDS
Specifies which fields are extracted, the order in which they appear in the extract, and their summarization presentation. Only fields that are specified in the HDB Template can be specified. Fields not contained in the HDB are written as Missing.
SELECT, SELECT2
Specifies what data to include or exclude from the extract based on data field values. See Using SELECT statements for an explanation and examples.

Only fields that are specified in the HDB Template can be specified. Select Fields not contained in the HDB will cause selection to fail and extract will skip the record. 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 extract.


Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//users-guide/cpaug314.htm