DSXchange

Ray, But if we don't want a common directory to store script, is there a way to distinguish the directory path where the script resides. I have been trying to use the CMD command and concatinate the parameter line. It's not working. Now I am trying to use the sh -c command. Still having problems wit...

Yes, but what are my other alternatives on a Windows box. Can I create a UNIX script and call it. Would this work with the MKS Toolkit.

We have multiple environments. I would like to use the Exec Command stage to execute a BAT file. The problem is, I would like to change the directory structure to point to the Environment where the BAT file resides. I tried the following ExecCommand: D:\DataStage\ Parameter: #ENV#\Test.bat Because D...

I just found out that the source system change a key datatype length that cause Oracle to hang through DataStage. Looks like Ogmios was correct. It wasn't a DataStage problem. I change the target database and everything worked fine.

Let me further explain. There is only one job processimg one table. A straight read and write. What I am not sure about is on the source Oracle EE stage it reads in sequential mode. On the target Oracle EE stage the default execution mode is parallel (which means it processes data on two nodes. You ...

Configuration: 2 nodes Datastage Job Oracle EE Source stage ====> Oracle EE Target Row count : 100000 During the run, the Oracle job hung. After investigating the hung job with the Oracle DBA, it was found that row locking was the problem. For some reason, Node 1 blocked Node 2 from inserting to the...

Your target database is Oracle. Set it's default to YYYY-MM-DD.

Could someone please provide some info, Our shop is a using an Oracle 10g database. Our Datastage server consists of a dual core process, 4 node capability with 10gigs of RAM. I created multiple jobs with multiple Oracle enterprise stages in each. My sequence executes multiple jobs that can access a...

The DatastageExport script works well. It's the Datastage popup dialogue boxes that are the problem. The script requires manual intervention everytime an export job ends before the loop can continue. I haven't found a workaround yet.

Does anyone have ant thoughts on this questions. I asked IBM and I am still awaiting a response.

Thanks

I am getting a warning message against the export telling me about omitted Read-only items. Is there a flagh to turn this off.

I got the DatastageExport script to work and it exports jobs one by one. Because it invokes Datastage, once the export completes the first job, it requires user intervention to commence the next job. Is there a way to eliminate this. I would like the script to export all jobs without having to inter...

You could always create a lookup fileset and compare and replace with the character you want.

The timestamp datatype has an extended parm in the column layout that can be set to milliseconds. DataStage accept millisecond but cannot create them.

I am trying to setup a job that will extract multiple jobs in their own unique files. The reason is that I must import them into Visual Sourcesafe. I searched the forum for answers, downloaded some of KDukes scripts and tried to use them. No luck so far. Next I tried to run the DSEXport command from...