View previous topic :: View next topic
|
Author |
Message |
craig2020
New User
Joined: 30 Jan 2007 Posts: 7 Location: Chennai
|
|
|
|
Hi,
I have a VSAM file with composite key which is the first 10 bytes in the file. The fields that forms the key are SSN number and the ACCOUNT number in the same order.
My requirement is to read the file using the second partial key Account number to get the associated SSN number.
ex
SSN ACCOUNT
12345 AAAAA
Do I require AIX defined on the partial key Account number to read the file based on account number?
P.S
I tried the following two commands, both giving resp as NOTFOUND
Code: |
EXEC CICS STARTBR
DATASET (DATASET NAME)
RIDFLD (ACCT-NUM)
KEYLENGTH (5)
GENERIC
EQUAL
EXEC CICS READ
DATASET (DATASET NAME)
INTO (OUTPUT-RECORD)
RIDFLD (ACCT-NUM)
LENGTH (FILE LENGTH)
KEYLENGTH (5)
GENERIC
GTEQ |
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
Do I require AIX defined on the partial key Account number to read the file based on account number? |
Yes! |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Generic reads work left to right -- if SSN is first, you must use it to do a GENERIC read. Therefore as enrico says you will need to define an alternate index to get to the account number. |
|
Back to top |
|
|
|