Thanks to all that replied to my request for info on this (especially Fred Sobotka for his info on the compile options for gcc !!!).
Progress report to date - IBM have made available a lot of Open Source software including gcc, packaged in RPM (RedHat Package Manager) format, at - The first thing you have to do to use this software is to install the RPM software via smitty. The minimum AIX level required to install this is 4.3.3 (so we are going to have to upgrade from 4.3.2). Our other servers are at 4.3.3 and I've successfully installed gcc and various other packages such as Perl (to replace the ancient version bundled with AIX) and most of the GNU tools. I've asked our Sys Admin people to upgrade AIX on this server and will then try gcc with the stored procedures. Thanks again. Phil Nelson On Mon, 2002-11-11 at 18:54, [EMAIL PROTECTED] wrote: > Hello Phil, > > I've had great success using the gcc compiler from GNU to build SQL stored > procedures on my DB2 UDB V7.2 Solaris machine, so I believe that it should > work on AIX as well. The most graceful way to persuade DB2 to compile SPs > with gcc is to set the DB2_SQLROUTINE_COMPILE_COMMAND registry variable. > Here is what mine looks like as an example: > DB2_SQLROUTINE_COMPILE_COMMAND=gcc -G > -I/export/home/db2inst1/sqllib/include SQLROUTINE_FILENAME.c -o > SQLROUTINE_FILENAME -L/export/home/db2inst1/sqllib/lib > -R/export/home/db2inst1/sqllib/lib -ldb2 > > I also needed to modify my PATH to ensure that gcc could be found by DB2. > It is possible to set this path temporarily from the > ~/sqllib/function/routine/sr_cpath script. The script modifies the path > just long enough to build the SP, in case you're not happy about changing > your permanent PATH just to build SPs. > > If you're curious, it is even possible to get the debugger in SP Builder to > step through SQL procs that were built with gcc, but I myself could only > get it to work when I connected from db2spb as the instance owner. > > Hope this helps, > > Fred Sobotka > Database Administrator > IBM Certified Solutions Expert - IBM DB2 UDB V7.1 Database Administration > for Unix, Linux, Windows, and OS/2 > CollegeNET, Inc > > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > *** For more information, check http://www.db2eug.uni.cc -- Philip Nelson (DBA) <[EMAIL PROTECTED]> Nelson Database Consulting Limited - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
