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

Retrieve Key field from IMS DB by searching by another field


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rexx77

New User


Joined: 14 Apr 2008
Posts: 78
Location: Mysore

PostPosted: Sat Oct 12, 2013 10:31 am
Reply with quote

Hi All,

IMS DBD:

Field A - Key

Field B -

I am working on a below requirement.

1. Fetch Account from DB2 table.
2. For each account fetched, move the account to field B and query IMS DB and retrieve field A.

But i am getting an status code AK by doing like this. The field B is available in the DBD.

I want to report he Field A, and i dont know the contents of Field A.

Please give me your valuable suggestion how to retrive Key field from IMS by searching by Non-Key field.

Regards
Seeni
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Sat Oct 12, 2013 7:00 pm
Reply with quote

create an alternate index on account
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 -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Unable to retrieve Datasets Names usi... CLIST & REXX 20
No new posts How to read unpacked field created in... DFSORT/ICETOOL 12
No new posts Negative value - packed field - Natur... Java & MQSeries 0
This topic is locked: you cannot edit posts or make replies. Passing a field name to COBOL program COBOL Programming 10
No new posts BMS map length field greater than zero CICS 3
Search our Forums:

Back to Top