Re: Problem with creating a file with a different field name

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?