Row logging into ET table

Database
KVB
N/A

Row logging into ET table

Hi

I have a table with 3 columns which loads thru FLOAD script

CT DEMO(

DT VARCHAR(10),

CODE CHAR(2)

DESC VARCHAR(255)

)

My file is

2014-04-02|13|demo

This is being logged in ET table and it is hsowing the error field name as DESC column.

Any clue on this?

4 REPLIES

Re: Row logging into ET table

Can you share your fastload script?

Re: Row logging into ET table

Hi ,

Are you sure that this was the Table structure that you gave, there was a missing Column between CODE & DESC columns.

Thanks & Regards,

Adharssh.

Re: Row logging into ET table

Did the create happen with the same script. it should show a syntax error for a missing comma between code column and Desc column. As Qaisar mentioned please share the FLOAD script.

KVB
N/A

Re: Row logging into ET table

Problem got resolved.I have changed the CHAR(2) field to VARCHAR(2).