Interesting error message at V5R3

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

Thought you folks might enjoy the following:

 

                         Additional Message Information


 


 Message ID . . . . . . :   SQL0204       Severity . . . . . . . :   30


 Message type . . . . . :   Diagnostic


 


 Message . . . . :   GPGRNDTEXT in DENNIS type *SRVPGM not found.           

 Cause . . . . . :   GPGRNDTEXT in DENNIS type *SRVPGM was not found. If    

   this is an ALTER TABLE statement and the type is *N, a constraint or


   partition was not found. If this is not an ALTER TABLE statement and the


   type is *N, a function, procedure, or trigger was not found.


     If a function was not found, GPGRNDTEXT is the service program that


   contains the function.  The function will not be found unless the
external   

   name and usage name do not match exactly.  Examine the job log for a
message 

   that gives more details on which function name is being searched for and
the 

   name that did not match.


 Recovery  . . . :   Change the name and try the request again.  If the
object  

   is a node group, ensure that the DB2 Multisystem product is installed on


   your system and create a nodegroup with the CRTNODGRP CL command. If an


 

Pay particular attention to paragraph 2, sentence 2: "The function name will
not be found unless the external name and usage name do not match exactly."
Umm.. so all I have to do to get it to work, is to mis-key something?  And
if I make no mistakes, then it won't work?

 

Maybe it's just because I'm getting punchy, but I thought it was funny.

 

Dennis E. Lovelady
AIM/Skype: delovelady      MSN: fastcounter@xxxxxxxxxxxx
 <http://www.linkedin.com/in/dennislovelady>
www.linkedin.com/in/dennislovelady --
Give a man a fish and he will eat for a day. Teach a man to fish and he will
sit in a boat all day drinking beer.