View previous topic :: View next topic
|
Author |
Message |
murugan_mf
Active User
Joined: 31 Jan 2008 Posts: 148 Location: Chennai, India
|
|
|
|
Hi,
I am using DSNUTILB utility to unload data from a table.The output file is of variable length ,normally VB file has only 4 bytes its of information but
this unloaded file has extra 6 bytes.Can someone explain about this extra 6 bytes and this extra 6 bytes position in the output record?How to convert this VB size file to FB size file?
Thanks!
Murugan.l |
|
Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
I don't believe you can force to a FB file.
The extra bytes may be written for each field of you table having NULL attribute. |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Hi,
What does last two bytes of six bytes say?
Quote: |
How to convert this VB size file to FB size file? |
Please use SORT product what you have at your shop, possibly DFSORT, SYNCSORT, CA-SORT, etc.
I'd use this snippet for converting VB dataset with 425 to FB dataset with 421 since I've SYNCSORT installed in.
Code: |
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(5,421),CONVERT |
|
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
Back to top |
|
|
murugan_mf
Active User
Joined: 31 Jan 2008 Posts: 148 Location: Chennai, India
|
|
|
|
Hi,
Quote: |
What does last two bytes of six bytes say? |
Two of these six bytes contains the OBID.I want to know the position of these six bytes in the output record.
Thanks!
Murugan.l[/quote] |
|
Back to top |
|
|
|