DSXchange

Unless you're running out of space there's no rush to clean them up. But, if you want to, simply use rm when there's no jobs running.

The most important piece, as will all programming, is to establish your requirements and design your algorithm before even touching any code. In the case of DataStage functions, give some thought also to whether you can make the function more generic/re-usable.

XLATE is a synonym for TRANS, as your researches will have revealed.

The syntax for OPEN and CLOSE command is "any valid SQL".

"Valid" includes your having appropriate database/table privileges to execute the said command.

Are any jobs running that might be using the scratch space? Scratch space should be cleaned up automatically - if it's not you have jobs that are aborting, and should do something about that.

Search the forum. Search the manuals. There are examples out there.

GET access. That's the only way to test things.

Your job tried to write a record to a hashed file or some other data target with a primary key, but provided NULL as the primary key value.

This is not permitted.

Make sure no NULL gets this far through your job design.

How about: FUNCTION TestJobVersion(TheJobName) * Returns job version number if found, or "" otherwise Ans = Trans("DS_JOBOBJECTS", "J\":Trans("DS_JOBS", TheJobName, 5, "X"):"\ROOT", 8, "X") RETURN(Ans&#...

Yes, for example RCP must be enabled in Adminstrator then, even if it is, can be enabled/disabled on a per-stage basis in the processing stream. Is the stage type amenable to using a schema file and, if so, is it? Will that get you going?

Doesn't time fly when you're having fun?

I'd like to add my thanks to Dennis for having the vision to create this site and its predecessor and sibling sites. Even I have been able to learn stuff from it, and it well pre-dated the "official" user community (DeveloperNet).

Try reading it as a string, and converting it inside your job.

What's the ping time on your LAN? What does that say about relative speeds?

If you're in BASIC anyway, you can open a pathed hashed file with OpenPath statement. Then use the Status statement as described above.