RE: CREATE TABLE question (SQL)

["Mackie, Roger L. (Precision Press)" <RLMackie@xxxxxxxxxxxxx>]

In STRSQL, get the select statement the way you want without the into
clause. Then F13 and choose option 1 to change session attributes. In the
prompt screen put "3" in the "Select output" field, hit enter, and fill in
the other fields to create the kind of file you want.

Rlmackie@ppress-tc.com 

-----Original Message-----
From: Mike Naughton [mailto:mnaughton@juddwire.com]
Sent: Friday, March 02, 2001 3:26 PM
To: RPG400-L@midrange.com
Subject: CREATE TABLE question (SQL)


My boss asked me this, and so far I haven't found an answer. Is it
possible (on an AS/400) to create a new file (table) using SQL from and
existing file (table)? I know it is possible in other environments 
...
TIA,

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---