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
 

 

record layout change

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests
View previous topic :: :: View next topic  
Author Message
samarjeet singh

New User


Joined: 17 Jun 2011
Posts: 1
Location: india

PostPosted: Mon Jun 20, 2011 10:11 am    Post subject:
Reply with quote

1. We have a VSAM file A having following layout.

Org 9(3)

Acct X(19)

Name X(30)

Status X

Addr 1 X(30)

Addr 2 X(30)

State X(10)

Pin X(10)

Filler X(26)

Age 9(03)

DOB X(8)



We want to add 2 new fields in the file without changing the length of the file.

Loan Eligibility 9(17) Comp-3

Number of Years 9(02)



Where will you suggest to add these fields? What will be the new layout of the file?
Back to top
View user's profile Send private message

Dsingh29

Active User


Joined: 16 Dec 2008
Posts: 132
Location: IBM

PostPosted: Mon Jun 20, 2011 10:55 am    Post subject:
Reply with quote

Hi There,

Did you went through any Mainframe training ?

Fillers are meant for this purpose.
You could have asked any of your colleagues at work (would have taken you lesser time) instead of posting here on an year old thread.
Back to top
View user's profile Send private message
gudguy.deepak

New User


Joined: 29 Sep 2010
Posts: 3
Location: Hyderabad, India

PostPosted: Mon Jun 20, 2011 11:20 am    Post subject:
Reply with quote

Hi there,
Quote:
Hi There,

Did you went through any Mainframe training ?

Fillers are meant for this purpose.
You could have asked any of your colleagues at work (would have taken you lesser time) instead of posting here on an year old thread.


thanks for guiding him. well what needs to be done when you are changing the layout permanently and getting it replaced with the newone.
The REDEFINE clause wont seem to work since there is a complete replacement of file layout.
Dsingh29, can you suggest a conversion Program for the above requisite. ?
Back to top
View user's profile Send private message
Dsingh29

Active User


Joined: 16 Dec 2008
Posts: 132
Location: IBM

PostPosted: Mon Jun 20, 2011 11:39 am    Post subject:
Reply with quote

Can you please elaborate on the purpose of this VSAM file? Is it being used for reading or for writing in the program.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7225

PostPosted: Mon Jun 20, 2011 11:48 am    Post subject:
Reply with quote

samarjeet singh wrote:
[...]

Filler X(26)

[...]
We want to add 2 new fields in the file without changing the length of the file.

Loan Eligibility 9(17) Comp-3

Number of Years 9(02)

Where will you suggest to add these fields? What will be the new layout of the file?


Do you mean without changing the length of the record? One might go with the other, but seems an unusual way to say things.

Why do you need help from us to change your record layout? Is there no-one else in your organisation? You have a spec? Any colleagues? A boss?

It has already been pointed out to you where to make the change. Try to make a good job of it so that the size of the FILLER now is equal to size of new fields plus size of new FILLER. What do you have in a COMP-3 9(17) without a sign, without decimal places? What is the maximum sort of value you expect in the field?
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7225

PostPosted: Mon Jun 20, 2011 11:56 am    Post subject:
Reply with quote

gudguy.deepak wrote:

[...]

... well what needs to be done when you are changing the layout permanently and getting it replaced with the newone.
The REDEFINE clause wont seem to work since there is a complete replacement of file layout.
[...]


I have no idea what you are trying to say. It's Monday morning, so I'll leave it at that and wait until you've had tea-and-biscuits, opened your eyes and put your brain in gear.

Oh, it's only the morning here...
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Mon Jun 20, 2011 11:59 am    Post subject: Reply to: adding 3rd record in VSAM using file manager
Reply with quote

it' s going to be a very long week icon_cry.gif
Back to top
View user's profile Send private message
gudguy.deepak

New User


Joined: 29 Sep 2010
Posts: 3
Location: Hyderabad, India

PostPosted: Mon Jun 20, 2011 12:12 pm    Post subject:
Reply with quote

Quote:
. We have a VSAM file A having following layout.

Org 9(3)

Acct X(19)

Name X(30)

Status X

Addr 1 X(30)

Addr 2 X(30)

State X(10)

Pin X(10)

Filler X(26)

Age 9(03)

DOB X(8)



We want to add 2 new fields in the file without changing the length of the file.

Loan Eligibility 9(17) Comp-3

Number of Years 9(02)



Where will you suggest to add these fields? What will be the new layout of the file?
_________________
samar singh


Can anyone suggest a conversion program that will convert the existing file’s record to the new layout permanently, so that the new-layout can be used henceforth.
I have a similar problem of layout change, alongwith some additional functionality needed to be done :
The following consideration to be taken while coding
Age < 18 --> New fields will contain 0
Age >=18 and < 30 --> Loan Eligibility should be 30,000 and Number of Years should be 10
Age >=30 and < 50 --> Loan Eligibility should be 20,000 and Number of Years should be 07
Age >=50 and <= 70 --> Loan Eligibility should be 10,000 and Number of Years should be 03
Age > 70 --> New fields will contain 0
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Mon Jun 20, 2011 12:23 pm    Post subject: Reply to: record layout change
Reply with quote

since you both see to work for the same organization, or taking the same class
why don 't you get together and do some some cooperative thinking instead of waiting to spoonfed on a forum !

also from the question content both of You seem to be better fit for the beginners forum here
http://ibmmainframeforum.com/
Back to top
View user's profile Send private message
Dsingh29

Active User


Joined: 16 Dec 2008
Posts: 132
Location: IBM

PostPosted: Mon Jun 20, 2011 12:26 pm    Post subject:
Reply with quote

deepak, instead of looking for code, you should start working on your code. icon_evil.gif

You didnt cared to answer:
Quote:

Can you please elaborate on the purpose of this VSAM file? Is it being used for reading or for writing in the program.


I think you are stuck with the term "conversion program", what purpose it will solve, I wonder. If you change the layout it will automatically used henceforth.
Back to top
View user's profile Send private message
gudguy.deepak

New User


Joined: 29 Sep 2010
Posts: 3
Location: Hyderabad, India

PostPosted: Mon Jun 20, 2011 12:30 pm    Post subject:
Reply with quote

Thanks Dsingh29 for clarifying on " conversion-program " .
I was really stuck and confused on that part icon_redface.gif
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 -> HomeWorks & Requests All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts sort with previous record anatol DFSORT/ICETOOL 9 Thu Oct 06, 2016 2:36 am
No new posts Get Record count in summary record fo... Atul Banke DFSORT/ICETOOL 21 Fri Sep 23, 2016 4:17 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts Using 'parm' to vary SORTOUT record v... Sysaron DFSORT/ICETOOL 13 Wed Sep 07, 2016 9:24 pm


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