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: 154
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: 7311
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: 154
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: 7311
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: 2573
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

Senior Moderator


Joined: 14 Mar 2007
Posts: 10714
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 FILE STATUS - 39 ON VARIABLE LENGTH V... COBOL Programming 2
No new posts VSAM Alter Command - Cylinder Extent ... JCL & VSAM 3
No new posts RPLDDDD field for extended VSAM - ESDS JCL & VSAM 0
No new posts DFDSS msg ADR485E when restoring VSAM... JCL & VSAM 5
No new posts Sync logic between VSAM files and DB2... COBOL Programming 9
Search our Forums:

Back to Top