Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Attempting to run an update in SPUFI sqlcode -438

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ScottUrban

New User


Joined: 23 Apr 2007
Posts: 50
Location: Jefferson City, Mo

PostPosted: Mon Sep 14, 2009 7:52 pm    Post subject: Attempting to run an update in SPUFI sqlcode -438
Reply with quote

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
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10276
Location: italy

PostPosted: Mon Sep 14, 2009 7:57 pm    Post subject: Reply to: Attempting to run an update in SPUFI sqlcode -438
Reply with quote

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnc1k15/3.2.186?ACTION=MATCHES&REQUEST=-438&TYPE=FUZZY&SHELF=DSNSHKA3.bks&DT=20090622165757&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

the info You posted is not enough to help You
Back to top
View user's profile Send private message
ScottUrban

New User


Joined: 23 Apr 2007
Posts: 50
Location: Jefferson City, Mo

PostPosted: Mon Sep 14, 2009 8:28 pm    Post subject:
Reply with quote

What other info do you need?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 14, 2009 8:52 pm    Post subject:
Reply with quote

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
View user's profile Send private message
ScottUrban

New User


Joined: 23 Apr 2007
Posts: 50
Location: Jefferson City, Mo

PostPosted: Mon Sep 14, 2009 9:01 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10276
Location: italy

PostPosted: Mon Sep 14, 2009 9:03 pm    Post subject: Reply to: Attempting to run an update in SPUFI sqlcode -438
Reply with quote

and when You look at the 04e abend what does it tell You ?
Back to top
View user's profile Send private message
ScottUrban

New User


Joined: 23 Apr 2007
Posts: 50
Location: Jefferson City, Mo

PostPosted: Mon Sep 14, 2009 9:07 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10276
Location: italy

PostPosted: Mon Sep 14, 2009 9:11 pm    Post subject: Reply to: Attempting to run an update in SPUFI sqlcode -438
Reply with quote

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
View user's profile Send private message
ScottUrban

New User


Joined: 23 Apr 2007
Posts: 50
Location: Jefferson City, Mo

PostPosted: Mon Sep 14, 2009 9:11 pm    Post subject:
Reply with quote

ok thx....
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 14, 2009 9:20 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Sep 15, 2009 1:30 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us