To delete a Field ID you must view all data fields as a list, to do so press F4. This list is in Sequence # order and you may position to a particular Field ID or Sequence # if known. To delete a field ID key a 4 next to the desired field ID and press enter. There is NO undo, once a field is deleted it and all of the data in that Field ID is lost. If you delete fields you will have to rebuild the files using Regenerate.
You need to be very careful when you delete existing fields because of the data that might be in the field and or how the field might be used on another Data Layout. The data in the field might also be of historical importance. Review all data in a field by using a query product such as IBM's Query for the iSeries prior to deleting a field.
The following sample list starts with many of the System Protected Fields (but not all) and continues with custom designed Fields following. It is only a sample list and may not look like yours. Please note that in this sample list the System Administrator physically changed the Sequence #'s so that they were in order by type of Field.
. . . . . . . . . . . . . . . . .Database Definition Module |
List order: Sequence # |
|||||||||||
Type options,
press Enter. |
Position to Seq#: _____ |
|||||||||||
O |
Seq# |
Field |
Layout 1 |
Layout 2 |
Layout 3 |
lgth |
a/n |
dec |
edit |
u/l |
entry |
protect code |
_ |
10 |
PID |
Primary ID |
Primary ID |
Primary ID |
10 |
A |
0 |
U |
Y |
K |
|
_ |
20 |
SID |
Secondary |
Secondary |
Secondary |
10 |
A |
0 |
U |
Y |
K |
|
_ |
30 |
RCL |
Tertiary I |
Tertiary I |
Tertiary I |
15 |
A |
0 |
U |
Y |
K |
|
_ |
40 |
COM |
Company |
Company |
Company |
30 |
T |
0 |
L |
Y |
L |
|
_ |
50 |
CON |
Contact |
Contact |
Contact |
30 |
A |
0 |
L |
Y |
L |
|
_ |
60 |
AD1 |
Address |
Address |
Address |
30 |
A |
0 |
L |
Y |
L |
|
_ |
70 |
AD2 |
Address |
Address |
Address |
30 |
A |
0 |
L |
Y |
L |
|
_ |
80 |
CIT |
City |
City |
City |
20 |
N |
0 |
L |
Y |
L |
|
_ |
90 |
TL1 |
Phone |
Phone |
Phone |
20 |
N |
0 |
L |
Y |
L |
|
_ |
100 |
TL2 |
Phone |
Phone |
Phone |
20 |
N |
0 |
L |
Y |
L |
|
_ |
110 |
TL3 |
|
|
|
20 |
N |
0 |
L |
Y |
||
_ |
120 |
TL4 |
Phone |
Phone |
Phone |
20 |
A |
0 |
L |
Y |
||
_ |
130 |
OWN |
Owner |
Owner |
Owner |
10 |
A |
0 |
L |
Y |
S |
|
_ |
140 |
ZIP |
Zip Code |
Zip Code |
Zip Code |
10 |
A |
0 |
U |
Y |
L |
|
_ |
150 |
RC2 |
Tertiary # |
Tertiary # |
Tertiary # |
8 |
A |
0 |
U |
Y |
||
_ |
160 |
A01 |
Industry T |
*BLANK |
Notes: |
22 |
A |
0 |
L |
Y |
||
_ |
170 |
A02 |
Type* |
*BLANK |
CPUSerial# |
10 |
A |
0 |
L |
Y |
||
_ |
180 |
A03 |
Claim # |
*BLANK |
*BLANK |
10 |
A |
0 |
L |
N |
||
_ |
190 |
A04 |
DELETE? |
DELETE? |
DELETE? |
1 |
A |
0 |
U |
Y |
||
_ |
200 |
D01 |
*BLANK |
Closing Date |
Service Da |
10 |
D |
0 |
L |
Y |
||
_ |
210 |
D02 |
W-9 Rcvd |
*BLANK |
Birthdate |
10 |
D |
0 |
L |
Y |
||
_ |
220 |
D03 |
Renewal |
Final QA |
*BLANK |
10 |
D |
0 |
L |
Y |
||
_ |
230 |
D04 |
Customer |
*BLANK |
Prospect |
10 |
D |
0 |
L |
Y |
||
_ |
240 |
H01 |
LEAD INFO |
PROJECTS: |
INTERES |
0 |
A |
0 |
U |
N |
||
_ |
250 |
H02 |
*BLANK |
WORK COD |
*BLANK |
0 |
A |
0 |
U |
N |
||
_ |
260 |
H03 |
BANK INFO |
SALES CYC |
*BLANK |
0 |
A |
0 |
U |
N |
||
_ |
270 |
H04 |
COMMENTS |
*BLANK |
COMMENTS |
0 |
A |
0 |
U |
N |
||
_ |
280 |
H05 |
OPPORTUN |
*BLANK |
*BLANK |
0 |
A |
0 |
U |
N |
||
_ |
290 |
H06 |
OPEN |
OPEN |
*BLANK |
0 |
A |
0 |
L |
N |
||
_ |
300 |
H07 |
*BLANK |
*BLANK |
OPEN |
0 |
A |
0 |
L |
N |
||
_ |
310 |
H08 |
*BLANK |
*BLANK |
OTHER |
0 |
A |
0 |
U |
N |
||
_ |
320 |
H09 |
*BLANK |
OPEN |
*BLANK |
0 |
A |
0 |
U |
N |
||
_ |
330 |
H10 |
STATUS |
OPEN |
STATUS |
0 |
A |
0 |
L |
N |
||
_ |
340 |
N01 |
*BLANK |
Discount |
*BLANK |
7 |
N |
0 |
J |
$ |
N |
|
_ |
350 |
N02 |
Referral Fee |
*BLANK |
*BLANK |
9 |
N |
0 |
J |
$ |
Y |
|
_ |
360 |
N03 |
% To Close |
*BLANK |
Satisfacti |
3 |
N |
0 |
3 |
Y |
||
_ |
370 |
N04 |
Total Deal |
Service |
Amount |
7 |
N |
0 |
J |
$ |
Y |