You'll need a C compiler for the OS that runs your DB server where the SP will run. It does not have to be on that server bu it has to be the same OS. If you develop off the server, then use the DB GET/PUT routines to move the executable SPs. Unitl DB2V8 Fix?? you'll still have to use a C co,piler to generate the SP. Sorry and Regards, Pierre. Pierre Saint-Jacques IBM Certified Solutions Expert - Administration SES Consultants Inc. 514-737-4515 Off. 514-737-1268 Fax. [EMAIL PROTECTED] 233 Simcoe Cr. Mount-Royal, QC Canada H3P 1X1 ----- Original Message ----- From: "Philip Nelson (DBA)" <[EMAIL PROTECTED]> To: "DB2EUG" <[EMAIL PROTECTED]>; "DB2-L" <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 11:46 AM Subject: [DB2EUG] DB2 SPs on AIX (V7.2) and no IBM C compiler
> I'm defining a SQL stored procedure on DB2 V7.2 for AIX. > > Our box doesn't have the IBM C compiler installed and the SP creation is > failing. I thought the need for a C compiler had gone away ? > > If not then is it possible to change the C compiler to use GCC, as we > don't intend buying a C compiler for this box. > > And what about getting these into production ? We don't want to put a C > compiler on the production box, due to the increased risk this poses. > > TIA > > Phil Nelson > -- > Philip Nelson (DBA) <[EMAIL PROTECTED]> > ScotDB 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 - ::: 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
