IBM ISERIES SC41-5210-04 User Manual
Page 194
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