Reading one database record

ksivapradeep · New User Joined: 30 Jul 2004 Posts: 95

Hi all,

Can any body can tell me how to read only one database record in set of n database records. i want to terminate my program after reading one(may be 1st one or in the middle) database record. how can i do that

Thnaks&Regards,
pradeep

radhakrishnan82 · Posted: Wed Aug 31, 2005 3:41 pm

The following will fetch first row only.

ksivapradeep · New User Joined: 30 Jul 2004 Posts: 95

Hi radhakrishnan,

I am asking in IMS DB not in DB2, i think you r missunderstand

regards,
pradeep

radhakrishnan82 · Posted: Thu Sep 01, 2005 10:31 am

oh ya.misunderstood the topic section.
sorry for the inconvenience caused.

priyesh.agrawal · Posted: Thu Sep 01, 2005 4:00 pm

Hi Pradeep,

May be it is not so simple, what I m thinking.
But dont we set a Counter after every CALL. If the Call is fine, you get the record. Checking the counter value you can STOP RUN any time.

Please give your thoughts....

Regards,

Priyesh.

radhakrishnan82 · Posted: Thu Sep 01, 2005 4:41 pm

Normally in IMS,we fetch records till end of database condition.Putting it a loop and fetch all the records till end of condition.To Fetch one record,set End of database condition after the first record is fetched.

ksivapradeep · New User Joined: 30 Jul 2004 Posts: 95

Hi radhakrishnan,

Thanks for reply, what is my poing is we can put the EOF database(GB) condition but how can we know that the call was fetched only one record thats the thing. suppose we can check with the GA status code since it occurs when the ims control moved to next record but the prob in that is it also come when we had the twin segents in the heirarchy that is the problem, any way i will think it off and let u know ok

thanks,
pradeep

priyesh.agrawal · Posted: Fri Sep 02, 2005 12:44 pm

Hi Pradeep,

ksivapradeep · New User Joined: 30 Jul 2004 Posts: 95

Hi priyesh,

Can you give me the example code to how to set the counter along with the GB, I unable to think about that. actually this is interview question so i cant provide the code, sorry for that

Thanks & Regards,
pradeep

priyesh.agrawal · Posted: Fri Sep 02, 2005 6:43 pm

Hi Pradeep,

Please check the earlier link, I remember on counters... & see whether its of use....
http://www.ibmmainframes.com/viewtopic.php?t=4161

Else I'll try to male it more elaborate...

Regards,

Priyesh.

ksivapradeep · New User Joined: 30 Jul 2004 Posts: 95

Hi priyesh,

I think its not the exact one, can you explain please

Thanks & Regards,
pradeep

priyesh.agrawal · Posted: Fri Sep 02, 2005 8:20 pm

Hi Pradeep,

I try to make in brief...

ksivapradeep · New User Joined: 30 Jul 2004 Posts: 95

Hi priyesh,

Thanks for the reply and i got the answer what i am looking for.
now i can understand clearly whar u r going to say, till now i didnt get the thhought of GU call thats why i am this much confused sorry for that and thanks for ur patience.

Thnaks,
pradeep

varunraisharma · New User Joined: 01 Sep 2005 Posts: 15 Location: Bangalore

Please correct me if i m wrong but i think that we can make use of the command codes in the SSA in this case. For retrieving only one record we can use command code " F " in the SSA and for retrieving last record "L" can be used.
If u want to specify the path from the root segment to the last segment u can also use "D" command code.

Regards
Varun

prasanth_thavva · New User Joined: 28 Jul 2005 Posts: 86 Location: Chennai

PRADEEP,