IBM ISERIES SC41-5210-04, User Manual

Page: 194 / 294

Example of printed record format information for a Query for iSeries
query definition
The following is an example of one particular part of the query definition (the record format layout for the
database output file) that can be printed when the query is run. The information shown below is printed
only if the query is defined for database file output and, in this case, when it sends summary-only output to
the database file.
v
The Output CCSID Value is the CCSID of the entire query. This line is not printed if the CCSID is
65535. If the query contains multiple CCSIDs, a CCSID column shows the CCSID of each field.
v
The Field column shows the fields that exist in the output records. Each data field in the record output is
assigned a name equal to the field name as it exists in the query definition. If two or more fields in the
record output have identical field names (this occurs if one or more summary functions are specified for
a field or when files are joined), the first six characters of the field name are used plus a two-digit
number is added that corresponds to the summary function (01=Total, 02=Average, 03=Minimum,
04=Maximum, and 05=Count).
For example, if minimum and maximum summary functions were specified in the query definition for the
FMT
field, two fields named
FMT03
and
FMT04
would appear in the record output; they would contain the
minimum value for the
FMT
field (
FMT03
) and the maximum value for the
FMT
field (
FMT04
). This naming is
true only in this simple case. Actual naming varies with different queries.
v
The Begin column shows the starting byte of the field within the record. For example, the field named
ZD3
starts at byte 28.
v
The Len and Dec columns show the length and decimal positions for each field. For example, the field
named
PK2
has a length of eight with two decimal positions.
Note: What is shown on the report is the printed output length after formatting, not the
internal-database field length. You
cannot add the length to the begin position and get the
beginning position of the next field.
v
For nonnumeric fields, the Dec column shows the type of data that is contained in the column:
Blank means fixed-length character
V means variable-length character (SBCS or DBCS)
J means DBCS-only
O means DBCS-open (mixed)
IBM Query for iSeries 92-01-15 10:36:31
Output file record format
Output record length . . . . . . . . . 128
Output CCSID value . . . . . . . . . . 37
Field list:
Field Begin Len Dec Null Data Type Text
BREAKLVL 1 1 Character BREAK LEVEL
OVERFLOW 2 1 Character OVERFLOW FLAG
TM1USA 3 8 T Time FMT SYS
DT1EUR 6 10 L Date FMT SYSTEM
TS1 10 26 Z Timestamp FMT SYSTEM
PK2 20 8 2 Zoned decimal
ZD3 28 8 2 Zoned decimal
ID1 36 3 Character ID FIELD
VC1 39 8 V Y Variable character ’ EMPTY STRING DFT
C1 49 10 Y Character CHAR DFT *NULL
DBCSOPEN 59 8 O DBCS capable DBCS OPEN
DBCSEITH 67 8 E DBCS capable DBCS EITHER
DBCSONLY 75 8 J DBCS capable DBCS ONLY
DBCSGRPH 83 8 G Graphic DBCS GRAPHIC
DBCVOPEN 89 8 OV Variable DBCS DBCS OPEN VAR.
DBCVEITH 99 8 EV Variable DBCS DBCS EITHER VAR.
DBCVONLY 109 8 JV Variable DBCS DBCS ONLY VAR.
DBCVGRPH 119 8 GV Variable graphic DBCS GRAPHIC
182
Query for iSeries Use V5R2