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