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.
midrange.com
