Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to Change the Relative Record number for user wish?

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

New User


Joined: 11 Jul 2007
Posts: 54
Location: Chennai

PostPosted: Mon Jul 23, 2007 5:09 pm    Post subject: How to Change the Relative Record number for user wish?
Reply with quote

Hai All,

While we write a record in RRDS, The relative record number is automatically generated, like first records as 1 and second record 2 and so on. But I want to start the RRN from 100 means how? Please help me...


With Regards

Rajesh.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: Mon Jul 23, 2007 5:23 pm    Post subject:
Reply with quote

Probably the same way you would start a browse with a keyed file......
Back to top
View user's profile Send private message
Rajesh S
Warnings : 1

New User


Joined: 11 Jul 2007
Posts: 54
Location: Chennai

PostPosted: Mon Jul 23, 2007 5:30 pm    Post subject:
Reply with quote

Hai ,

Sorry I'm not getting you.. Please explain clearly....
Back to top
View user's profile Send private message
William Thompson

Global Moderator


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

PostPosted: Mon Jul 23, 2007 5:41 pm    Post subject:
Reply with quote

Rajesh S wrote:
Sorry I'm not getting you.. Please explain clearly....
If you do not want to begin reading from the first record after an OPEN, you will need to START BRowsing at the RIDFLD you want......
Back to top
View user's profile Send private message
Rajesh S
Warnings : 1

New User


Joined: 11 Jul 2007
Posts: 54
Location: Chennai

PostPosted: Mon Jul 23, 2007 5:54 pm    Post subject:
Reply with quote

Hai ,

Thats not my problem. My problem is While write a record in new RRDS, RRN of that record is 1. RRN is automatically generated. Now I want to
Start the RRN as 100 for the first record means???

You understood my question???
Back to top
View user's profile Send private message
William Thompson

Global Moderator


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

PostPosted: Mon Jul 23, 2007 5:58 pm    Post subject:
Reply with quote

You want to start writing a new dataset and have the first record in that dataset be RRN #100?
Or start re-writing an existing dataset at RRN #100?
Back to top
View user's profile Send private message
Rajesh S
Warnings : 1

New User


Joined: 11 Jul 2007
Posts: 54
Location: Chennai

PostPosted: Mon Jul 23, 2007 6:15 pm    Post subject:
Reply with quote

This is my question....

I want to start writing a new data set and have the first record in that dataset be RRN?
Back to top
View user's profile Send private message
Rajesh S
Warnings : 1

New User


Joined: 11 Jul 2007
Posts: 54
Location: Chennai

PostPosted: Mon Jul 23, 2007 6:17 pm    Post subject:
Reply with quote

I want RRN number start with 100....
Back to top
View user's profile Send private message
William Thompson

Global Moderator


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

PostPosted: Mon Jul 23, 2007 6:25 pm    Post subject:
Reply with quote

You can't, not with a RRN file...you do realize that RRN satand for Relative Record Number, don't you? And that is relative to the beginning of the file, so the first record would always be #1 and the hundredth would always be #100........
Back to top
View user's profile Send private message
Rajesh S
Warnings : 1

New User


Joined: 11 Jul 2007
Posts: 54
Location: Chennai

PostPosted: Mon Jul 23, 2007 6:37 pm    Post subject:
Reply with quote

Thanks for your kind information... But i'm thinking that we can make the relative record number for starting record in the RRDS as user wish? And rest of the records are sequential 101,102,103.... so on..
Back to top
View user's profile Send private message
William Thompson

Global Moderator


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

PostPosted: Mon Jul 23, 2007 6:42 pm    Post subject:
Reply with quote

Fine with me......
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8620
Location: Back in jolly old England

PostPosted: Mon Jul 23, 2007 6:45 pm    Post subject:
Reply with quote

Why would you want to start from 100 ?

And if you think about the problem the solution is relatively easy.

But there again why not consider the use of an INDEXED file, such as a KSDS.
Back to top
View user's profile Send private message
Rajesh S
Warnings : 1

New User


Joined: 11 Jul 2007
Posts: 54
Location: Chennai

PostPosted: Mon Jul 23, 2007 6:55 pm    Post subject:
Reply with quote

But my question is We make the RRN start with 100 or not?

Is it possible....?????
Back to top
View user's profile Send private message
William Thompson

Global Moderator


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

PostPosted: Mon Jul 23, 2007 6:59 pm    Post subject:
Reply with quote

No.

WRITE for relative files
For OUTPUT files, the WRITE statement causes the following actions:
v If ACCESS IS SEQUENTIAL is specified: The first record released has relative record number 1, the second record released has relative record number 2, the third number 3, and so on.
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Mon Jul 23, 2007 8:14 pm    Post subject:
Reply with quote

Hello,

You need to use the technology as it is implemented - it will not change to meet some "user wish".

If your user wants to see things begin with 100 - fine, but you will have to provide that. A relative record number will not.
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 Change NULL indicator in UNLOAD utility Khadhar Basha DB2 2 Fri Dec 15, 2017 3:01 pm
No new posts query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm
No new posts Squeeze record left so that zeroes ar... Vignesh Sid SYNCSORT 5 Fri Nov 10, 2017 1:40 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us