DSXchange

I do believe our client has got support for the software. However, question of patches would come up only if we know that DS 7.5 is incompatible with all or any release of Oracle 11g (11.x.x.x). If you or someone can provide at least this information, it would be helpful for us to proceed further. T...

Thanks for your advise. However, we do not have any Official Support Provider. We work on Datastage for our client company who use this software as one of their official products. We needed to know of the compatibility of the software with Oracle 11g so that we are in a position to provide a suggest...

Good Morning, We have a recent database upgradation project where we are moving from Oracle 10g to Oracle 11g. While we have been successfully running Datastage 7.5 Server Edition ETL jobs against Oracle 10g database, we would like to know in case there are any compatibility issues with Datastage 7....

We need to evaluate Datastage ETL tool based on the information we receive against the following queries we have. Kindly provide us the information if available with anyone. Any help would be appreciated - (1) Version/Change Control Support: Ability to save multiple versions. Ability to port code ac...

Hi, We have been firing our Datastage sequences in both parallel and sequential mode through Shell Scripts in UNIX as per our earlier design. We would now want to change this format and put some other jobs in Sequential and others in Parallel. For this We would need to completely understand the logi...

We are trying to comment out few SQL statements from the After SQL or Before SQL tab in Oracle OCI stages in Datastage Server version 7.5. We have tried a no. of options like - /* Delete from table_name*/ -- Delete from table_name #Delete from table_name# How ever none of the above 3 options worked....

Thanks! That might just help!

Thanks for the info! However, I would just request you to let me know (if possible), the exact Patch #. I have tried to contact IBM with the name "ds_xpsp2", however, they were unable to identify the patch. They want the exact patch #. It would be really helpful, if you can provide this. T...

Hi, Could you kindly provide the download link or the website where this patch would be downloadable? Our Systems Group personnel was unable locate the software anywhere in the IBM portal. Does the patch have any other name by which it is available on the IBM web portal ore is it exactly named as &q...

Could you kindly specify which patch you are referring to? I guess you are referring to a Windows patch and not a datastage patch. It would be very helpful, if you can name the patch or atleast the no.

I am working on Datastage Server version 7.0 and am trying to llok into the Job Properties of the Job Stage within to view the Job parameters set within each stage. I am right-clicking on the Job and trying to view the Job Properties of the Job Stage and it simply does not show up. I am not sure whe...

Hi this is the contents of the 'dsenv' file under the location - $DSHOME - /usr/Ascential/DataStage/DSEngine -------------------------------------------------------------------------------------- set +u if [ -z "$DSHOME" ] && [ -f "/.dshome" ] then DSHOME=`cat /.dshome` e...

Hi, I tried to run my 11 datastage job sequences thru a UNIX shell from the console. This sequence would in turn fire the datastage jobs within it. But the job run failed and I recovered the following error messages from the Error file in UNIX:- The errors read like - ld.so.1: dsjob: fatal: libvmdsa...

Hi, I had personally faced a problem while working on my Datastage project. I had a few Categories (Folders) within which I had numerous DS Jobs. Now it is really painful to go and open each Category(Folder) and look for the particular job I need. Is there any mechanism within any of DS (Director, M...

My question is simple, the workaround that we have in version 7 has worked fine. Moreover we do not need any workaround in 7.5.2. I just needed to know that is this a common/known problem with DataStage version 7 and Oracle 9i compatibility or is it simply design problem from our part, that we could...