Author |
Message
|
rkford11 |
Posted: Wed Jun 15, 2005 3:10 pm Post subject: insert error |
|
|
Partisan
Joined: 06 Jun 2004 Posts: 316
|
I am trying to insert a record into database, but it gives me the following error when it comes across ABC column.
( BROKER.default ) Database error: SQL State '42S22'; Native Error Code '-206'; Error Text '[IBM][CLI Driver][DB2/NT] SQL0206N "ABC" is not valid in the context where it is used. SQLSTATE=42703 '.
The error has the following diagnostic information: SQL State '42S22' SQL Native Error Code '-206' SQL Error Text '[IBM][CLI Driver][DB2/NT] SQL0206N "ABC" is not valid in the context where it is used. SQLSTATE=42703 '
Please guide me through this.
Thanks |
|
Back to top |
|
 |
mayur2378 |
Posted: Wed Jun 15, 2005 3:58 pm Post subject: |
|
|
Apprentice
Joined: 26 May 2004 Posts: 47
|
SQLSTATE:-42703 Undefined column name. A column name is not in the referenced tables.
So column name that ur tryin to insert into isnt probably there or there is a syntax error with the name |
|
Back to top |
|
 |
rkford11 |
Posted: Thu Jun 16, 2005 7:01 am Post subject: |
|
|
Partisan
Joined: 06 Jun 2004 Posts: 316
|
mayur2378 wrote: |
SQLSTATE:-42703 Undefined column name. A column name is not in the referenced tables.
So column name that ur tryin to insert into isnt probably there or there is a syntax error with the name |
The name of the column is correct and also the syntax. datatype of the column is an integer(FK)
Thanks |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Jun 16, 2005 7:10 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
Is the case of the column correct?
Is the table/column in the correct schema for the database user in question?
Are there different errors in the database logs?
What do you see if you enable database tracing? _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
mayur2378 |
Posted: Thu Jun 16, 2005 8:01 am Post subject: |
|
|
Apprentice
Joined: 26 May 2004 Posts: 47
|
What environment is ur database on.
As Jeff Mentioned check for the case and the Database Schema |
|
Back to top |
|
 |
|