SQL STORED PROCEDURE

**Ian** · Nov 12 '05, 06:13 AM

Re: SQL STORED PROCEDURE

radhika wrote:
[color=blue]
> 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..
>[/color]

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_COMMAN D. 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! =-----

SQL STORED PROCEDURE

SQL STORED PROCEDURE

Comment