Hi

I'd like to convert the below given oracle query to informix format

SELECT
RPAD(cal_date,10),
RPAD(holiday_name,35),
RPAD(BUS_CAL_OID,24)
FROM TDEPM\.t_holiday";

which gives this result

2004/10/18/holiday day1 449fffffffff515d00000001
2004/10/29/early halloween 449fffffffff515d00000001

i tried this query in informix

SELECT
RPAD(cal_date,10) ||
RPAD(holiday_name,35) ||
RPAD(bus_cal_oid,24)
FROM holiday

but it is giving me

this result when i unload to a file

2004\/10\/18/holiday day1 449fffffffff515d00000001/
2004\/10\/29/early halloween 449fffffffff515d00000001/

Can anyone help me to work around it please ?

Regards
--Binoy