|
Point of information. UDF = User defined function (see FAQ) UDT = User defined type. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com |-----------------------------+-------------------------------------------| | Joel Cochran | | | <jrc@xxxxxxxxxx> | | | Sent by: | To| | midrange-l-bounces+rob=dek| midrange-l@midr| | ko.com@xxxxxxxxxxxx | ange.com | | | cc| | 07/23/2004 09:17 AM | | | | Subject| | Please respond to | Re: MIDRANGE-L | | Midrange Systems | Digest, Vol 3, | | Technical Discussion | Issue 1075 | | <midrange-l@xxxxxxxxxxx| | | m> | | | | | | | | | | | | | | |-----------------------------+-------------------------------------------| On Fri, 2004-07-23 at 17:00, midrange-l-request@xxxxxxxxxxxx wrote: > Send MIDRANGE-L mailing list submissions to > midrange-l@xxxxxxxxxxxx > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.midrange.com/mailman/listinfo/midrange-l > or, via email, send a message with subject or body 'help' to > midrange-l-request@xxxxxxxxxxxx > > You can reach the person managing the list at > midrange-l-owner@xxxxxxxxxxxx > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of MIDRANGE-L digest..." > > > Today's Topics: > > 1. RE: SQL vs. traditional I/O? (Jim Essinger) > 2. archiving delaying (Muralidhar Narayana) > > > ---------------------------------------------------------------------- > > message: 1 > date: Fri, 23 Jul 2004 10:48:27 -0600 > from: Jim Essinger <esinger@xxxxxxxx> > subject: RE: SQL vs. traditional I/O? > > At 10:16 AM 7/23/2004, Rob wrote: > > 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. > > The other thing that DDS _can_ bring to the table is using field reference > files, if you design your files that way. Not do-able in SQL if I > remember right. > > Jim Actually, you can. They are called UDFs or "User Defined Datatypes". Let's say you want to have a field for "OrderTotal". You can define a type for other SQL statements to use called "OrderTotal" and define it as a "numeric(10,2) not null with default". Now when I create a table, I give the appropriate field the type of "OrderType". And for clarity, a View incorporates an index. A view has columnar abilities that are not available in DDS. A view is more than an index, where as a logical file, no matter how complex, is just an index. A view is limited to the subfields mentioned within. Joel http://www.rpgnext.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.
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
