Hi all

I am new to db2, recently I installed AIX C compiler(5) for AIX5 to use for db2 sql store procedure. The installation when smoothly and to confirm it, i wrote a small "hello world " program to test it. I am currently using DB2 version 7.2 workgroup with fix pack9. But when I try to compile a store procedure it refuces to create a procedure. I have set the Path of the compiler , compile command and even try using a different shell to no result. Even try using " ". No matter what i do the same error occur. I have run out of ideas. The following is a log file, hope some one can help me.



*** BIND /home/db2inst1/sqllib/function/routine/sqlproc/CREAM/DB2INST1/tmp/P0647870.sqc ***

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

*** COMPILE /home/db2inst1/sqllib/function/routine/sqlproc/CREAM/DB2INST1/tmp/P0647870.c ***

DB2_SQLROUTINE_COMPILER_PATH=/usr/vac/bin

DB2_SQLROUTINE_COMPILE_COMMAND=

-. ).. Fxlc_r Fxlc Gcleanpdf Hresetpdf Ishowpdf JCreateExportLiKreplaceCSET LrestoreCSET Fxlc_r4 Fxlc_r7 Fxlc128 Fcc Fcc_r Fcc_r4 Fcc_r7 Fcc128 Fc89 vcore
SQLROUTINE_FILENAME=P0647870
export SQLROUTINE_FILENAME
export SQLROUTINE_ENTRY=pgsjmp

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

*** /home/db2inst1/sqllib/function/routine/sqlproc/CREAM/DB2INST1/tmp/P0647870.exp ***
pgsjmp


sh: 0403-057 Syntax error at line 1 : `)' is not expected.

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

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