View previous topic :: View next topic
|
Author |
Message |
vishalbshah
New User
Joined: 01 Dec 2006 Posts: 61 Location: Pune
|
|
|
|
[quote]
This is my record structure
01 INTERFACE-RECORD.
05 ACCOUNT-NUMBER PIC X(17).
05 ACCOUNT-TYPE PIC X(03).
05 ICS-TRAN-CODE PIC 9(06).
05 TRANS-AMOUNT PIC 9(08)V99.
05 ICS-SEQUENCE-NUMBER PIC 9(10).
This is a flat file and i want make one vsam with
ACCOUNT-NUMBER and ICS-SEQUENCE-NUMBER as a key how can i write two lengths and two offsets in the KEYS parameter while defining a cluster. [/b] |
|
Back to top |
|
|
mallikannasagaram
New User
Joined: 21 Feb 2006 Posts: 9 Location: india
|
|
|
|
If changing of the record layout is OK then move the required fields together from the first (move ICS-SEQUENCE-NUMBER to the 2 colum in your record layout) and specify key as total length of two fields(27bytes). This fulfills yourrequirement.
Regards,
Mallik |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
He's right, no split keys allowed. |
|
Back to top |
|
|
vishalbshah
New User
Joined: 01 Dec 2006 Posts: 61 Location: Pune
|
|
|
|
Hi Malik,
i thought of this way i just wanted to know if any other option is possible so as you are saying no split keys allowed the i left with only one option.
that is same as you suggest
Thanks,
Vishal |
|
Back to top |
|
|
|