IBM SC41-5210-04 manual Yyddd

Define Result Fields

Type definitions using field names or constants and operators, press Enter.

Operators: +, -, *, /, SUBSTR, , DATE...

Field	Expression	Column Heading	Len Dec
YYDDD_____ DATE(MMDDYY)_____________________ ____________________ _____ __
	_________________________________	____________________
	_________________________________	____________________
__________	_________________________________	____________________	_____ __
	_________________________________	____________________
	_________________________________	____________________

Bottom

_______________________________________________________________________________

Field	Text		Len Dec
MMDDYY	Date field in MMDDYY format		8 L
			Bottom
F3=Exit	F5=Report	F9=Insert	F11=Display names only
F12=Cancel	F13=Layout	F20=Reorganize	F24=More keys

The commands to run the query in example 3 are:

CHGJOB DATFMT(*JUL)

RUNQRY QRY(YYDDD)

Example 3—Converting from YYDDD to MMDDYY format in Query for iSeries

The following Define Result Fields panel defines a YYDDD to MMDDYY date conversion. The conversion is done completely within the panel.

Define Result Fields

Type definitions using field names or constants and operators, press Enter.

Operators: +, -, *, /, SUBSTR, , DATE...

Field	Expression	Column Heading	Len Dec
YY________	SUBSTR(DIGITS(YEAR(YYDDD)),9,2)__ ____________________ _____ __
	_________________________________	____________________
	_________________________________	____________________
MM________	SUBSTR(DIGITS(MONTH(YYDDD)),9,2)_ ____________________ _____ __
	_________________________________	____________________
	_________________________________	____________________
DD________	SUBSTR(DIGITS(DAY(YYDDD)),9,2)___ ____________________ _____ __
	_________________________________	____________________
	_________________________________	____________________
MMDDYY____	MM__’/’__DD__’/’__YY_____	____________________	_____ __

_______________________________________________________________________________

Field	Text		Len Dec
YYDDD	Date field in YYDDD format		6	L
			Bottom
F3=Exit	F5=Report	F9=Insert	F11=Display names only
F12=Cancel	F13=Layout	F20=Reorganize	F24=More keys

Example 4—Converting from MMDDYY to YYDD format in Query for iSeries

This example shows an alternative method for the same conversion done in example 3. The conversion is done completely within the panel. This method requires that the date format for the current job must be set to MMDDYY. When this circumstance exists, the DATE function automatically does the conversion.

82Query for iSeries Use V5R2