|
Do you keep your DDS source only in QTEMP? Probably not. Do you keep your SQL source for RUNSQLSTM only in QTEMP? Probably not. Was that your question? The rest of the visibility is the same with DSPFFD, etc. The thing that RUNSQLSTM brings to the table is a single store for things that DDS cannot store in the same member. Things like: adding of constraints implicit journalling and the list goes on The ONLY advantage DDS has over SQL is the ability to combine an index with a view. Or, in DDS terms, the ability to create a logical file with field and/or record selection and a key. However this is only an advantage in traditional I/O. In SQL I/O you would read the 'view' or the file with the field and/or record selection. And the optimizer would use the appropriate 'index' to find the best key. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com |-----------------------------+-------------------------------------------| | "Bob Cagle" | | | <bcagle@xxxxxxxxxxx> | | | Sent by: | To| | midrange-l-bounces@midrang| "Midran| | e.com | ge | | | Systems| | 07/23/2004 11:03 AM | Technic| | | al | | Please respond to | Discuss| | Midrange Systems | ion" | | Technical Discussion | <midran| | <midrange-l@xxxxxxxxxxx| ge-l@mi| | m> | drange.| | | com> | | | cc| | | | | | Subject| | | RE: SQL| | | vs. | | | traditi| | | onal | | | I/O? | | | | | | | | | | | | | | | | | | | |-----------------------------+-------------------------------------------| That I definitely do not understand - why define the tables with SQL when DDS works? With SQL defined tables, don't you lose some of the visibility of the definition itself - namely the DDS? Bob Cagle -----Original Message----- From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx] Sent: Thursday, July 22, 2004 2:52 PM To: Midrange Systems Technical Discussion Subject: Re: SQL vs. traditional I/O? A tangential argument is defining data with SQL versus DDS. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com -- 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.
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
