DSXchange

This functionality does not exist in dsjob -ljobs.

You would need either to use a DataStage/SQL query against the repository, or a script using dsjob -jobinfo for each job whose name appears in dsjob -ljobs. And even then, does dsjob -jobinfo return the category?

Did you perform the investigation into rsh configuration suggested in the messages?

That's a reasonable assumption.

Your vendor should have provided a licence file with everything you need. Take it up with them.

Actually I prefer locked for update and NOT cached. But it depends, primarily on how the cache is established.

Checking "log warnings after activities that finish with status other than OK" in every job sequence is my preferred way of making warnings (as well as errors) visible "up the chain of control".

I try always to create jobs that don't abort.

Investigate the Julian date conversions.

What data types do you get when you import the table definition?

Export them from a project where they exist, with "include read-only objects" selected, then import into the project from which they have been deleted. The most creative punishments involve electricity, but there's a nice "blue screen of death" screensaver available from sysinter...

It is a very unusual requirement indeed to do sorting or repartitioning on the input to a Data Set stage. But, yes, if you are doing that then the tsort or partitioner operators may use scratch space if there is insufficient memory available.

Most recent is 8.1. Version 8.2 will come out later in 2009.

Not open by ANY client on ANY user's machine?

LIST.READU can tell you - look for a lock on RT_LOGnnnn

All nodes are working if you don't get error messages. You can monitor the job in Director choosing the "Show Instances" option to get row counts and CPU usage on a per-node basis.

U can try this function; YearFromDate(CurrentDate())-1 U (one of our posters) did not ask the question. The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange. Among other things it makes...

U can try this function; YearFromDate(CurrentDate())-1 U (one of our posters) did not ask the question. The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange. Among other things it makes...