Let me start off by saying that I am new to DB2/AIX.
We are in the process of Migrating from DB2/Windows to DB2/AIX.

Set up of DB2 and databases has all gone great.

However, I am now trying to recreate the stored procedure through the Development Center but am getting compiling errors.

Here is the error message that I get:

DB2INST1.Test - Build started.
Create stored procedure returns -7032.

-- LOG FILE P8155200.log FOR PROCEDURE DB2INST1.TEST

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR /home/db2inst1/sqllib/function/routine/sqlproc/ULLICO/DB2INST1/tmp/P8155200.sqc

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

-- CONTENTS OF /home/db2inst1/sqllib/function/routine/sr_cpath

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

-- CONTENTS OF /home/db2inst1/sqllib/function/routine/sqlproc/ULLICO/DB2INST1/tmp/P8155200.sh

SQLROUTINE_FILENAME=P8155200
export SQLROUTINE_FILENAME
export SQLROUTINE_ENTRY=pgsjmp

-- COMPILATION COMMAND:

xlC_r -I/home/db2inst1/sqllib/include P8155200.c -bE:P8155200.exp -e pgsjmp -o P8155200 -L/home/db2inst1/sqllib/lib -ldb2


-- CONTENTS OF /home/db2inst1/sqllib/function/routine/sqlproc/ULLICO/DB2INST1/tmp/P8155200.exp

pgsjmp


-- COMPILATION MESSAGES FOR /home/db2inst1/sqllib/function/routine/sqlproc/ULLICO/DB2INST1/tmp/P8155200.c
"P8155200.c", line 14.10: 1506-296 (S) #include file "sqladef.h" not found.
"P8155200.c", line 16.15: 1506-007 (S) "struct sqla_runtime_info" is undefined.
"P8155200.c", line 17.43: 1506-045 (S) Undeclared identifier wchar_t.
"/usr/include/stdlib.h", line 75.25: 1506-865 (E) The typedef definition of wchar_t is incompatible with the option wchar_t_size
"/usr/include/stdlib.h", line 181.42: 1506-275 (S) Unexpected text '*' encountered.
"/usr/include/stdlib.h", line 181.58: 1506-276 (S) Syntax error: possible missing identifier?
"/usr/include/stdlib.h", line 181.25: 1506-282 (S) The type of the parameters must be specified in a prototype.
"/usr/include/stdlib.h", line 182.48: 1506-275 (S) Unexpected text '*' encountered.
"/usr/include/stdlib.h", line 182.64: 1506-276 (S) Syntax error: possible missing identifier?
"/usr/include/stdlib.h", line 182.33: 1506-282 (S) The type of the parameters must be specified in a prototype.
"/usr/include/stdlib.h", line 183.69: 1506-275 (S) Unexpected text '*' encountered.
"/usr/include/sys/inttypes.h", line 101.41: 1506-275 (S) Unexpected text '*' encountered.
"/usr/include/sys/inttypes.h", line 101.57: 1506-046 (S) Syntax error.
"/usr/include/sys/inttypes.h", line 102.42: 1506-275 (S) Unexpected text '*' encountered.
"/usr/include/sys/inttypes.h", line 102.58: 1506-046 (S) Syntax error.
"/usr/include/sys/localedef31.h", line 60.9: 1506-046 (S) Syntax error.
"/usr/include/sys/localedef31.h", line 79.9: 1506-046 (S) Syntax error.
"/usr/include/sys/localedef.h", line 357.5: 1506-046 (S) Syntax error.
"/usr/include/sys/localedef.h", line 427.3: 1506-046 (S) Syntax error.
"/usr/include/stdlib.h", line 602.62: 1506-275 (S) Unexpected text '*' encountered.
"/usr/include/stdlib.h", line 602.65: 1506-046 (S) Syntax error.
"/usr/include/stdlib.h", line 602.75: 1506-046 (S) Syntax error.
"/usr/include/stdlib.h", line 603.62: 1506-275 (S) Unexpected text '*' encountered.
"/usr/include/stdlib.h", line 603.65: 1506-046 (S) Syntax error.
"/usr/include/stdlib.h", line 604.63: 1506-275 (S) Unexpected text '*' encountered.
"/usr/include/stdlib.h", line 604.66: 1506-046 (S) Syntax error.
"/usr/include/string.h", line 237.16: 1506-166 (S) Definition of function wchar_t requires parentheses.
"P8155200.sqc", line 10.10: 1506-296 (S) #include file <sqlenv.h> not found.
"P8155200.sqc", line 11.10: 1506-296 (S) #include file <sql.h> not found.
"P8155200.sqc", line 12.10: 1506-296 (S) #include file <sqlda.h> not found.
"P8155200.sqc", line 13.10: 1506-296 (S) #include file <db2psmd.h> not found.
"/usr/include/string.h", line 237.33: 1506-276 (S) Syntax error: possible missing '{'?

-- END OF LOG FILE (SQLCODE: -7032)
DB2INST1.Test - Build failed.
DB2INST1.Test - Roll back completed successfully.


Any suggestions?