IBM SC41-5210-04 manual ADDRESS1, ADDRESS2, Zip, Amount

		Create and Select Field Definitions
Definition. . . . . . :			NAMEADDRR		Dictionary. . . . . . :	SYSDIC
Position to			. __________ Field, sequence (0-99999)
Type sequence numbers (0-99999), (and Field), press Enter.
Type field, press F6 to create.
Seq	Field	End	Seq	Field	End Seq Field	End
10	LASTNAME

Now press F6. You will complete the description of the LASTNAME field definition (as well as naming and describing the remainder of the field definitions) from the next display.

11.Complete the LASTNAME field description with its type, size, and any other descriptors, according to the table shown below. Then name and describe the remainder of the field definitions.

Field Name		Field Type				Size	Text
LASTNAME		Character				15	Last name
FIRSTNAME		Character				10	First name
ADDRESS1		Character				20	Address line 1
ADDRESS2		Character				20	Address line 2
CITY		Character				15	City
STATE		Character				2	State
ZIP		Character				9	Zip code
AMOUNT		Numeric, 2 decimal positions				6	Amount
				Create Field Definitions
Type information, press Enter to create.
Field type (size) . . :				1=Character (1-32766)
				2=Numeric (1-31, decimal positions 0-31)
				3=DBCS (4-32766, mixed; 1-16383, graphic)
				4=Date/Time (no size)
More options. . . . . :				Y=Yes
-------Field---------			Dec More
Name	Type Size		Pos	Opt	Text
LASTNAME	1	15	__	_	Last name
FIRSTNAME	1	10	__	_	First name
ADDRESS1	1	20	__	_	Address line 1
ADDRESS2	1	20	__	_	Address line 2
CITY	1	15	__	_	City
STATE	1	2	__	_	State
ZIP	1	9	__	_	Zip code
AMOUNT	2	6	2	_	Amount

12.When you have completed specifying the field characteristics, press the Enter key. The Create Field Definitions display is shown again, and your fields have been created.

Appendix B. Practice exercise for Query for iSeries query 201