what is to be in define and set record to fatload from excel

Tools
Enthusiast

what is to be in define and set record to fatload from excel

data in the excel is as below

2 RAMA 20 8000 2011-01-28 11:04:48
7 SUJIT 10 9000 2009-04-01 04:04:07
20 nimbu's 40 23000 2011-09-18 03:04:11
23 a is done 40 21010 2011-04-07 07:04:23

table is in the format
emp(
empno INTEGER,
ename VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
DeptNo INTEGER,
salary INTEGER,
doj DATE FORMAT 'YYYY-MM-DD')
UNIQUE PRIMARY INDEX ( empno );

what will be the define statement and SET RECORD statement to load this?

2 REPLIES
Enthusiast

Re: what is to be in define and set record to fatload from excel

i think changing the data from xls to csv and normal loading will do.

Thanks
Teradata Employee

Re: what is to be in define and set record to fatload from excel

Based on the data I see, you can use SET RECORD VARTEXT, and specify a delimiter of the space character.

Each field definition in the DEFINE statement must be a VARCHAR, so just make sure you have allotted enough space in the column definition to hold the data you need to load.

On input, the DBS will convert the VARCHAR field data to the defined column data types.
-- SteveF