Re: Field Reference File (was SQL vs. traditional I/O?)

[rob@xxxxxxxxx]

I knew it was there.  Thanks.

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


|-----------------------------+-------------------------------------------|
|   "Paul Tuohy"              |                                           |
|   <tuohyp@xxxxxxxxxxxxx>    |                                           |
|   Sent by:                  |                                         To|
|   midrange-l-bounces@midrang|               "Mailing List, Midrange"    |
|   e.com                     |               <MIDRANGE-L@xxxxxxxxxxxx>   |
|                             |                                         cc|
|   07/23/2004 02:23 PM       |                                           |
|                             |                                    Subject|
|         Please respond to   |               Field Reference File (was   |
|         Midrange Systems    |               SQL vs. traditional I/O?)   |
|       Technical Discussion  |                                           |
|      <midrange-l@xxxxxxxxxxx|                                           |
|                m>           |                                           |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|-----------------------------+-------------------------------------------|






Jim,

You can emulate a field reference file using the WITH NO DATA clause.

CREATE TABLE EMPLOYEE AS
(SELECT EMPLOYEE_ID, NAME, etc. FROM FIELDREF)
WITH NO DATA

Not sure if it was V5R1 or V5R2 it was introduced.

HTH

Paul Tuohy

>> Jim Essinger wrote

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.