Insert Header Name

Shell Programming and Scripting
1

Can anyone help.
I have sql to CSV showing header with ALIAS names but I want to generate CSV file with user friendly name i.e from AIAN8 to Adress Book Number etc.
SELECT AIAN8 || , || F0101.ABALPH || , || AICO ||

showing following below in CSV output intead of above

Address NumberCustomer Name Company

thanks
Akbar

2

change the alias names of the column to whatever name you want and run the query

3

I also would like to go with Vidyadhar85 if I understand your question properly...

Thanks - Kripa.

4

post your full query that might help

5

@@\.login_JDEDB.sql
set echo off
set verify off
set feed off term off
prompt ********************************************************
prompt Todays Date
prompt ********************************************************
prompt This SQL runs every Monday prompt ********************************************************
set feedback on
set echo off head off feed off veri off trimspool on
spool /home/oracle/log/Weekly_BlueGrassCrdHld.csv
set heading on;
set linesize 200;
SELECT AIAN8 || ',' || F0101.ABALPH || ',' || AICO || ',' || AIHOLD || ',' || AIARC || ',' || AIACL || ',' || AITRAR || ',' || F0014.PNPTD || ',' || AIBADT || ',' || F0101.ABAN81
FROM PRODDTA.F0014, PRODDTA.F0101, PRODDTA.F03012
WHERE F0101.ABAN8 = AIAN8 AND F0014.PNPTC = AITRAR AND ((AICO='00271') AND (AIHOLD>'1'));
spool off
exit

What I am getting with above sql is CSV file with Header as shown within pipes || ||. I need to chage those to user friendly names like Adress Book etc.

Thanks for you help.

Akbar