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

Browse VSAM in absence of few starting Characters of the key


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA

PostPosted: Wed Nov 05, 2014 3:36 pm
Reply with quote

HI All,

I have the Below Requirements

KSDS Key starting form 1st to 54th Position

I have to search on the position starting form 5 to 16 ( 11 Characters)

I am trying a STARTBR and then Read-Next till the record found but it abends with AEIT perhaps because of AEIT ..

Can you help me to understand if I am doing it in incorrect way and some other way required to browse the file .. can we browse VSAM when we dont have several starting characters of key?

Please let me know if I am not clear above or missing anything. Thanks in Advance!!
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Wed Nov 05, 2014 4:17 pm
Reply with quote

Unless you use an Alternate Key, you can only read the entire file picking the records you want (not a good idea).
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA

PostPosted: Wed Nov 05, 2014 4:34 pm
Reply with quote

Thanks for your response Bill .. These files are the part of a Legacy system and by used all the screens .. IN this case I guess we can not approach in this way and accesses the path of the file.

I also don't want to go by reading one to one records and was looking for alternate way
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Wed Nov 05, 2014 4:57 pm
Reply with quote

How else the file(s) are used does not affect the use of an alternate key for your need. Or shouldn't.

If you can explain a bit more, you may get some suggestions.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Wed Nov 05, 2014 7:45 pm
Reply with quote

Alternate way is to use an alternate key.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Nov 05, 2014 8:06 pm
Reply with quote

defining an alternate index will only impact the CICS files definitions and startup JCLs

and obviously the program ( probably new ) using it

existing programs will NOT be impacted
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 -> CICS

 


Similar Topics
Topic Forum Replies
No new posts HILITE on Browse mode? TSO/ISPF 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Substring number between 2 characters... DFSORT/ICETOOL 2
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts Reading dataset in Python - New Line ... All Other Mainframe Topics 22
Search our Forums:

Back to Top