DSXchange

OK, kind of the opposite issue. "It worked" - did you check the job's log from the Director or does that mean the links are green in the Designer? Didn't abort <> worked ok, necessarily, hence the question.

Regardless of your query logic, you must follow the lookup rules: 1) Every column used in the 'where' must be marked as a key. 2) ? bind variables are positional so order your keys to match. 3) All columns defined in the stage must be selected in your SQL. Ancillary rule: 4) If you need to use a key...

Are you certain you commited the deletes?

I asked because I'm not that much into guessing what the problem or question might be anymore, and would prefer people learn how to ask for help. :idea: Always make sure your question / issue is clear and you've attempted to provide enough information so that (ideally) people can get right to the 's...

Please explain precisely what "I need to pass that date in the job" means.

I would start here, correct this first:

Subroutine "DSU.GetFileDate" called with 4 arguments, 2 were expected

The only thing that is safe to run 'continuously' is an RTI enabled / SOA / WISD job. I wouldn't even consider anything else. At the very least, give it a breather, a chance to stop and restart again - for example, run it over 'business hours' and then let it sit idle for some period at night... or ...

The warnings you posted are consistent or sporadic?

The 'trigger column' option tells it to create a new output file every time that value changes. Do you have an output link from the stage somewhere or is the stage writing to an output file directly?

No, DataStage doesn't but your Oracle database will definitely have limits configured in. Check with your DBA as there can be limits at both the listener, db and session levels. Remember, each stage is a connection, multiply that by the number of nodes you are running and account for any other jobs ...

And by 'backup', Andy means at the filesystem level. A zip archive of what you have now in the project directory, for instance.

And the value for the second ? comes from what column? You must mark as keys all columns in the where clause and select all columns defined in the stage in the proper order, including the keys.

Then time to mark your topic as Resolved Klaus.

What settings are you using in the stage? Is your 'result' column marked as a key?

So... you have a list in a text file of uncompiled jobs and you want to know how to find their category?