DSXchange

Hi We have installed Infosphere 8.5 server edition on Windows 2008 server.We have configured Infsophere 8.5 to use LDAP user registry. We have created 4 global AD Domain groups DataStage Developers DataStage Managers DataStage Operators DataStage Testers We have added a user named "testuser&quo...

Hi Ray,

We have passed only the key coulmns on which we are deleting rows in target table and it worked.Thanks



Thanks
Kiran

Thanks Ray.

Can you suggest something that we can do here for (:1 to :4 and beyond)
as I have mentioned our requirement was to delete all the rows in the target table that matches to the input "report_date" before loading into target table.



Thanks
Kiran

Hi We are trying to execute a user defined sql using bind variable in "before" option in the SQL tab in OCI stage. Our requirement was to delete all the rows in the target table that matches to the input "report_date" before loading into target table. Hence,we are running user de...

The project name given does exist and it is correct.

project name = default

Let me try some other options

Thanks
Kiran

I am still getting the error with the below istool export -domain dsetltest2he:9080 -username etltestadmin -password xxxxxxx -archive testfile.isx -datastage ' -incexec "dsetltest2he.ds.ad.adp.com/default/Jobs/*.*" ' "Export failed: Project not found : default" Thanks Kiran

Hi Chulett I have tried the below options from command prompt. 1. istool export -domain dsetltest2he:9080 -username etltestadmin -password xxxxxxx -archive testfile.isx -datastage ' "dsetltest2he.ds.ad.adp.com/default/Jobs/*.*" ' 2. istool export -domain dsetltest2he:9080 -username etltest...

As mentioned above,we are using Infosphere 8.5 server edition on Windows 2008 server. The info you mentioned above was related to Unix server. Can you please let me how to create the .isx file from the datastage assets(jobs) on Windows 2008 server using istool command? Or Is there any other option o...

Let me try these options from command prompt

Thanks
Kiran

We are migrating from Datastage 7.5v server edition(Windows 2003 server) to Infosphere 8.5v server edition(Windows 2008 server) We have been using Datastage Version Control in 7.5v.We found that this component has been replaced with InfoSphere Information Server Manager I had did some hands on "...

Thanks Chulett and Ray. If I enable the "Contains Terminators" to yes,I am able to read the value of the field before the new line character. however the value after new line character is ignored. Is there anyway to replace that newline character with some space so that I can read the valu...

Hi We have got a situation to handle new line character for one of fields in a txt file,while reading from sequential file stage in server 7.5v jobs on windows platform. Can any one let me know,if any possibility of handling this in datastage jobs or do I need to use some batch script to handle this...

We can pass parameters to run shell script in the ExecCommand stage same as that of shell script in Unix.

Example : you can type in the ExecCommand stage as below and it should work.

ksh test.sh #parameter1# #parameter2# #parameter3#




Thanks
Kiran

Hi

We have insalled Infosphere 8.5 server edition on 32 bit Windows 2003 server.

As a pre requisite for installation,we have disabled the Windows Firewall.


now that we have installed Infosphere 8.5 and it is up,can we go ahead and enable Windows Firewall?



Thanks
Kiran

Hi Ray As already mentioned,this is happening only in one particular project. However,the jobs are getting compiled and running fine in this project. Not sure what exactly you are mentioning that might have "Changed". Can you please through a light on what you think that would have "C...