DSXchange

Hi , I am trying to convert .txt to .csv , it is comma delimited ... Data looks like this; "120","120","","7935","221539559","0", "PPM, NJ INC/GAL" ,"PPM, NJ INC/GALE CENTER","" When I am converting it and view...

Hi,

Date is coming in 9/30/2003 17:30 when I use same function Its not working...just giving me 00:00:00 that means iconv oconv not working ...

Can you please sugest what to use..

Thanks.

Thanks a lot Craig, I really appreciate ur help ... It worked fine ... Only there is small typo in ur code ...the code is as follows for future ref for anyone... OConv(IConv(Trim(tdAdmission_From.ReferralDate),"D"),"D/YMD[4,2,2]"):' 00:00:00' thanks again ... It was very very hel...

Hi , The date is coming in the text file in this format: 2/4/2002 I am convertinbg it into transformer as following : If IsNull(trim(tdAdmission_From.ReferralDate)) then @null else oconv(iconv(trim(tdAdmission_From.ReferralDate),"D/MDY[2,2,4]"),"D/MDY[2,2,4]"):' ':'00:00:00' Then...

Thanks craig,

I used Iconv function , it worked fine ......

If IsNull(trim(FIELDNAME)) then @null else iconv(trim(FIELDNAME),"D/MDY[2,2,4]")

Thanks...

Hi , I have simple job load data from text file to oracle table. The dates are coming in following format : 9/16/1989 when I am trying to load into oracle its loading nothing (null) , i tried using iconv , oconv but no use , Can you please explain what i have to use , I tried to read iconv and oconv...

I have a job which uses aggregator stage , It runs fine for small data but when it reaches 3.9 mil it aborts , without specific warning just 'Abnormal Termination' I am not sure what is going wrong ..... I tried same logic in sql query which runs fine in toad but giving problem in OCI stage : SELECT...

ok .

hi lisa ,

Thanks , That is one of the option we r planning to implement ,
But again many factors r involved ...

Not sure what it is ...we r still looking for other options, i will try to get more information on it ,
Thanks .

Thanks .

Thanks ,

I will look into it ...

where can i find more info on odbc and its requirement...?

Thanks for quick replay,

How can i dump the Ms access into files ...i have read priveleges to MS access database ( on remote server) ..there is no funding to buy ODBC drive ...have to find some round about way to load data on regular basis ...

Hi , My source is MS access but I can not load using ODBC as datastage is installed on unix and access is windows .. We do not have drivers for ODBC .. What is the other way I can load MS access to Oracle. Can we do it on Database (MS access - Oracle) level without using Datastage ? I found one tool...

hi guys ,

thanks a lot for your help, at least i could create afile , and captured diff lines thro' stage variables