Hi All,

System Info:
OS: AIX 5.0
DB: DB2 UDB 7.2

I am trying to compile the SP, but getting following errro into log file.

=========
*** BIND /home/dbadminp/sqllib/function/routine/sqlproc/DWP/BATCHMGR/tmp/P5707080.sqc ***

LINE MESSAGES FOR P5707080.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.

*** COMPILE /home/dbadminp/sqllib/function/routine/sqlproc/DWP/BATCHMGR/tmp/P5707080.c ***

#!/bin/sh
PATH=$PATH:/usr/vacpp/bin
PATH=$PATH:/usr/ibmcxx/bin
PATH=$PATH:/usr/lpp/xlC/bin
export PATH

SQLROUTINE_FILENAME=P5707080
export SQLROUTINE_FILENAME
export SQLROUTINE_ENTRY=pgsjmp

xlC -I/home/dbadminp/sqllib/include P5707080.c -bE:P5707080.exp -e pgsjmp -o P5707080 -L/home/dbadminp/sqllib/lib -lc -ldb2

*** /home/dbadminp/sqllib/function/routine/sqlproc/DWP/BATCHMGR/tmp/P5707080.exp ***
pgsjmp

sh: xlC: not found.

----------------------------------------------------------------------------

SQL7032N SQL procedure "" not created. Diagnostic file is "". SQLSTATE=00000

========

Can you please guide me where is the problem and what needs to be done? I am very new to AIX.

Thanks in advance,
Jai

It looks like the compiler you're trying to use, "xlC" is not installed or not in the path.