Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ 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
View previous topic :: :: View next topic  
Author Message
Vidya Bhama

New User


Joined: 17 Sep 2008
Posts: 41
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

Sinkaravelan S

New User


Joined: 21 Apr 2008
Posts: 27
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

Active Member


Joined: 13 Jun 2007
Posts: 826
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: 41
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

Active Member


Joined: 13 Jun 2007
Posts: 826
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

Active Member


Joined: 13 Jun 2007
Posts: 826
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
itssreehere
Warnings : 1

New User


Joined: 10 Jan 2006
Posts: 65
Location: chennai

PostPosted: Tue Jun 28, 2011 12:32 pm    Post subject: Reply to: GN Call with qualified SSA
Reply with quote

I was searching for the reolution for a similar issue and saw this posting. Though this is an old post I thought this reply will be helpful for someone in future.

I was issuing a boolean call to a DB using partial key and unknown part of the key was populated with Low-values and high-values. Still the call returned 'GE' though there were many data present in the DB satisfying the condition.

When I checked in the database data was not stored in the physical sequence of the key field. In DBD the dataset access method was HDAM and for HDAM databases it is not mandatory to have key fields in sequence. This created the issue. I was able to retrieve the data in the format I wanted by including a secondary index (VSAM) created on the same keyfield in the PSB and PCB mask the database calls were changed accordingly. So my understanding is that boolean calls with partial keys may not return the expected result if the data is not in physical sequence of the key in the DB.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts Need help in triggering a PL1 module ... Varungv99 IMS DB/DC 0 Fri Apr 07, 2017 10:01 am
No new posts Cobol EZASOKET call to SETSOCKOPT fails Andi1982 COBOL Programming 6 Thu Oct 06, 2016 7:12 pm
No new posts Strange EXEC function call in z/VM Willy Jensen CLIST & REXX 3 Wed Oct 05, 2016 2:07 pm
No new posts COBOL DB2 - CALL statement - high CPU... TS70363 DB2 15 Sun Sep 11, 2016 6:07 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us