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
__________ _
_____ __
_
_____________________________________________
__________ _
_____ __
_
_____________________________________________
__________ _
_____ __
_
_____________________________________________
Press the Enter key without making any changes to the display.
13. When you see the Create and Select Field Definitions display,
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
Seq
Field
End
10
LASTNAME
15
10
FIRSTNAME
25
10
ADDRESS1
45
10
ADDRESS2
65
10
CITY
80
10
STATE
82
10
ZIP
91
10
AMOUNT
95
verify that the field names are arranged in the proper sequence. (When sequence numbers are the
same, the arrangement of the field names on the display determines the sequence of use in the
record.) If a field is out of sequence, type the necessary sequence numbers to indicate the correct
arrangement, and press the Enter key. When the fields are in the proper sequence, press the Enter
key without making any changes to the display.
14. You will then see the Work with File Definitions display where
Work with File Definitions
Dictionary. . . . . . . : SYSDIC
Position to . . . . . . . _____________ Starting characters
Type options (and File Definition), press Enter.
1=Create
2=Change
3=Copy
4=Delete
6=Print
7=Rename
8=Display where used
File
Opt Definition
202
Query for iSeries Use V5R2
Summary of Contents for ISERIES SC41-5210-04
Page 1: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Page 2: ......
Page 3: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Page 12: ...x Query for iSeries Use V5R2 ...
Page 14: ...2 Query for iSeries Use V5R2 ...
Page 32: ...20 Query for iSeries Use V5R2 ...
Page 38: ...26 Query for iSeries Use V5R2 ...
Page 44: ...32 Query for iSeries Use V5R2 ...
Page 116: ...104 Query for iSeries Use V5R2 ...
Page 122: ...110 Query for iSeries Use V5R2 ...
Page 146: ...134 Query for iSeries Use V5R2 ...
Page 150: ...138 Query for iSeries Use V5R2 ...
Page 174: ...162 Query for iSeries Use V5R2 ...
Page 178: ...166 Query for iSeries Use V5R2 ...
Page 196: ...184 Query for iSeries Use V5R2 ...
Page 198: ...186 Query for iSeries Use V5R2 ...
Page 204: ...192 Query for iSeries Use V5R2 ...
Page 205: ...Part 4 Appendixes Copyright IBM Corp 2000 2002 193 ...
Page 206: ...194 Query for iSeries Use V5R2 ...
Page 210: ...198 Query for iSeries Use V5R2 ...
Page 242: ...230 Query for iSeries Use V5R2 ...
Page 256: ...244 Query for iSeries Use V5R2 ...
Page 270: ...258 Query for iSeries Use V5R2 ...
Page 272: ...260 Query for iSeries Use V5R2 ...
Page 292: ...280 Query for iSeries Use V5R2 ...
Page 293: ......
Page 294: ... Printed in U S A SC41 5210 04 ...