Joined: 21 Jun 2006 Posts: 9 Topics: 4 Location: Bangalore
Posted: Thu Oct 19, 2006 3:07 pm Post subject: FB to VB coversion using DFSORT
Hi All,
My requirement is to convert a FB file of 562 to VB file.
I know that the option FTOV is avialable which can be used. But the catch here is that when i convert its retaining the spaces after the actual record even in VB format. I used VLTRIM to remove the spaces. But now what happened is it trimmed all the spaces. I want to retain a single space at the end of the record. Can anybody help me on this?
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Thu Oct 19, 2006 7:30 pm Post subject:
Deepa,
What do your input records look like? In particular, do they have leading blanks of different lengths, e.g. (b for blank):
Code:
bbbdata...
data...
bdata...
bbbbbbbbdata...
or no leading blanks, e.g.
Code:
data...
data...
or leading blanks of the same length, e.g.
Code:
bbbdata
bbbdata
bbbdata
I have a DFSORT solution that doesn't require an exit, but it won't work if the input records have leading blanks of different lengths. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum