Hi,
We have issue with ODBC Connector stage. Trying to insert data into table in sybase IQ 15.4 using native driver 'Sybase IQ Wire Protocol Driver'. Error message is as below
Peek_5,0: DTKP_ID:5 RejectERRORCODE:207 RejectERRORTEXT:[IBM(DataDirect OEM)][ODBC Sybase IQ Wire Protocol driver][Sybase IQ]SQL Anywhere Error -143: Column '@0001' not found
Reject is for every record , and it is most simple insert with test data:
INSERT INTO S0065.test(DTKP_ID) VALUES(ORCHESTRATE.DTKP_ID)
Any ideas what is the matter of the problem?
Sybase IQ Wire Protocol Driver - problem with inserting data
Moderators: chulett, rschirm, roy
Does this happen only for this table or for all tables?
What happens if you let DataStage create the insert statement, i.e. just pass the one column, DTKP_ID, to the insert statement.
What happens if you let DataStage create the insert statement, i.e. just pass the one column, DTKP_ID, to the insert statement.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Then why does the error message complain of a column called "@0001"? Maybe your design metadata has "@" in column names - if so how did it get there?ascen wrote:Column names does not contains special characters. We will report issue to support
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
That should be an internal placeholder when constructing a query explicitly using the ORCHESTRATE.nnnn names; but shouldn't be in use when doing a plain-vanilla insert with just the one column.
Hmmm.. Are you using RCP in this job and are there perhaps more than the 1 column in the data stream going to the stage?
Hmmm.. Are you using RCP in this job and are there perhaps more than the 1 column in the data stream going to the stage?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>