Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Partial key in SSA

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
kalarani

New User


Joined: 21 Nov 2006
Posts: 6
Location: chennai

PostPosted: Sun Aug 31, 2008 1:54 pm    Post subject: Partial key in SSA
Reply with quote

The given database has two fields as keys (say fld1,fld2), but to access the database only the fld1 is available(say 123). How can I use GN/GU calls to retrieve the set of segments matching the data for fld1 with SSA.

01 SSA-1.
03 SEGMENT-NAME PIC X(8) VALUE 'SEGMENTA'.
03 COMMAND-CODE PIC X(2) VALUE '*-'.
03 BEGIN-QUALIFY PIC X(1) VALUE '('.
03 KEYNAME PIC X(8) VALUE 'AKEY '.
03 OPERATOR PIC X(2) VALUE ' ='.
03 KEY-VALUE.
05 KEY-FLD1 PIC 9(3).
05 KEY-FLD2 PIC X(3).
03 END-QUALIFY PIC X(1) VALUE ')'.

Whether the below options work
1)Can I move 'low values' to the Key-Fld2 and use the above SSA to retrieve the segments in Key-Fld1 for all the values in Key-Fld2.

eg:values in database

Key-Fld1,Key-Fld2
123,A
123,A1
123,A2

My expected result is to retrieve all the 3 segments.

2) Can I change the SSA to below layout
03 BEGIN-QUALIFY PIC X(1) VALUE '('.
03 KEY-VALUE-MIN.
05 KEY-FLD1-N PIC 9(3).
05 KEY-FLD2-N PIC X(3).
03 OPERATOR1 PIC X(2) VALUE 'GE'.
03 KEYNAME PIC X(8) VALUE 'AKEY '.
03 OPERATOR2 PIC X(2) VALUE 'LE'.
03 KEY-VALUE-MAX.
05 KEY-FLD1-x PIC 9(3).
05 KEY-FLD2-x PIC X(3).
03 END-QUALIFY PIC X(1) VALUE ')'.



with KEY-FLD1-N and KEY-FLD1-X having same value(say 123) but KEY-FLD2-N and KEY-FLD2-X values are low-values and high values respectively.
Back to top
View user's profile Send private message

Sandy Zimmer

Active Member


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

PostPosted: Mon Sep 01, 2008 8:03 am    Post subject:
Reply with quote

Are you saying that you want to retrieve ALL segments with the high order value of 123? The secondary key field does not matter? If that is true, then you will want to code a boolean ssa. Let us know and we will help.
Back to top
View user's profile Send private message
kalarani

New User


Joined: 21 Nov 2006
Posts: 6
Location: chennai

PostPosted: Mon Sep 01, 2008 8:59 am    Post subject: Reply to: Partial key in SSA
Reply with quote

Yes you are right,
I would like to retrieve ALL segments if i give key-fld1=123
Please suggest me how to write a boolean SSA.
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 Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts Read VSAM file based on a partial key seahawk789 JCL & VSAM 6 Tue Aug 19, 2014 10:26 am
No new posts Partial Distinct and converting rows ... Rajesh Haridoss DB2 10 Sat Jul 26, 2014 5:22 pm
No new posts Partial dataset name Processing in JCL l_rajendrakumar JCL & VSAM 2 Mon Jun 23, 2014 2:52 pm
No new posts TSO Find is not working on partial st... karthik_sripal TSO/ISPF 8 Tue May 14, 2013 1:51 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us