RE: SQL vs. traditional I/O?

You may be right there.

There is 'user defined types'.  That's pretty close.  But, I'll grant that
it's not the same thing.

There is also the LIKE keyword.  But I think that it's more of a 'table
level' keyword than a column level keyword.  In other words, if you have a
production table, and you want to create a copy in qtemp you could do
create table qtemp/worktable like prodlib/realtable


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com


|-----------------------------+-------------------------------------------|
|   Jim Essinger              |                                           |
|   <esinger@xxxxxxxx>        |                                           |
|   Sent by:                  |                                         To|
|   midrange-l-bounces+rob=dek|                                     Midran|
|   ko.com@xxxxxxxxxxxx       |                                     ge    |
|                             |                                     System|
|   07/23/2004 11:48 AM       |                                     s     |
|                             |                                     Techni|
|         Please respond to   |                                     cal   |
|         Midrange Systems    |                                     Discus|
|       Technical Discussion  |                                     sion  |
|      <midrange-l@xxxxxxxxxxx|                                     <midra|
|                m>           |                                     nge-l@|
|                             |                                     midran|
|                             |                                     ge.com|
|                             |                                     >     |
|                             |                                         cc|
|                             |                                           |
|                             |                                    Subject|
|                             |                                     RE:   |
|                             |                                     SQL   |
|                             |                                     vs.   |
|                             |                                     tradit|
|                             |                                     ional |
|                             |                                     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
--
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.