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

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


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 8797
Location: Welsh Wales

PostPosted: Wed Feb 20, 2008 12:49 pm
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
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: 8797
Location: Welsh Wales

PostPosted: Wed Feb 20, 2008 1:11 pm
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
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: 8797
Location: Welsh Wales

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

What is the current definition for the VSAM file ?
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: Wed Feb 20, 2008 10:04 pm
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
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
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: 8797
Location: Welsh Wales

PostPosted: Thu Feb 21, 2008 4:30 pm
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

Moderator Emeritus


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

PostPosted: Thu Feb 21, 2008 8:55 pm
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
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

Moderator Emeritus


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

PostPosted: Mon Feb 25, 2008 8:13 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top