RE: Ok, where is it?

If not, then that is a great enhancement.  I am in the camp that ITMNBR 
should be ITMNBR in all files.

Makes 
Select b.itmdesc ... where a.itmnbr=b.itmnbr
easier to remember

Makes 
SELECT SYSTEM_COLUMN_NAME, SYSTEM_TABLE_NAME, SYSTEM_TABLE_SCHEMA
FROM qsys2/syscolumns 
WHERE SYSTEM_COLUMN_NAME ='ITMNBR'
better than
SELECT SYSTEM_COLUMN_NAME, SYSTEM_TABLE_NAME, SYSTEM_TABLE_SCHEMA
FROM qsys2/syscolumns 
WHERE SYSTEM_COLUMN_NAME in ('IPROD', 'BPROD', ...)
or
SELECT SYSTEM_COLUMN_NAME, SYSTEM_TABLE_NAME, SYSTEM_TABLE_SCHEMA
FROM qsys2/syscolumns 
WHERE SYSTEM_COLUMN_NAME like '%PROD%'

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





"Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
07/10/2003 03:31 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: Ok, where is it?


> From: Raul A Jager
>
> Using SQL you can do something similar to the "field reference file" The
> way to do it is to:
>
> CREATE TABLE AS (SELECT x1, x2, x3, ..., etc. FROM FLDREF) DEFINITION 
ONLY

This is very nice, Raul.  How about this:

CREATE TABLE AS (SELECT x1 as y1, x2, ... FROM FLDREF) DEFINITION ONLY

Is this possible (to rename the fields when you are creating the table)?

Joe

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