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 Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am
No new posts output data in CSV Format janmejay COBOL Programming 8 Sat Oct 15, 2016 2:20 pm
This topic is locked: you cannot edit posts or make replies. output data in CSV Format janmejay DFSORT/ICETOOL 3 Sat Oct 15, 2016 2:16 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm


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