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

["Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>]

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
>