DSXchange

Hi , I am not sure how to go ahead with this issue... I have 3 tables where i have to insert or update data into tables. The problem i am having is if at all the job gets aborted due to the insert into the third table....can we roll back the trasaction (Insert) rows into first and second tables. App...

Thanks a lot chulett. I wrote a script and its running fine

Thanks chulett for you reply.

Does it mean that i have to run the script in datastage as EXesh before.

sorry for posting in the wrong forum...

is there a way to get files from the sftp server using datastage

Let me be clear...

Can we achieve getting the files from SFTP server using FTP stage in Datastage 8.0.1

hi, I am having a problem using FTP entraprise stage. With in the stage i have used the URL- ftp://host/filepath and added the userid and password. I ma getting the below error - is not valid remote file. not sure....when i using ftp from outside it works...infact its "sftp"....is there an...

hey thanks for the reply Infact this is a webservice and the problem is if i get 10 rows and in which i have 5 rows with "02" and 5 rows with "00" ...so since there is a row coming with "02" i have to change all the column values to "02" instead of "00&qu...

Hi Gurus, I am a bit confused how to do this.. Please share your thoughts... say i am getting 10 rows from source in which i have a column called row number. Eg:- rowno. model customerno. state 01 00 12334 IL 02 02 9876 CA 03 00 98767 LA Now my requirement is - if in the column "model" whe...

thanks a lot guru it worked for me

thanks ashis/ray

I just realized that the fixed width is at oracle end. when i am doing a lookup @ the oracle db i am gettng this error....is there a way to just make both (source and lookup) fixed widht

come on its the problem with the fixed with lenght

Its a sparse lookup and the field "a'' comes in the lookup. I have to check for the available lookup and then pass it on.

Reg. SQL its just select statement

thanks for the reply. Let me expain - I have 4 fields and a,b,c,d i have to do a lookup for "a" on oracle db. so the job desing is sequentialfile - transformer- lookup-dataset so when i add all the four fields in transformer the lookup fails..but when i just pull field "a" the lo...

Hi Guru's, I am not sure how thsi fixed lenght works..... I am facing a problem - I have 4 fields where i have to do a lookup for a particular field against oracle Db. all the 4 fields have varchar 10 nullable "Y" . Not sure why this is happening. If i just take one field into the transfor...

can you tell me how to do...sorry my ignorance