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

What does offset in IDCAMS for KSDS mean?


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

New User


Joined: 30 Jan 2009
Posts: 8
Location: Manila

PostPosted: Fri Feb 27, 2009 2:17 pm
Reply with quote

Hi,

I was looking thru the net and in qw and wasn't able to find what offset means in the define in idcams..

here is the syntax:
DEFINE CLUSTER
(NAME(entryname)
:
VOLUMES(vol1 { vol2... })
{ INDEXED | LINEAR | NONINDEXED | NUMBERED }
{ KEYS(length offset | 64 0) }
{ RECORDSIZE(avg max) }
)
{ DATA () }
{ INDEX () }

here is my question:
for the KEYS(length offset | 64 0)
1. what does offset mean?
2. what's 64 and 0? and how can it be used?

Thanks in advance!
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Feb 27, 2009 3:04 pm
Reply with quote

Figure it is easier to just type a question instead of reading the documentation? Try using ibm's server for documentation:
here is the 390 library: publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/library
here is the z/os V1R7 library: publibz.boulder.ibm.com/bookmgr_OS390/libraryserver/zosv1r7/

change the version number in the URL for others.

The www is handy for info, but would suggest that you access documentation that is specific for your environment via IBM documentation library.

OFFSET (relative position) as apposed to column number/position number:

column/position number starts at 1 and goes to length of object

offest starts at 0 and goes to the length of the object - 1.

so, keys(length,offset 64,0) means:
keys has a total length of 64, starts at offset 0 (or position 1) within the record.
Back to top
View user's profile Send private message
icemanster

New User


Joined: 30 Jan 2009
Posts: 8
Location: Manila

PostPosted: Fri Feb 27, 2009 4:43 pm
Reply with quote

Thanks alot! I understand it now... I will now read the link you gave.. thanks again!
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 VSAM KSDS CREATION AND LOAD WITH RAND... JCL & VSAM 1
No new posts IDCAMS listcat service using cobol JCL & VSAM 1
No new posts Printing a dataset in DUMP format wit... ABENDS & Debugging 2
No new posts Using sort on VB records based on off... DFSORT/ICETOOL 6
Search our Forums:

Back to Top