DSXchange

Silly as it might sound, try forward slash in the pathname rather than backslash. E:/XXXX/test.txt If the pathname contains spaces you may need to ensure that it is quoted, just as you do with many other DOS applications. Can you get job J1 to work in isolation? (Because it is Crashed you will need ...

Do you actually have a job number 21 that has been compiled?

CLEAR.FILE is also blocked (it attempts to take an exclusive lock) if the log is open - typically in Director.

As Craig said, you need an Abort situation. Even to trigger the Exception Handler. And it won't be triggered at all if the activity that fails has an explicit failure trigger.

Out of the box there is a limited range of rule sets provided, as you note.

DSXchange Learning Center has DVD-based training materials on working with Rule Sets and on Pattern Action Language (which you will need if creating your own rule sets).

Show us what you are doing (the actual code, surrounded by Code tags).

You can not CALL a transform function.

You must declare it with a DEFFUN declaration, and then use it as a function in your code.

You recall incorrectly. Upper-case cataloging only applies to the routines supplied with DataStage, such as the SDK routines. User-written routines have case-sensitive Catalog names, with "DSU." as their prefix.

Search

This question has been asked and answered very many times, including recently.

No idea. It depends on very many factors, among them the hardware and topology of your site (for example whether Oracle server is on the same machine as DataStage server).

Please mark this thread as Resolved using the green button at the top.

If you've already filled the field with five characters (space or otherwise) then APT_STRING_PADCHAR does not need to be invoked.

It may appear long, but it's simply a list of INSERT statements then a COMPILE.DICT command. Beware that the column names list varies. INSERT INTO DICT DS_AUDIT(ID,CODE,LOC,NAME,FORMAT,SM) VALUES ('KEY','D','0','Class\ID','40L','S'); INSERT INTO DICT DS_AUDIT(ID,CODE,LOC,NAME,FORMAT,SM) VALUES ('DTC...

Funnel stage will bring them back together.

But I think LAG is the optimum solution - what if there is more than one gap in the dates?

You tell us nothing.

WHY is job J1 "always crashing"? What error message is logged?

Have you provided any domain (Information Server) users with "DataStage user" credentials (suite role)? If so, have you allocated DataStage roles to those users or to groups to which they belong?