|
View previous topic :: View next topic
|
| Author |
Message |
gylbharat
Active Member
.jpg)
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
Hi,
I tried running a unload today to unload 2 columns of a table using DB2 unload utility.
The output file was getting created as VB.
Is there some option where I can create the file as FB? |
|
| Back to top |
|
 |
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| What unload utility are you using? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| may as well as tell us the datatype of the columns being unloaded. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| If everything else is fine then with the information in hand, suggest you write another SORT step, in your Job, to have VB to FB conversion. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
as usual, no response from TS.
problem with changing an unload, after the fact from vb to fb,
the SYSPUNCH will not be insync.
it is better to use sql in the unload - with the PARMS(SQL) parm
and cast columns to fixed length to force a fixed length unload file
and the mask will match incase a LOAD is later required.
running a second step to convert the file
is the way someone who is not proficient with the db2 utilities handles the problem. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| dbzTHEdinosauer wrote: |
it is better to use sql in the unload - with the PARMS(SQL) parm and cast columns to fixed length to force a fixed length unload file and the mask will match incase a LOAD is later required.
running a second step to convert the file is the way someone who is not proficient with the db2 utilities handles the problem. |
That's why I played safe and said:
| Quote: |
| If everything else is fine... |
 . |
|
| Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
Hi All,
Sorry for the late response... There are two columns in the table. Both are char(10).
Yes, I can write a sort to convert VB to FB. But my question here was if there is some parameter which can be used in the Unload control card to create a FB file. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| gylbharat wrote: |
| Yes, I can write a sort to convert VB to FB. But my question here was if there is some parameter which can be used in the Unload control card to create a FB file. |
| dbzTHEdinosauer wrote: |
use sql in the unload - with the PARMS(SQL) parm
and cast columns to fixed length to force a fixed length unload file
and the mask will match incase a LOAD is later required. |
|
|
| Back to top |
|
|
jerryte
Active User
Joined: 29 Oct 2010
Posts: 202
Location: Toronto, ON, Canada
|
|
|
|
Are you using the DSNTIUAL unload utility? Do you select the column as is (no functions)? If so then it should create a FB dataset.
Read the manual "DB2 Utilities Guide and Reference" appendix D for the productivity aid sample programs. |
|
| Back to top |
|
|
|
|
