Examples of FORMAT option output
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 | The format is proprietary to BMC. | |
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> |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*