|
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.
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
