| View previous topic :: View next topic |
| Author |
Message |
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
 Posted: Tue Sep 07, 2010 8:36 am Post subject: converting files with big LRECL |
 |
|
Hi,
Would you please advise me on this.......
Is it useful to convert a PS file with LRECL of 31034 to a VB file? Does it work for a file of big LRECL?
Please help.
Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
 |
Anuj Dhawan
Intermediate
Joined: 19 Jul 2007
Posts: 298
Topics: 7
Location: Mumbai,India
|
| Posted: Tue Sep 07, 2010 9:20 am Post subject: Re: converting files with big LRECL |
|
|
| mf_user wrote: | | Is it useful to convert a PS file with LRECL of 31034 to a VB file? Does it work for a file of big LRECL? |
"Useful" in what manner, do you have something in mind? And, are the records of different length in file? If they are not, what's the use of having RECFM=VB?
_________________
Regards,
Anuj
Last edited by Anuj Dhawan on Wed Sep 08, 2010 4:09 am; edited 1 time in total |
|
| Back to top |
|
|
papadi
Supermod
Joined: 20 Oct 2009
Posts: 594
Topics: 1
|
| Posted: Tue Sep 07, 2010 1:50 pm Post subject: |
|
|
| Quote: | | Would you please advise me on this....... |
Possibly, if you explain what you are trying to accomplish. . .
"Big" doesn't relate to "variable", unless (as Anuj suggests) the record length varies. If these records are all the same length, using VB will only waste space and require more processing overhead. . .
_________________
All the best,
di |
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Thu Sep 16, 2010 9:28 am Post subject: |
|
|
Hi,
Thanks for the reply. Yes, each record length varies. Does it still hold good to convert a LRECL of 31034 to a VB?
Thanks again.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12370
Topics: 75
Location: San Jose
|
| Posted: Thu Sep 16, 2010 10:29 am Post subject: |
|
|
| mf_user wrote: | Hi,
Thanks for the reply. Yes, each record length varies. Does it still hold good to convert a LRECL of 31034 to a VB?
Thanks again. |
Well that is the basic concept of a VB file.
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Anuj Dhawan
Intermediate
Joined: 19 Jul 2007
Posts: 298
Topics: 7
Location: Mumbai,India
|
| Posted: Fri Sep 17, 2010 5:27 am Post subject: |
|
|
It would be nice if you explain what final goal do you have to achieve. Because, unfortunately your description of what you want is not explnatory enough thus far. This: | Quote: | | Is it useful to convert a PS file with LRECL of 31034 to a VB file? |
kind of question which qualifies only for the answer of type - it depends.
If your application wants it to be VB, okay do that; if not please don't do that. There is no usefulness, I can forsee solely because the file is changed from FB to VB!
_________________
Regards,
Anuj |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12370
Topics: 75
Location: San Jose
|
| Posted: Fri Sep 17, 2010 10:37 am Post subject: |
|
|
| Anuj Dhawan wrote: | | If your application wants it to be VB, okay do that; if not please don't do that. There is no usefulness, I can forsee solely because the file is changed from FB to VB! |
Did you account for space savings for a VB file with variable length versus FB file with an LRECL of 31034?
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
papadi
Supermod
Joined: 20 Oct 2009
Posts: 594
Topics: 1
|
| Posted: Fri Sep 17, 2010 2:55 pm Post subject: |
|
|
| Quote: | Yes, each record length varies.
|
Not in the current file. All of the physical records by definition are the same length.
If the "used data" length varies, then some space might be saved using variable length - but there would need to be a process to know how to write these different length records from the input fixed records.
Also, any process that uses the file later would most likely need to be modified.
_________________
All the best,
di |
|
| Back to top |
|
|
Anuj Dhawan
Intermediate
Joined: 19 Jul 2007
Posts: 298
Topics: 7
Location: Mumbai,India
|
| Posted: Sun Sep 19, 2010 3:55 am Post subject: |
|
|
| kolusu wrote: | | Anuj Dhawan wrote: | | If your application wants it to be VB, okay do that; if not please don't do that. There is no usefulness, I can foresee solely because the file is changed from FB to VB! |
Did you account for space savings for a VB file with variable length versus FB file with an LRECL of 31034? |
The way I look at is - there is some FB file with LRECL=31034 and the question now is to use LRECL=VB. So even when OP says, | Quote: | | each record length varies |
I don't happen to agree on that for the "current file" because all of the physical records by very definition are the same length. So even if VB is used what's the benefit unless the application creating the file itself creates it as VB.
_________________
Regards,
Anuj |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12370
Topics: 75
Location: San Jose
|
| Posted: Sun Sep 19, 2010 11:58 am Post subject: |
|
|
| Anuj Dhawan wrote: | | I don't happen to agree on that for the "current file" because all of the physical records by very definition are the same length. So even if VB is used what's the benefit unless the application creating the file itself creates it as VB. |
Anuj Dhawan,
I think OP has the current file which has occurs clause defined for the max occurrence and some of the records might not have data populated. This would be either spaces or low-values.
ex:
| Code: |
a
aa
aaa
aaaa
aaaaa
aaaaaa
aaaaaaa
aaaaaaaa
aaaaaaaaa
|
You can trim the trailing spaces/low-values using VLTRIM=C' ' and convert it into a VB file. After the trim, the RDW will have the appropriate length of record.
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Anuj Dhawan
Intermediate
Joined: 19 Jul 2007
Posts: 298
Topics: 7
Location: Mumbai,India
|
| Posted: Mon Sep 20, 2010 4:17 am Post subject: |
|
|
That make sense kolusu but why OP is so silent?
_________________
Regards,
Anuj |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
