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

Alternate Index for Empty KSDS


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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
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
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: 3156
Location: Tucson AZ

PostPosted: Tue Dec 19, 2006 3:10 pm
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
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: 3156
Location: Tucson AZ

PostPosted: Tue Dec 19, 2006 3:52 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts Cobol file using index COBOL Programming 2
No new posts Insert trailer for non empty file only DFSORT/ICETOOL 6
No new posts EMPTY file check scenario JCL & VSAM 6
No new posts DL/I status code AK for GU call using... IMS DB/DC 1
Search our Forums:

Back to Top