Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
GN Call with qualified SSA

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
Author Message
Vidya Bhama

New User


Joined: 17 Sep 2008
Posts: 8
Location: Chennai

PostPosted: Fri Oct 03, 2008 5:34 pm    Post subject: GN Call with qualified SSA
Reply with quote

What is the status code returned by a GN call with a Qualified SSA return on reaching the end of database GE or GB?
Back to top
View user's profile Send private message
References
Sinkaravelan S

New User


Joined: 21 Apr 2008
Posts: 31
Location: coimbatore-TN india

PostPosted: Mon Oct 06, 2008 2:13 pm    Post subject: Reply to: GN Call with qualified SSA
Reply with quote

Vidya,

GB - End of DB reached
GE - Segment not found


and also this one of the important interview question..so study well each and every concept in ims ..

Thanks,
Back to top
View user's profile Send private message
Sandy Zimmer

Senior Member


Joined: 13 Jun 2007
Posts: 443
Location: Wilmington, DE

PostPosted: Thu Oct 09, 2008 5:21 pm    Post subject:
Reply with quote

The most important concept of IMS is POSITION. IMS is very smart. It knows where it is.

For instance - think about doing a path insert with 2 higher level fully qualified SSA. You do not get spaces in your return status code. What happened? You think maybe the segment was already there, but your status code is NOT II. It is GE. GE indicates not found. Now look at the segment level returned and you will know on which of your fully qualified key ssa statements was in error.
Back to top
View user's profile Send private message
Vidya Bhama

New User


Joined: 17 Sep 2008
Posts: 8
Location: Chennai

PostPosted: Fri Oct 10, 2008 2:19 pm    Post subject: Reply to: GN Call with qualified SSA
Reply with quote

Hi,

Thanks for the reply.
My program makes a GN call with the primary key for the database which is
num PIC 9(6)
dept PIC X(3).

In the program, I supply the value to the partial Key "NUM" only and use "LOW VALUES" for Dept. When I make the GN call it gives me a code "GE" even if the NUM value is present in the database.

my SSA checks for NUMDEPT >= DB primary key.
Can you please explain this behaviour.
Back to top
View user's profile Send private message
Sandy Zimmer

Senior Member


Joined: 13 Jun 2007
Posts: 443
Location: Wilmington, DE

PostPosted: Fri Oct 10, 2008 6:15 pm    Post subject:
Reply with quote

Are you using a boolean SSA with greater or equal? I think you are using just equal and there is no such key. Try displaying the PCB concatenated key value.
Back to top
View user's profile Send private message
Sandy Zimmer

Senior Member


Joined: 13 Jun 2007
Posts: 443
Location: Wilmington, DE

PostPosted: Fri Oct 10, 2008 6:27 pm    Post subject:
Reply with quote

If you use just > you must check for a change in num value if you do not want anything other the value that you are loading. If you use a boolean, then you would load num value and load high values in the second part of the ssa for dept and < in the operator.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1