DSXchange

Enhancement requests to Ascential do not cost anything! But maybe I'm wrong and that's why my enhancement requests never get included

C.

The Oracle bulk loader is great for inserts!

What do you do if you need to do bulk updates?

Ta,
C.

Regardless of the array size when writing to Oracle, I have noticed that DataStage will still log a warning in the log if a DBMS reject occurs (irrespective of the reject checkbox in the constraint being ticked). Ray, this suggests to me that DataStage might know which row(s) generated the warning(s...

Hi, I'm curious about the array size = 1 aspect of this discussion. :? I don't profess to know the reason why array size needs to be set to 1, but since the OCI plug-in doco says it has to be, then this obviously has a negative impact on the performance of the job if a large number of rows needs to ...

Hmmm??? I will have to test again but the last time I tried it ran as I described???

Ta,
C.

Thanks.

Nice, but would this come under the heading of "use with caution as Ascential may change how they do this"?

C.

Here's a sample Win batch file I have created to call dsjob. Hopefully this might inspire others who have far superior ones to share them! ====================================== rem Set params set vSERVER=%1 set vUSER=%2 set vPASSWORD=%3 set vDS_PROJ_NAME=%4 set vDS_JOB_NAME=%5 set vPARAMS=%6 rem Ch...

What version are you on please Kim?

I did (see my first post).

We have built a DS routine that we use to execute all our DS jobs from within a sequence job or JC job. This routine does groovy stuff like: * manage the passing of parameter values (static and dynamic) to the child job * reset child jobs not in a runnable state * capture child job runtime statistic...

DS7.5 allows you to have basic expressions in the properties of the job activity stage in the sequence job. This means you can do more than simply pass parameter values from the parent sequence job to the child job. DS7.1 does not have this luxury. Not sure what happened to the 7.2, 7.3 and 7.4 vers...

I was able to find Ken's UNIX script but alas, no Win scripts...

Thanks Ray. My "at" listing of a scheduled job on my DataStage server (DS7.1 Win) provides the following command line: vmdsr_sched.exe u:\datastage\projects\dwprd MPARK_Master_Sequence /50 1 where MPARK_Master_Sequence is my scheduled job name. Perhaps DS does not execute the job via a BAT...

Hi, I'm looking for a sample Windows batch file for executing dsjob. I have created UNIX versions in the past but would love to be able to leverage someone else's windows scripting talents! I have searched high and wide through dsxchange and Ascential DEVNET but alas... Any help much appreciated. Ta...