Re: Where do you store the SQL source for your tables, views, etc?

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

Hi David,

I store SQL in QSQLSRC and DDL in QDDSSRC.
We have a mix of DDS and DDL so to avoid having to look in two places,
every time I convert a table from DDS to DDL or create a new table, the DDL
goes into QDDSSRC.


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (905) 486-1162 x 239
Cell: (416) 317-3144


On 13 March 2017 at 10:08, David Gibbs <david@xxxxxxxxxxxx> wrote:

> Folks:
>
> I'm just curious ... where do you store the SQL source for your tables,
> views, etc?
>
> Do you put it in a source PF?  If so, what name do you use?
>
> Here, we put SQL source in QSQLSRC.
>
> Thanks!
>
> david
>
>
> --
> IBM i on Power Systems: For when you can't afford to be out of business!
>
> I'm riding a metric century (100 km / 65 miles) in the American Diabetes
> Association's Tour de Cure to raise money for diabetes research, education,
> advocacy, and awareness.  You can make a tax deductible donation to my ride
> by visiting http://mideml.diabetessucks.net.  My goal is $6000 but any
> amount is appreciated.
>
> You can see where my donations come from by visiting my interactive
> donation map ... http://mideml.diabetessucks.net/map (it's a geeky thing).
>
> I may have diabetes, but diabetes doesn't have me!
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD