I am trying to compile a store procedure in DB2 V8, Fixpak 5, on AIX 5.2. Any ideals would be appreciated. I can compile other C programs with no problem, just not a stored procedured. I have added the I am getting the following:
I added the following to my profile
DB2_SQLROUTINE_COMPILE_COMMAND=xlc -I$HOME/sqllib/include SQLROUTINE_FILENAME.c -bEQLROUTINE_FILENAME.exp -e pgsjmp -o SQLROUTINE_FILENAME -L$HOME/sqllib/lib -ldb2
-- COMPILATION MESSAGES FOR /db2/EOP/sqllib/function/routine/sqlproc/PEDWETL/ETL/tmp/P3450980.c
sh: xlC_r: not found.
-- END OF LOG FILE (SQLCODE: -7032)
ETL.SP_GET_THRESH - Build failed.
ETL.SP_GET_THRESH - Roll back completed successfully.
The body of the stored proc is as follows:
CREATE PROCEDURE INFORMAT.SP_GET_THRESH(OUT CNT1 INTEGER)
MODIFIES SQL DATA
select count(*) into CNT1 from etl_process_control where WF_STAT='R';