Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Unload

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Oct 17, 2011 1:11 pm    Post subject: DB2 Unload
Reply with quote

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
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Mon Oct 17, 2011 5:42 pm    Post subject:
Reply with quote

What unload utility are you using?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Oct 17, 2011 5:50 pm    Post subject:
Reply with quote

may as well as tell us the datatype of the columns being unloaded.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Oct 18, 2011 3:33 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Oct 18, 2011 4:35 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Oct 18, 2011 4:44 pm    Post subject:
Reply with quote

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...
icon_smile.gif.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Tue Oct 18, 2011 5:05 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Oct 18, 2011 6:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
jerryte

Active User


Joined: 29 Oct 2010
Posts: 183
Location: Toronto, ON, Canada

PostPosted: Fri Oct 21, 2011 9:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts DB2 Unload format options Susanta DB2 2 Fri Aug 12, 2016 5:42 pm
No new posts DXT unload utility - DVRE0000 mistah kurtz DB2 1 Thu Jul 07, 2016 4:56 pm
No new posts How to suppress retun code of partil ... mkk157 DB2 9 Fri May 27, 2016 6:59 am
No new posts FAST UNLOAD and LOAD issue GaganGarg DB2 1 Mon Feb 15, 2016 2:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us