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
 

 

Expanding vsam file which is in table(occurs 15 times)

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

New User


Joined: 07 Feb 2008
Posts: 6
Location: bangalore

PostPosted: Wed Feb 20, 2008 12:32 pm    Post subject: Expanding vsam file which is in table(occurs 15 times)
Reply with quote

i have two vsam file ...one old an one new ....

i want a 8bytes(9(08)) field to be added in the new file which is in table(occurs 15 times) .....

and all the remaining things should be same as the old file?
Back to top
View user's profile Send private message

expat

Global Moderator


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

PostPosted: Wed Feb 20, 2008 12:49 pm    Post subject:
Reply with quote

So what is the question ?
Back to top
View user's profile Send private message
rakeshahgnug
Currently Banned

New User


Joined: 07 Feb 2008
Posts: 6
Location: bangalore

PostPosted: Wed Feb 20, 2008 12:57 pm    Post subject: Reply to: expanding vsam file :?:
Reply with quote

my question is ....

i need to cr8 a new file ....... which is same as the old file but for the new 8 bytes(which is in the table) .........??
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Wed Feb 20, 2008 1:11 pm    Post subject: Re: Reply to: expanding vsam file :?:
Reply with quote

rakeshahgnug wrote:
my question is ....

i need to cr8 a new file ....... which is same as the old file but for the new 8 bytes(which is in the table) .........??

You are making a statement, and we do not know what you want to do unless you tell us.

If the eight byte field occurs 15 times, then shouldn't you want to add 120 bytes to the record rather than 8 ???
Back to top
View user's profile Send private message
rakeshahgnug
Currently Banned

New User


Joined: 07 Feb 2008
Posts: 6
Location: bangalore

PostPosted: Wed Feb 20, 2008 1:39 pm    Post subject: Reply to: expanding vsam file :?:
Reply with quote

thanks for the reply,

ya i'm adding 120 bytes ......

can anyone tell me the technique to do it?

e.g (old layout)
01 record.
05 key.
10 key1 pic 9(10).
10 key2 occurs 15 times.
15 code pic x(04).
10 key3 pic 9(10).

(new layout which i need)
01 record.
05 key.
10 key1 pic 9(10).
10 key2 occurs 15 times.
15 code pic x(04).
15 extra pic 9(08).
10 key3 pic 9(10).
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Wed Feb 20, 2008 5:00 pm    Post subject:
Reply with quote

What is the current definition for the VSAM file ?
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: Wed Feb 20, 2008 10:04 pm    Post subject:
Reply with quote

Hello,

Define an "old" fd and a "new" fd (using the record layouts you've already posted).

Read the old format and write the new format.

That should do it. . .

If i've misunderstood, please clarify.
Back to top
View user's profile Send private message
rakeshahgnug
Currently Banned

New User


Joined: 07 Feb 2008
Posts: 6
Location: bangalore

PostPosted: Thu Feb 21, 2008 4:16 pm    Post subject: this is not the reply to my questions
Reply with quote

icon_question.gif
Back to top
View user's profile Send private message
rakeshahgnug
Currently Banned

New User


Joined: 07 Feb 2008
Posts: 6
Location: bangalore

PostPosted: Thu Feb 21, 2008 4:17 pm    Post subject: reply
Reply with quote

this was not answer to my questions icon_question.gif icon_rolleyes.gif
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Thu Feb 21, 2008 4:30 pm    Post subject:
Reply with quote

expat wrote:
What is the current definition for the VSAM file ?

Just maybe, if you supplied what you are asked to supply, rather than sitting back and waiting for us to guess your VSAM definition we might actually get somewhere towards solving your problem.

In fact I am guessing right now that what you want is to define the correct VSAM file for your new file layout.
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: Thu Feb 21, 2008 8:55 pm    Post subject:
Reply with quote

Hello,

Did you not post the "old" and "new" file layouts?

Do you not need to copy from one to the other?

Quote:
this was not answer to my questions
Well, it was an answer to what you posted. . .

Which part of read one and copy to the other does not meet your need?

You probably have (in your own mind) a clear idea of what you want, but you have done little to explain it to the forum. Due to the high number of people who read these topics, i'm sure some will actually guess just what you meant, but that will not be due to a proper problem definition.

As i mentioned, i might not understand what you are asking, but the answer given goes with what you asked.

If you take a bit of time and better present your requirement, you will probably get replies more to your liking.
Back to top
View user's profile Send private message
rakeshahgnug
Currently Banned

New User


Joined: 07 Feb 2008
Posts: 6
Location: bangalore

PostPosted: Mon Feb 25, 2008 11:06 am    Post subject: Reply to: Expanding vsam file which is in table(occurs 15 ti
Reply with quote

guys thank u for ur help ..... i got it!

may be even i had only this much idea ..........which i put in front of u guys.... i couldnt do nething better than that

neways thanks again!
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 Feb 25, 2008 8:13 pm    Post subject: Reply to: Expanding vsam file which is in table(occurs 15 ti
Reply with quote

Hello,

Quote:
guys thank u for ur help ..... i got it!
You're welcome icon_smile.gif If you post your reolution, it may help someone else with a similar question later.

Quote:
may be even i had only this much idea ..........which i put in front of u guys.... i couldnt do nething better than that
Learning to have a technical discussion in other than one's primary language can be quite frustrating, but i believe you will find it very valuable.

Good luck icon_smile.gif

d
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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am


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