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
 

 

Alternate Index for Empty KSDS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
senthildots

New User


Joined: 23 Nov 2005
Posts: 6
Location: Chennai

PostPosted: Mon Dec 18, 2006 2:57 pm    Post subject: Alternate Index for Empty KSDS
Reply with quote

Hi guys,

in my cobol program, im populating data to the ksds. then based on the alternate key im doing some consolidation.. what is the problem na, before executing this program.. i have to create ksds with alternate index.

but alternate index is not possible for empty ksds... how to do this..
i hope u guys got my question

if any one come acrross this situation pls.. help me to solve this problem.

Thanx in advance
regards
senthil.s.
Back to top
View user's profile Send private message

TizMe

New User


Joined: 05 Jan 2006
Posts: 72

PostPosted: Tue Dec 19, 2006 5:55 am    Post subject:
Reply with quote

Why not define the Cluster, populate with low values, define AIX and then delete the low value record.
Back to top
View user's profile Send private message
senthildots

New User


Joined: 23 Nov 2005
Posts: 6
Location: Chennai

PostPosted: Tue Dec 19, 2006 9:56 am    Post subject: Re: Alternate Index for Empty KSDS
Reply with quote

Hi,

I did the same what u told... but... its showing unable to update AIX. so consolidation with the help of AIX is not working... some other alternate way... pls.

Regards
senthil.s.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Tue Dec 19, 2006 3:10 pm    Post subject: Re: Alternate Index for Empty KSDS
Reply with quote

senthildots wrote:
in my cobol program, im populating data to the ksds. then based on the alternate key im doing some consolidation.

You are loading and then consolidating a keyed file in the same job?
Why can't you load the file, build the index and the consolidate it?
Back to top
View user's profile Send private message
senthildots

New User


Joined: 23 Nov 2005
Posts: 6
Location: Chennai

PostPosted: Tue Dec 19, 2006 3:46 pm    Post subject: Re: Alternate Index for Empty KSDS
Reply with quote

Hi Williams,

Thanx for the response..

im populating data in the ksds thru sql query in run time.. based on the data only im doing consolidation. i hope u got me

regards
senthil.s.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Tue Dec 19, 2006 3:52 pm    Post subject:
Reply with quote

Well, you just may not be able to do what you want in the same execution.
Is there a reason you can't break the job into multiple steps?
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
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
This topic is locked: you cannot edit posts or make replies. how to find if file is empty or not. abdulrafi DFSORT/ICETOOL 5 Tue May 17, 2016 4:39 pm


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