Phil,
You still do need a C compiler for your development box, but IBM does
provide a facility for moving the SP's to another box that does not have
the compiler using the "get routine" and "put routine" commands. These
aren't really documented in the manuals (at least, not that I've been able
to find them), but IBM did send me a PDF document that describes how to use
these commands. Basically, the "get routine" will zip up the executable
load module, the .bnd file, and the stored procedure definition into
something called a .sar file. You can then ftp the .sar file to your
target box and then execute the "put routine" command. The "put routine"
will unzip the .sar file, store the executable load module into the
appropriate directory, perform a bind, and store the definition of the SP
in the DB2 catalog.
I can send you the PDF documentation directly if you want.
-------------------------------------------------------
Bill Gallagher
Database Administrator
Information Technology
Infrastructure / Operations
Phoenix Life Insurance Company
860-403-1773
[EMAIL PROTECTED]
"Philip Nelson
(DBA)" To: [EMAIL PROTECTED]
<teamdba@ATTGLOBAL cc:
.NET> Subject: DB2 SPs on AIX (V7.2) and no
IBM C compiler
Sent by: "DB2 Data
Base Discussion
List"
<[EMAIL PROTECTED]
ASSOC.COM>
11/11/02 11:46 AM
Please respond to
"DB2 Data Base
Discussion List"
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
================================================
To change your subscription options or to cancel your subscription visit
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can be reached at [EMAIL PROTECTED]
-
::: 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
