SQL CODE -438



IBM's flagship relational database management system

SQL CODE -438

Postby p19689 » Wed Jan 18, 2012 4:05 pm

Hi , When I try to insert a record (via SPUFI in DB2 V9) into a table with no RI defined but just 2 Check constraints defined get the follwoing error. The error does not relate to the Check constrains. Table does not have any triggers, functions or stored procedures defined. Can someone tell how DB2 generate this error ? Any further reading material etc. please. Thanks in advance.

DSNT408I SQLCODE =,-438,,ERROR: APPLICATION RAISED ERROR WITH DIAGNOSTIC
TEXT: ' area code does not exist in AREA'
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQL CODE -438

Postby p19689 » Wed Jan 18, 2012 5:44 pm

Thanks everyone, I have managed to locate the error and it's raised by a trigger via SIGNAL statement.
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post