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
 

 

Using Partial key on Secondary index

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
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    Post subject: Using Partial key on Secondary index
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    Post subject:
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    Post subject: Reply to: Using Partial key on Secondary index
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    Post subject:
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    Post subject: Reply to: Using Partial key on Secondary index
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    Post subject:
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    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 Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm
No new posts SFTP to primary and secondary servers mallik4u JCL & VSAM 4 Tue Jun 07, 2016 12:52 pm
No new posts VSAM Alternate Index in CICS jacobdng CICS 2 Fri May 06, 2016 1:41 pm


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