Hi,

One of the columns contains the £ charecter and we need to spool it out and send it. But while spooling in Unix It changes to #, I tried in DoS to check and there too it changes. Note we cant change the # to £ after spooling as other columns may contain # symbol. Can you please suggest a way.

SNEHASISH @USA >select gp_measure_name from X_DATA_KPI_MEASURE_DTLS where rownum < 10;

GP_MEASURE_NAME
----------------------------------------------------------------------------------------------------
EBITDA pre-leavers (£m)
EBITDA pre-leavers (£m)
EBITDA pre-leavers (£m)
EBITDA pre-leavers (£m)
EBITDA pre-leavers (£m)
EBITDA pre-leavers (£m)
EBITDA pre-leavers (£m)
EBITDA pre-leavers (£m)
EBITDA pre-leavers (£m)

9 rows selected.


IN DOS

GP_MEASURE_NAME
--------------------------------
EBITDA pre-leavers (úm)
EBITDA pre-leavers (úm)
EBITDA pre-leavers (úm)
EBITDA pre-leavers (úm)
EBITDA pre-leavers (úm)
EBITDA pre-leavers (úm)
EBITDA pre-leavers (úm)
EBITDA pre-leavers (úm)
EBITDA pre-leavers (úm)

9 rows selected.

Elapsed: 00:00:00.68

IN UNIX (HP_UX)

SNEHASISH @USA> select gp_measure_name from X_DATA_KPI_MEASURE_DTLS where rownum < 10;

GP_MEASURE_NAME
--------------------------------------------------------------------------------
EBITDA pre-leavers (#m)
EBITDA pre-leavers (#m)
EBITDA pre-leavers (#m)
EBITDA pre-leavers (#m)
EBITDA pre-leavers (#m)
EBITDA pre-leavers (#m)
EBITDA pre-leavers (#m)
EBITDA pre-leavers (#m)
EBITDA pre-leavers (#m)

9 rows selected.


Best Regards,
Snehasish Das.