× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



And there's nothing stopping anyone from using iSeries Navigator, etc 
against a file created with DDS to add/alter a field and thus obsoleting 
your DDS.

Once again, it's not the tool, it's how the tool is used.

And who cares if you don't have the original SQL source?  The file should 
never get deleted, if so, you should have a backup of the file itself to 
restore it.  What does the original SQL source tell you that most 
utilities don't?

Rob Berendt
-- 
"All creatures will make merry... under pain of death."
-Ming the Merciless (Flash Gordon)




PaulMmn <PaulMmn@xxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/22/2003 11:28 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Fax to

Subject
Re: changing keys of a physical file






SQL scares me, not because of the things it can do, nor because I 
don't understand it fully, but because it's so undisciplined.

With DDS, you have the source code, it's compiled, approved, 
promoted, and distributed.

With SQL, unless you're -very- disciplined (and use RUNSQLSTM (which 
you then archive)), it's all too easy to STRSQL, do some stuff, and 
exit.  And your work is not documented, not approved, and, most 
importantly, not repeatable.

--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx




Rob wrote (in part):

>However, if the goal is to keep the same key, but add other keys then you
>may wish to use SQL to create indexes.  If you are SQL phobic you can
>always create logical file DDS from scratch and use that to create your
>indexes.
>
>Rob Berendt
_______________________________________________
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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.