Solved

SQL0438N

Posted on 2006-11-01
2
3,132 Views
Last Modified: 2007-12-19
hi ee

  what does this error stand for. I couldnt find it on any reference clearly explained. In my scenario, I have a insert taking place for a field that doesnt allow nulls and the value I am inserting is a null. But for inserting a null in a nonnullable field there is another SQLcode thats raised as far as i know. Please educate

thx
0
Comment
Question by:LuckyLucks
2 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 500 total points
ID: 17849721
hi

here is the explanation for this code


SQL0438N Application raised error with diagnostic text:
          "<text>".

Explanation:

This error or warning occurred as a result of execution of the
RAISE_ERROR function or the SIGNAL SQLSTATE statement in a
trigger.  An SQLSTATE value that starts with '01' or '02'
indicates a warning.

User Response:

See application documentation.

 sqlcode :  -438, +438

 sqlstate :  application-defined


i guess that you are using a trigger to perform your insert, and in the trigger you catch the exception and use a sql SIGNAL command in order to raise an error
is that true ?
0
 

Author Comment

by:LuckyLucks
ID: 17851860
ya , thanx
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql duplicate rows from concatenated columns 9 315
Check file/object size on AS400 3 178
Catalog Index 9 123
RPG Free Prototypes using  *LDA data 5 208
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question