Examples of FORMAT option output
The tables in this section illustrate the results of using each FORMAT option:
- The Table definition for FORMAT example table lists different data types and sample data.
- The Examples of unloaded data when using the FORMAT option table shows the data that would be unloaded, based on the table definitions in the Table definition for FORMAT example table. The CSV format uses the default TERMINATEDBY and ENCLOSEDBY characters.
The following is the table definition for FORMAT example:
Column name | Column definition |
| Data |
|---|---|---|---|
CHAR_COL | CHAR (10) | NOT NULL WITH DEFAULT | 'CHARACTERS' |
DEC_COL | DECIMAL(7,2) | NOT NULL WITH DEFAULT | 142.23 |
INTEGER_COL | INTEGER | NOT NULL WITH DEFAULT | 12996 |
DATE_COL | DATE | NOT NULL WITH DEFAULT | '08/22/1994' |
TIME_COL | TIME | NOT NULL WITH DEFAULT | '08:41 AM' |
The following table uses the data from the preceding table for the example formats:
FORMAT option | Form | Example of unloaded data |
|---|---|---|
STANDARD | EBCDIC | CHARACTERS D08/22/199408:41 AM |
HEX | CCCDCCECDE0123003CFF6FF6FFFFFF7FF4CD 3819133592042C0024081221199408A41014 | |
EXTERNAL | EBCDIC | CHARACTERS 142.23 1299608/22/199408:41 AM |
HEX | CCCDCCECDE444FFF4FF444444FFFFFFF6FF6FFFFFF7FF4CD 3819133592000142B2300000012996081221199408A41014 | |
INTERNAL | EBCDIC | CHARACTERS D m |
HEX | CCCDCCECDE0123003C1902042 3819133592042C00249482813 | |
BMCLOAD |
| Format is proprietary to BMC Software. |
DSNTIAUL | EBCDIC | CHARACTERS D08/22/199408:41 AM |
HEX | CCCDCCECDE0123003CFF6FF6FFFFFF7FF4CD 3819133592042C0024081221199408A41014 | |
CSV | EBCDIC | 'CHARACTERS',142.23,12996,'08/22/1994','08:41 AM' |
HEX | 7CCCDCCECDE76FFF4FF6FFFFF67FF6FF6FFFF767FF7FF4CD7 F3819133592FB142B23B12996BF0812211994FBF08A41014F | |
XML | EBCDIC | <table_name><char_col>'CHARACTERS'</char_col> <dec_col>142.23</dec_col> <integer_col>12996</integer_col> <date_col>'08/22/1994'</date_col> <time_col>'08:41 AM'</time_col></table_name> |
Related topics
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*