Text file data types
Table 7‑1 lists and provides information about the abbreviations you use for the data types.
Table 7‑1 Supported data types in flat files 
Abbreviation
Data type
Examples
BIGDECIMAL
java.sql.Types.NUMERIC
 
DATE
java.sql.Types.DATE
YYYY-MM-DD or
MM/DD/YYYY
Examples:
2003-01-31
01/31/2003
DOUBLE
java.sql.Types.DOUBLE
 
INT
java.sql.Types.INTEGER
 
STRING
java.sql.Types.VARCHAR
 
TIME
java.sql.Types.TIME
hh:mm:ss
Examples:
12:59:59 AM
12:59:59 pm
TIMESTAMP
java.sql.Types.TIMESTAMP
YYYY-MM-DD hh:mm:ss.nnnnnn