You need to add "with data" after the closing bracket.
Get Outlook for Android<
https://aka.ms/AAb9ysg>
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of James H. H. Lampert <jamesl@xxxxxxxxxxxxxxxxx>
Sent: Friday, May 21, 2021 6:30:58 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: How do I create a new file from an SQL query on an existing file?
How do I create a new file from an SQL query on an existing PF, in a
STRSQL session?
I tried, as an experiment,
CREATE TABLE QTEMP/FOO AS (SELECT . . .
and I got
Token <END-OF-STATEMENT> was not valid. Valid tokens: DATA WITH
DEFINITION.
As another experiment, I tried
SELECT HAM, EGGS, SPAM INTO QTEMP/FOO FROM . . .
and I got
SQL statement not allowed.
What am I missing?
--
JHHL
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
