RE: [EXTERNAL] Re: Problem with creating a file with a different field name

Thanks Dave
I suppose that would make some sense

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

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of dlclark@xxxxxxxxxxxxxxxx
Sent: Wednesday, September 26, 2018 12:25 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: [EXTERNAL] Re: Problem with creating a file with a different field name

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 09/26/2018
12:04:04 PM:

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?

I could be incorrect, but I don't think it is supported to rename the columns of a subquery from within the subquery itself.


Sincerely,

Dave Clark