Advertisement

01.31.2007 at 09:00AM PST, ID: 22143917
[x]
Attachment Details

SQLCODE: -107, SQLSTATE: 42622

Asked by ane4ka in DB2 Database

Tags: 42622, db2, sqlstate

I am executing the following query in UDB database through java application:


UPDATE loaniq.DISTRESS_SOURCE_TARGET_MAP
SET TARGET_ID = '004'
WHERE SOURCE_ID = 'admin'
AND MAP_NM = 'TRADEID GENERATOR'

I get the following error back:

DB2 SQL error: SQLCODE: -107, SQLSTATE: 42622, SQLERRMC: DISTRESS_SOURCE_TARGET_MAP;


Can you please explain what this error means and how can I fix it.

Thanks!Start Free Trial
[+][-]01.31.2007 at 09:05AM PST, ID: 18437427

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.31.2007 at 09:07AM PST, ID: 18437433

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.31.2007 at 09:12AM PST, ID: 18437477

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.31.2007 at 10:41AM PST, ID: 18438301

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: DB2 Database
Tags: 42622, db2, sqlstate
Sign Up Now!
Solution Provided By: Kdo
Participating Experts: 4
Solution Grade: B
 
 
[+][-]01.31.2007 at 10:55AM PST, ID: 18438410

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]01.31.2007 at 02:24PM PST, ID: 18440295

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32