db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sedillo, Derek \(Mission Systems\)" <Derek.Sedi...@ngc.com>
Subject RE: IJ scripting - parameters or variables?
Date Mon, 30 Apr 2007 15:26:37 GMT
Anyone out there using scripts? 

-----Original Message-----
From: Sedillo, Derek (Mission Systems) [mailto:Derek.Sedillo@ngc.com] 
Sent: Friday, April 27, 2007 11:25 AM
To: Derby Discussion
Subject: IJ scripting - parameters or variables?


Currently we perform all our Oracle DB builds using SQL scripts.  The
scripts take parameters such as the install directory which varies from
server to server, development vs. production, etc...  

Is there any way to pass in variables to ij SQL scripts or define local
variables?  If not do you have to manually 'hard code' everything in
your scripts?

Here is a code snippet from one of our Oracle build script:

-- to use this script:
--    Parameters -
--      1st Param:  INSTALL_DIR
--      2nd Param:  SID_TO_BUILD
--      @build_unclass_db.sql INSTALL_DIR SID_TO_BUILD
--    EXAMPLE:
--    @build_unclass_db.sql ora3 DEV1
-- ***************************************************
define INSTALLDIR=/&1/&2
define CUR_SID=&2
define ORACLE_BASE=/&1

Is there any spec on ij scripting syntax?  So far the only documentation
I have discovered is 'very' minimal:

Thank you for any help on the matter.

- Derek

View raw message