|
View previous topic :: View next topic
|
| Author |
Message |
ScottUrban
New User
Joined: 23 Apr 2007
Posts: 50
Location: Jefferson City, Mo
|
|
|
|
I am running the following in SPUFI;
| Code: |
UPDATE MMITCGTG.MMIT_PROCEDURE_MODIFIER_CODE
SET MODIFIER_DS = 'ANESTHESIA BY SURGEON'
WHERE MODIFIER_CD = '47'
; |
Then I receive a -438. Any help would be much appreciated. |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
| Back to top |
|
|
ScottUrban
New User
Joined: 23 Apr 2007
Posts: 50
Location: Jefferson City, Mo
|
|
|
|
| What other info do you need? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Did you read the info at the link Enrico provided?
You need to provide the error text as well as clarify this:
| Quote: |
| This error occurred as a result of the RAISE_ERROR function, a RESIGNAL
| statement, a SIGNAL SQLSTATE statement, or it was an unhandled condition
| when processing of the trigger or routine completed. |
|
|
| Back to top |
|
|
ScottUrban
New User
Joined: 23 Apr 2007
Posts: 50
Location: Jefferson City, Mo
|
|
|
|
yes I read about the -438 before I came in the forum to begin with. I am not sure I understand how to find or retrieve this error text. When I run in Spufi this is all I get...
| Code: |
Abend 04E000 hex occurred processing command 'DSN '.
*** |
|
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| and when You look at the 04e abend what does it tell You ? |
|
| Back to top |
|
|
ScottUrban
New User
Joined: 23 Apr 2007
Posts: 50
Location: Jefferson City, Mo
|
|
|
|
| pretty much the same thing as the -438 examine the diagnostic material generated by the 04e. but spufi doesn't generate anything but the last msg I posted... |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
nothing we can do from a forum... speak to Your db2 support...
the -438 IIRC is just a consequence of the s04e |
|
| Back to top |
|
|
ScottUrban
New User
Joined: 23 Apr 2007
Posts: 50
Location: Jefferson City, Mo
|
|
|
|
| ok thx.... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Has this query worked previously?
Is the problem execution from a terminal or in batch?
Is there any any chance something needed by this query has been migrated? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
ScottUrban,
-438 is generated by a raise signal in a Stored Proc or Trigger.
I imagine that your insert is violating a Trigger.
check an insure that there are no Triggers associated with the table. |
|
| Back to top |
|
|
|
|
