Hi,

have you ever tried to use iSeries Navigator Database?
With Run an SQL Script, your can store your "source code" in the IFS. After reopening the source code it is possible to reexecute it.

With reverse engineering the source code from any database object can be generated and stored in either a traditional source file member or in an file with extender .sql that can be stored in either IFS or on your PC.

With release V6R1 the CL-Command RUNSQLSTM is enhanced to run on IFS files.

Birgitta

Syd,

the way I do it is to create an IceBreak setup or installation program that can check various settings and use embedded SQL to create a collection, then tables, views etc. and maybe even insert test/demo or default rows in the tables. It's quite easy and all you need to do is to use:

 
 <@ language="SQLRPGLE" options="........" %>

 instead of just:

 
 <@ language="RPGLE" options="........" %>

 then in you main or subroutine you use:

 
  /exec sql CREATE COLLECTION MyLib;

  /exec sql CREATE TABLE MyLib/MyTable1 .....;

etc.

If you create it so that it can take different parameters you will be able to use the same program for inserting or checking for default rows later on, which the user or someone else might have removed.

You can even store your default SQL's in an XML file that you distribute with the program, or download the SQL's from your website... this way you can distribute your program and make sure that when people install it or use it for the first time, the up-to-date SQL's are executed.... or maybe even "repaired".

You might even hardcode some variables like ${LibraryName} inside your SQL and ask the user for the library name before replacing this constant with the selected library and then execute SQL that has the correct library. I'm sure you can think of even more possibilities like this....