MQSeries.net :: View topic

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » insert error

insert error

« View previous topic :: View next topic »

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

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

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

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.

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

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » insert error

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP