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
 

 

Unload - Format External

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

New User


Joined: 02 Jun 2005
Posts: 16

PostPosted: Fri Dec 22, 2006 5:33 pm    Post subject: Unload - Format External
Reply with quote

Hi all
I am using Unload utility with the option "Format External"
Now we are porting all these unloading to the oracle.
I want to know that how does format external stores the data into the file.
does any one have any document which can explain that when format= external is specified how it stores the data into the files.

help appreciated
Thanks
Saurabh
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri Dec 22, 2006 8:00 pm    Post subject:
Reply with quote

Just looking at the DB2 Universal Database for OS/390 and z/OS Utility Guide and Reference Version 7 Publication No. SC26-9945-07, I can imagine that the external refers to the fack that the data will be extracted in human readable form.
Quote:
INTEGER
Specifies that the output field is a four byte binary integer (a negative number is in two?s complement notation).
If the original data type is DECIMAL, or FLOAT (either four byte or eight byte format), an error will occur when the original data is greater than 2 147 483 647 or less than -2 147 483 648.
An INTEGER output field requires four bytes and the length option is not available.
INTEGER EXTERNAL
Specifies that the output field contains a character string representing an integer number.
(length)
The optional length parameter indicates the size of the output data in bytes, including a space for the sign character. When the length is given and the character notation does not fit in the space, an error will occur. If the output field size is not specified, the default is 11 characters (including a space for the sign).
If the value is negative, a minus sign precedes the numeric digits. If the output field size is larger than the length of the data, the output data is left justified and blanks will be padded on the right.
If the source data type is DECIMAL, or FLOAT (either four byte or eight byte format), an error will occur when the original data is greater than 2 147 483 647 or less than -2 147 483 648.
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 unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am
No new posts Format record to remove Leading zeroes Learncoholic DFSORT/ICETOOL 14 Wed Apr 05, 2017 2:43 pm
No new posts How to pick only YYMMDD from DATE1P (... atulbaviskar SYNCSORT 7 Wed Mar 22, 2017 11:39 am
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm


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