At 02:08 PM 6/28/2005, Gary Wendike wrote:
I have a text file that I am trying to load, however the delimiter is
"tab" and the "coma".
How do I reset the delimiter to tab in a command file.
Gary,
To load the ASCII Tab Delimited file, use the command line
GATEWAY IMPORT option.
Assuming that you have the target table to match with the
ASCII Delimited file.
Examples:
-- To import data as new table
GATEWAY IMPORT TAB filename.TAB CREATE newtablename
-- To append imported data in existing table
GATEWAY IMPORT TAB filename.TAB APPEND existingtablename
-- To replace existing table data
GATEWAY IMPORT TAB filename.TAB REPLACE existingtablename
Hope that helps!
Razzak.
