Solved

SQL0438N

Posted on 2006-11-01
2
3,184 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

734 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