DSXchange

even if i ensure the first row will always be headers, then how do i query to select all rows except first row, is there any db2 sql to do so?? i didn't find any in forums. plz provide me one sql where i can exclude first row.

Ray,
as said in my first line.. data is there in table with one column and data residing is delimited by comma, i tried to use Filed function in transformer to split one column into multiple columns but i need to ignore the one row which has column names.. i hope you got what i'm saying.

I have data in one column which is separated by comma which look like below 1st row MTCN,Rec Date,Payee Name,Sender Name,Rec Acct,TID,OPID,NETID,Orig-Pay-NAID,Cnl-Acct,TID,OPID, PRD,Prin,Charges,Tot fee,Gross,Del Svc,Comment 2nd row `973XXXX80,03-06-13,JOSE ALFREDO\GUTIERREZ VASQUEZ,JOSE ALFREDO\GUT...

I have installed DS 7.5.3 on Solaris and Oracle 9i(9.2.0.8) client on the same server. Insatllation went fine without errors. I made below oracle parametes entries in dsenv file and rebooted the Datastage ************* ORACLE_HOME=/app/oracle; export ORACLE_HOME TNS_ADMIN=/app/oracle/network/admin; ...