IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Using Partial key on Secondary index


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Paresh0459

New User


Joined: 22 May 2007
Posts: 8
Location: Mumbai

PostPosted: Mon Aug 23, 2010 6:27 am
Reply with quote

Hi,
I have a secondary index defined for database. the secondary index has two fields Record number and date. Record number is also part of primary index.

The date is not always present in input so I need to get records that match record number. A search with Record number alone can get multiple records and same might happen when both record number and date are given. This is possible because record number has suffix which varies for multiple entries for a particular date.

I want to know how can i access database through secondary index/key when i only have record number. What do I need to specify for date so that I get all the record numbers?

Thanks in advance.
Paresh
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 Aug 23, 2010 5:20 pm
Reply with quote

So, record number comes before date?
Back to top
View user's profile Send private message
Paresh0459

New User


Joined: 22 May 2007
Posts: 8
Location: Mumbai

PostPosted: Mon Aug 23, 2010 5:25 pm
Reply with quote

Yes..record number is first entry.
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 Aug 23, 2010 5:32 pm
Reply with quote

Can you post your SSA and your key fields? Where are you getting your record number?
Back to top
View user's profile Send private message
Paresh0459

New User


Joined: 22 May 2007
Posts: 8
Location: Mumbai

PostPosted: Mon Aug 23, 2010 9:00 pm
Reply with quote

Thats what my questions is about.
I'm not sure how can I can access database using secondary key, so wanted to know how should i build up my SSA.

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: Mon Aug 23, 2010 9:13 pm
Reply with quote

Yes - you can. You need to show us what your key fields look like.

A few years ago I built a system with 5 secondary indices. I built many online functions around those keys.
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 Execute secondary panel of sdsf with ... CLIST & REXX 1
No new posts Cobol file using index COBOL Programming 2
No new posts Find the occurrence of Key Field (Par... DFSORT/ICETOOL 6
No new posts DL/I status code AK for GU call using... IMS DB/DC 1
No new posts Add column to existing records using ... JCL & VSAM 2
Search our Forums:

Back to Top