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: 2454
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 Help required to reset decimal points... DFSORT/ICETOOL 10
No new posts Sorting Date Field DFSORT/ICETOOL 4
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Using Java/C/C++ to retrieve dataset ... Java & MQSeries 6
No new posts Join 2 files according to one key field. JCL & VSAM 3
Search our Forums:

Back to Top