SQL STORED PROCEDURE

[radhika]

i am trying to create a stored proc and getting this error...

xlC -I/home/db2owner/sqllib/include P5640620.c -bE:P5640620.exp -e pgsjmp -o P
5640620 -L/home/db2owner/sqllib/lib -lc -ldb2

*** /home/db2owner/sqllib/function/routine/sqlproc/GFSDBS/TEST/tmp/P5640620.exp
***
pgsjmp
sh: xlC: not found.

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

SQL7032N SQL procedure "" not created. Diagnostic file is "". SQLSTATE=00000
my db2set parameters are not set ...

i have the following questions.
I am on AIX V 4.3
1. How do i find out that where is my C compiler.
2. What parameters and to what i have to set
3. What is my PATH in the Procedure..

Thanks
Radhika Katragadda

[Ian]

radhika wrote:

i am trying to create a stored proc and getting this error...

xlC -I/home/db2owner/sqllib/include P5640620.c -bE:P5640620.exp -e pgsjmp -o P
5640620 -L/home/db2owner/sqllib/lib -lc -ldb2

*** /home/db2owner/sqllib/function/routine/sqlproc/GFSDBS/TEST/tmp/P5640620.exp
***
pgsjmp
sh: xlC: not found.

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

SQL7032N SQL procedure "" not created. Diagnostic file is "". SQLSTATE=00000
my db2set parameters are not set ...

i have the following questions.
I am on AIX V 4.3
1. How do i find out that where is my C compiler.
2. What parameters and to what i have to set
3. What is my PATH in the Procedure..

Talk to your system admin to find out if the C++ compiler is installed. It
is not included as part of AIX 4.3.

You shouldn't need to make any config changes once the compiler is
installed; note however it looks for the C++ compiler (xlC). If you only
have only the C for AIX compiler (xlc), then you will need to change the
registry variable DB2_SQLROUTINE_COMPILER_COMMAND. See the Admin Guide
for the appropriate setting.
Good luck,


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----