Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3372
  • Last Modified:

SQL0438N

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
LuckyLucks
Asked:
LuckyLucks
1 Solution
 
momi_sabagCommented:
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
 
LuckyLucksAuthor Commented:
ya , thanx
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now