Rename field on a SQL LOAD

[Anonymous]

Hi all,

Please help me with this simple question     

Im trying to LOAD some data from a server hosted on TERADATA, and i would like to rename the "phone" field as "client phone" on the load.

any suggestions???

EXAMPLE:
SQL
SELECT
       PHONE

FROM PHONES

thank u very much!

[surendraj]

load PHONE as client phone

SQL
SELECT
       PHONE

FROM PHONES

[surendraj]

load PHONE as "client phone";

SQL
SELECT
       PHONE

FROM PHONES

[stabben23 · Accepted solution]

I'll think you have answer Your own question. it simply this

SQL
SELECT
       PHONE as "Client Phone"

FROM PHONES

or if you use preceding LOAD instead

LOAD

PHONE as "Client Phone"

;

SQL
SELECT
       PHONE

FROM PHONES

[Anonymous]

You use as in a preceding load.

LOAD

     PHONE as [CLIENT PHONE]

SQL

SELECT

     PHONE

FROM PHONES;