Create Procedure wrong when SQL7032N Create the following error occurred Procedure SQL7032N SQL procedure "CHECK" not created. Diagnostic file is "P5523908.log." SQLSTATE=42904 -- PROCEDURE FOR LOG FILE P5523908.log USERA. CHECK -- DB2_SQLROUTINE_PREPOPTS= -- PREP/BIND MESSAGES FOR /export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/USERA/tmp/P5523908.sqc LINE MESSAGES FOR P5523908.sqc ------  -------------------------------------------------------------------- SQL0060W The "C" precompiler is in progress. SQL0091W Precompilation or binding was ended with "0" Errors and "0" warnings. -- CONTENTS OF /export/home/db2inst1/sqllib/function/routine/sr_cpath #!/bin/sh PATH=$PATH:/opt/SUNWspro/bin Export PATH -- CONTENTS OF /export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/USERA/tmp/P5523908.sh SQLROUTINE_FILENAME=P5523908 Export SQLROUTINE_FILENAME -- COMPILATION COMMAND : CC -xarch=v8plusa -mt -KPIC -I/export/home/db2inst1/sqllib/include P5523908.c G -o P5523908 -L/export/home/db2inst1/sqllib/lib -R/export/home/db2inst1/sqllib/lib -ldb2 -- CONTENTS OF /export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/USERA/tmp/P5523908.exp Pgsjmp -- COMPILATION MESSAGES FOR /export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/USERA/tmp/P5523908.c CC : unrecognized option `-KPIC ' CC : arch=v8plusa not recognized language Ld : fatal : file : unknown file type P5523908.c Ld : fatal : File processing errors. No output written to P5523908 Collect2 : ld returned 1 exit status FILE -- ones OF LOG (SQLCODE : -7032) C compiler have? CC : unrecognized option `-KPIC ' CC : arch=v8plusa not recognized language Cc look at the choices Not on the installation and configuration of SQL Server stored procedure support. On the server installation "DB2 Application Development Client", and C Compiler can create SQL process. In your platform, may need to install DB2 Register at the variables can include C DB2_SQLROUTINE_COMPILER_PATH Set up the script or batch environment compiler paper. DB2 SQL stored procedure failed pre-compiler, or editing. DB2 includes embedded SQL as a building C-SQL procedures process. In pre-compiler can be found in the initial stages of editing or analysis CREATE PROCEDURE expression was not detected in error. [ Closed window ]