hi
i am loading teradata table using Teradata connector
i am getting following fatel error
table_TGT: [IIS-CONN-TERA-005004] RDBMS code 3810: SP_STAGE:Column/Parameter 'col' does not exist. SQL statement: call (CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 2,640)
can any one help me out
Thanks
Teradata connector error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 14
- Joined: Thu Jun 09, 2011 7:24 pm
- Location: USA
Teradata connector error
Last edited by ramesh9394 on Mon Nov 21, 2011 1:33 pm, edited 1 time in total.
ram
-
- Participant
- Posts: 14
- Joined: Thu Jun 09, 2011 7:24 pm
- Location: USA
Re: Teradata connector error
my job looks like
sequential file---->transformer---->TDconnector
can any one help me out
Thanks
sequential file---->transformer---->TDconnector
can any one help me out
Thanks
ram
-
- Participant
- Posts: 14
- Joined: Thu Jun 09, 2011 7:24 pm
- Location: USA
Thanks for reply pandeesh
i am inerting in bulk mode
this is after sql
thanks
i am inerting in bulk mode
this is after sql
Code: Select all
call #DBNAME#.SP_STAGE
(
'#DBNAME#','#STGTBL#','STARTDATE' , 'STARTUTCDTTM', 'ENDDATE', 'ENDUTCDTTM'
)
Last edited by ramesh9394 on Mon Nov 21, 2011 1:35 pm, edited 1 time in total.
ram
-
- Participant
- Posts: 14
- Joined: Thu Jun 09, 2011 7:24 pm
- Location: USA
-
- Participant
- Posts: 14
- Joined: Thu Jun 09, 2011 7:24 pm
- Location: USA