|
View previous topic :: View next topic
|
| Author |
Message |
Ramsee
New User
.jpg)
Joined: 06 Jan 2011
Posts: 53
Location: Chennai
|
|
|
|
Hi,
Please guide me how to add spaces at the end of the file using SORT OUTREC.
Regards,
Ramsee |
|
| Back to top |
|
 |
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Ramsee wrote: |
Hi,
Please guide me how to add spaces at the end of the file using SORT OUTREC.
Regards,
Ramsee |
What do you mean add space at end of file?
What is the file format? record length? show sample example... |
|
| Back to top |
|
|
gylbharat
Active Member
.jpg)
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
| Do you want to add a blank line at the end? |
|
| Back to top |
|
|
Ramsee
New User
Joined: 06 Jan 2011
Posts: 53
Location: Chennai
|
|
|
|
| Code: |
JOINKEYS FILE=F1,FIELDS=(42,10,A)
JOINKEYS FILE=F2,FIELDS=(1,10,A)
JOIN UNPAIRED,F1,ONLY
REFORMAT FIELDS=(F1:5,4096)
SORT FIELDS=(5,3,CH,A,10,5,CH,A)
OUTFIL FILES=1,OUTREC=(1,4096)
OUTFIL FILES=2,OUTREC=(1:5,4092,4093:4X)
|
This is the sort cards i am using the VB Record layout,
i want to add Blank space at the end of the file. |
|
| Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010
Posts: 577
Location: USA
|
|
|
|
Ramsee,
While you certainly can do that but I don't see a reason for it. Did you mean to add 4 spaces starting at 4093 through 4096 positions? Why would do that with VB file?
Are you trying to convert VB file to FB? If that is the case, use CONVERT
Thanks, |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Ramsee,
It's really not clear what you're trying to do or why.
You need to show an example of your input records and what exactly you expect for the output records. Give the RECFM and LRECL of the input and output files as well, and the starting position, length and format of all relevant fields. |
|
| Back to top |
|
|
|
|
