Re: SQL2JXL gets SQL0204 on one machine, works on another

Hi Chuck,

Just for the record, here's the joblog:

SQL0204 Diagnostic 30 08/21/07 22:20:56.642488 QSQRUN1 QSYS *STMT QSQRUN1 QSYS *STMT
From user . . . . . . . . . : CC_PGMPCD From module . . . . . . . . : QSQPREP From procedure . . . . . . : CLEANUP Statement . . . . . . . . . : 10766 To module . . . . . . . . . : QSQPREP To procedure . . . . . . . : CLEANUP Statement . . . . . . . . . : 10766 Message . . . . : PHPLOCN in *LIBL type *FILE not found. Cause . . . . . : PHPLOCN in *LIBL type *FILE 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, PHPLOCN 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 external function was not found, be sure that the case of the EXTERNAL NAME
on the CREATE FUNCTION statement exactly matches the case of the name exported by the service program.

Please, tell me I'm missing something obvious!!

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

CRPence wrote:

The message SQL0204 [in the joblog] should say what is missing. Sure, then the guesses will stop, but reading those was not so much fun anyhow :-)

Regards, Chuck