×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
You can create a table based on the fields from another table or physical file.
CREATE TABLE NEWTBLTB (NWKEY, NWDESC, NWRSUSR, NWRSTS)
AS ( SELECT KEY1, DESC30, RSUSR, RSTS
FROM REFFLDPF)
WITH NO DATA INCLUDING DEFAULTS
RCDFMT NEWTBLRF ;
Naming all the fields in one list following the table name makes it a little easier to read.
Much easier than using FIELD AS A, FIELD AS B, FIELD AS C
Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gad Miron
Sent: Monday, March 14, 2016 4:57 AM
To: midrange-l@xxxxxxxxxxxx
Subject: SQL DDL
Hello SQL-ians
When considering defining files/tables using SQL instead of DDS I was asked whether SQL has the DDS REF File feature - REF(LIB/FILE)
Is there?
TIA
Gad
--
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.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
midrange.com
