When I write to the Oracle database with specific field names, all the fields appear as
FIELDNAME=E13, ALIAS=E13, USAGE=A10, ACTUAL=A10, $
FIELDNAME=E03, ALIAS=E03, USAGE=A40, ACTUAL=A40, $
FIELDNAME=E01, ALIAS=E01, USAGE=A40, ACTUAL=A40, $
FIELDNAME=E09, ALIAS=E09, USAGE=A2, ACTUAL=A2, $
FIELDNAME=E08, ALIAS=E08, USAGE=A3, ACTUAL=A3, $

Rather than the expected field names such as CUSTOMER_ID, STREET, CITY, STATE, CTRY.

What can I do to send the names below to oracle rather than the E* names? The fex is below.



SET ASNAMES = ON

SET SQLENGINE = SQLORA
SQL SQLORA COMMIT

TABLE FILE ZZ_ZZZ_ZZZZZZZ
PRINT
STREET
CITY
STATE
CTRY
BY LOWEST CUSTOMER_ID
ON TABLE HOLD AS XX_XXXX_XX FORMAT SQLORA
END

This message has been edited. Last edited by: Geri,

Try this..

SET ASNAMES = ON

SET SQLENGINE = SQLORA
SQL SQLORA COMMIT

TABLE FILE ZZ_ZZZ_ZZZZZZZ
PRINT
STREET AS 'STREET'
CITY AS 'CITY'
STATE AS 'STATE'
CTRY AS 'CTRY'
BY LOWEST CUSTOMER_ID AS 'CUSTOMER_ID'
ON TABLE HOLD AS XX_XXXX_XX FORMAT SQLORA
END


Since the fex name is stored already with an 'AS' name, it seemed like it would copy that way to Oracle.

You are correct, adding the 'AS' name here created the name correctly in Oracle.

Thank you!