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

How to exclude Spaces in Alternate Index


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
jagan_infotech

New User


Joined: 08 Feb 2007
Posts: 1
Location: Trivandrum

PostPosted: Sat Apr 24, 2010 1:59 am
Reply with quote

Hi,

Am trying to create a VSAM file and an Alternate index. Since my alternate key contains many (more than 40000) spaces, I want to exclude them while building index.

Will the option KEYRANGES work for this? If so, could you give me the syntax for this.


Thanks,
Jagan S.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat Apr 24, 2010 2:05 am
Reply with quote

Hello and welcome to the forum,

At the top of the page is a link to "IBM Manuals". Suggest you become familiar/comfortable with these. . .

Quote:
Will the option KEYRANGES work for this?
If the manual can be believed, no. . .

IBM wrote:
KEYRANGES((lowkey highkey)[(lowkey highkey)...])
KEYRANGE is no longer supported; If you specify this parameter, VSAM ignores it, and no message is issued.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Sat Apr 24, 2010 2:43 am
Reply with quote

Quote:
Am trying to create a VSAM file and an Alternate index. Since my alternate key contains many (more than 40000) spaces, I want to exclude them while building index.
Huh? An alternate includes all of the records -- excluding some of the records makes absolutely no sense when you think of the purpose of an alternate index. Either you need to explain more what you think your problem is, or explain why you think you need to exclude some of your records from the alternate index (which cannot be done, anyway, so your thinking is WAY off base already).
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 Exclude rows with > than x occurre... DFSORT/ICETOOL 6
No new posts leading spaces can be removed in trai... DFSORT/ICETOOL 1
No new posts Cobol file using index COBOL Programming 2
No new posts Cobol program with sequence number ra... COBOL Programming 5
No new posts To Remove spaces (which is in hex for... JCL & VSAM 10
Search our Forums:

Back to Top