IBM SC41-5210-04 manual Breaklvl

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.

				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

vThe 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.

vThe 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.

vThe Begin column shows the starting byte of the field within the record. For example, the field named ZD3 starts at byte 28.

vThe 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.

vFor 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)

182Query for iSeries Use V5R2