Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL0438N

Posted on 2006-11-01
2
Medium Priority
?
3,325 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 2000 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

722 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