Load Table from a file

Load a file with tab seperated to a table

filename.txt

col1_data1 col2_data1 col3_data1 col4_data1 col5_data1
col1_data2 col2_data2 col3_data2 col4_data2 col5_data2


load Table Table_name (
col1,
col2,
col3,
col4,
col5
)
FROM '/home/sujith/filename.txt'
QUOTES ON
ESCAPES OFF
FORMAT BCP
STRIP OFF


col1 col2 col3 col4 col5
col1_data1 col2_data1 col3_data1 col4_data1 col5_data1
col1_data2 col2_data2 col3_data2 col4_data2 col5_data2