DSXchange

That's what I thought too, Ray. When I call that routine using the DefFun that you supplied, I get: Program "DSU.UnixCmdTest": Line 11, Unable to open the operating system file "DSU_BP.O/ExecSH". My code is: FUNCTION UnixCmdTest(Arg1) DEFFUN ExecSH(InputArg, ErrorCode) Calling &q...

Yep, I can and did. I just didn't remember it till after I posted.

Tony

Is it possible to call ExecSh from a "regular" (not Before/After) routine? If so, what do I have to put in the DefFun statement to do this?

Thanks,
Tony

Thanks, Ray! I knew it had to be something like this, but didn't know where to go with it. I appreciate your help.

Tony

I have a few instances where I create a secondary index on a hash file using CREATE.INDEX hash_name keyname . These hash files have been created in a directory other than the project directory. When I run the CREATE.INDEX command, DataStage creates a directory named I_hash_name (where hash_name is t...

If you look in the DataStage directory under "Program Files" on your hard drive (wherever you have it installed), there's a "Docs" directory. In the "Docs" directory is a file called "DRSStage.pdf". This should provide you with the info you need (I hope, I hav...

You can definitely access the Oracle libraries directly by using an OracleOCI stage (OracleOCI9) or the DRS stage. The Oracle Libraries have to be configured correctly in DataStage's environment. This is usually done in the dsenv file.

Tony

Another thing you might consider: Write the data to a hash file. Add a unique key field (use @Outrownum as the value) and another field, F2. The derivation for F2 is a function (pass in Count as a parameter) (that you have to write) that returns a string of values from 1 to count, separated by @VM c...

We've managed to get by with a dev and prod instance and put them on different machines. If we had QA functionality, I would put test on a machine by itself. My reasoning is that, especially with Windows machines, anything done on development or test would affect the performance of the production jo...

The only limit for file sizes with DataStage the operating system file size limit.

Tony

Check and make sure that you have the right columns defined as keys.

Good Luck!
Tony

Martin, Of course you don't have _all_ the flexibility in a Job Sequencer that you have in Job Control code. But, you can implement some pretty sophisticated things in Job Sequencers. I don't think that we have any Job Control jobs in our projects here. Everything is done in Job Sequencer Jobs. Best...

Martin,

It's possible to do the same thing from a Sequencer Job.

Tony

I thought it might, but couldn't find it when I looked in the manual. Ah well, at least I was trying to help.

Tony

I can't remember if the Link Collector requires Row Buffering and/or Inter Process to be enabled. Have you tried disabling Row Buffering?

Tony