RE: CREATE TABLE question (SQL)

["Christopher A. Libby" <clibby@xxxxxxxxxxxxxxxxxxxxxx>]

I think your problem may be the formatting of the command.  Instead of using
SELECT oldTable.* into newTable, try SELECT * INTO newTable FROM oldTable.
You may need to create the table first - I believe the CREATE TABLE command
has parameters to format your new table like another existing one.

---------------------------------------------------------
Christopher A. Libby, Programmer/Analyst
Maine Public Service Company (www.mainepublicservice.com)
clibby@mainepublicservice.com (207) 768-5811 ext. 2210


-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Mike Naughton
Sent: Friday, March 02, 2001 4: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 -- for
example, in M$ Access I can do it with:

SELECT oldTable.* INTO newTable
FROM oldTable
WHERE (<some conditions are met>);

but when I type STRSQL and try this on the AS/400 I get an error --
apparently SELECT INTO means something different, and I can't figure out
what else to try.

Does anyone know if this can be done?

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



Maine Public Service Company
www.mainepublicservice.com




Maine Public Service Company
www.mainepublicservice.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
+---