All Forums Database
KVB 124 posts Joined 09/12
02 Apr 2014
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?
 
 
 

Qaisar Kiani 337 posts Joined 11/05
02 Apr 2014

Can you share your fastload script?

Adharssh 36 posts Joined 08/13
02 Apr 2014

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.

Share the Knowledge. Feel the Happiness, When you share/Teach it.

krishaneesh 140 posts Joined 04/13
07 Apr 2014

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 124 posts Joined 09/12
08 Apr 2014

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

You must sign in to leave a comment.