Re: Ok, where is it?

Jim,

there's alot of folks that really still wonder if the move of DDS > SQL is
really progress....and some folks still just aren't sold that it's the
best thing to be doing...oh well...



On Thu, 10 Jul 2003, Jim Essinger wrote:

> Vern, James, Raul, Richard, (& all)
>
>
> Thank you for your replies.  I guess I will have to start defining my files
> using SQL scripts.  I just wish IBM would keep DDS current with the SQL
> functionality.  I like to use field reference files created in DDS, and
> then create all my files from the field reference.  That way when a field
> size has to change, one change in the reference file, and a recompile of
> file (or change file) and recompile of programs, and the change has been
> propagated through the whole system.  I don't like having to search the
> script for every time that field appears, and having to trust/hope/pray
> that I find them all, and then recreating the whole mess.
>
> I like the source reference in DDS.  I have all my generic fields defined
> 1st in the reference file, then reference them in the source.  1 change to
> the generic field, and the rest of the fields referencing the changed field
> are changed.  Great for maintenance. I guess I don't see the advantage to
> SQL scripts, other than there is functionality that DDS no longer
> offers.  How hard would it be to add keywords for some of the SQL
> functionality, and keep DDS caught up with SQL functions?
>
> Thanks again for the responses.  It does help.  If anyone has good
> maintenance tips for SQL scripts (maybe similar to the Reference file
> concept) I would love to hear from you.
>
> ----------------------------------------------------------
>
> Jim Essinger
> Senior Programmer/Analyst
> Student Loan Fund of Idaho
>
> 6905 Highway 95
> Fruitland  ID  83619
>
> or
>
> PO Box 730
> Fruitland, ID 83619
>
> 208-452-4058 Extension 133
> esinger@xxxxxxxx
>
> ------------------------------------------------------------
>
> _______________________________________________
> 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.
>