Re: SQL Files - Source Based or Not?

Our company uses a open source product called Migrations. Scripts are
created and stored in Migrations folder which could be on the IFS.

The scripts can be any valid SQL statement (Create table, alter table,
update, etc).

The migrations manages the application of the scripts and if you move some
other library the migrations know how to run the updates.

More information at

http://maven.apache.org/

We have had very good luck with this product. We made hundreds of tables
with I don't know how many thousand changes and it manages it all
automatically.



On Tue, Mar 15, 2011 at 1:34 PM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

Gord,

Even as sometimes I create SQL views and/or tables directly from either
iNav's SQL Script editor or using iNav's wizards, I always save the SQL
source (sometimes using iNav). Besides being easier, as you wrote, to
recreate a file, it can also make it easier to create a new view or table,
as long as it is similar to one already defined.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Tue, Mar 15, 2011 at 2:20 PM, Gord Hutchinson <gordm1@xxxxxxxxxxxxxxx

wrote:

We are (finally) going to begin creating some files with SQL instead of
DDS.

Are there any issues either way with using source-based SQL or not? I
would
think that source-based files would allow for more quickly recreating
files.

Any recommendations?


Thanks,


Gord

--
Gord Hutchinson

TST Overland Express
ghutchinson@xxxxxxxxxxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.