IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

reading with alternate key


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
anandss6

New User


Joined: 12 Dec 2005
Posts: 7
Location: trivandrum

PostPosted: Wed Feb 20, 2008 11:09 am
Reply with quote

Hi,

I am trying to read ksds file with alternate key which is part of primary key. I have given cluster dataset in select statment and cluster and path in JCL. I passed some value to alternate key and tried to read with start key . but its giving error like record not found( even though record is availble). But its working fine when i am trying in sequential mode. could you please help somebody on this.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Wed Feb 20, 2008 3:52 pm
Reply with quote

COBOL?
Probably something wrong with the select or FD or the DD, that's my guess....
Back to top
View user's profile Send private message
shawnack

New User


Joined: 28 Jun 2007
Posts: 4
Location: India

PostPosted: Thu Jun 05, 2008 1:31 pm
Reply with quote

This is a very weird situation...even I'm facing the same problem...the problem is that if the AIX is a part of the primary key and one issues a search on that AIX...it does retrieve the correct data..but it then replaces the primary key value with the value fetched thereby modifying the actual AIX content...hence the "record not found" message..I'm sure there's a way out....
Back to top
View user's profile Send private message
shawnack

New User


Joined: 28 Jun 2007
Posts: 4
Location: India

PostPosted: Fri Jun 06, 2008 6:20 pm
Reply with quote

please disregard my previous post....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Reading dataset in Python - New Line ... All Other Mainframe Topics 22
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Rexx program reading a DSN then write... CLIST & REXX 4
No new posts Add column to existing records using ... JCL & VSAM 2
No new posts Reading subsequent rows in a query. DB2 12
Search our Forums:

Back to Top