The syntax is:
CREATE OR REPLACE TABLE AS (SELECT ...)
You missed the AS before the SELECT-Statement!
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of Alan Shore
Sent: Mittwoch, 26. September 2018 18:04
To: midrange-l@xxxxxxxxxxxx
Subject: Problem with creating a file with a different field name
Hi everyone
Before I forget - we are on V7r3
When I use STRSQl with the following command Select Cust# as Customer_nbr
from File01 where FieldB = 'SOMEVALUE'
Data is displayed, with the column heading Customer_Nbr
When I run the same query AFTER pressing F13, choose 1. Change session
attributes Change SELECT output to 3 (for File) and define a file name The
file is created, with the field Customer_Nbr
However, when I change the query to the following Create or replace table
qtemp.allcusts (Select Cust# as Customer_nbr from File01 where FieldB =
'SOMEVALUE') With data I get the error Token CUSTOMER_NBR was not valid.
Valid tokens: ( ROW IDENTITY TRANS And the cursor is under the C of
Customer_nbr
Anyone any idea what I am doing wrong?
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill
--
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:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
