DSXchange

The person to ask is an Oracle DBA. Somewhere (probably the tnsnames.ora file) something is not correctly configureed. Or it may be that the environment variables such as ORACLE_HOME have not been set.

What are the business rules around generating four fields when the client does not provide four fields? Resist stupid requirements. Delete your duplicate post before anyone replies to it. Use a routine to parse the record, taking account of whether or not the character is within quotes or not, and c...

Different problem: different thread.

I would.

Or, if I needed probabilistic rather than deterministic matching, I'd use QualityStage.

Try the AddMonths routine from here

Probably not. Try these date routines - particularly AddMonths.

Metadata Workbench

There's no output link from the Sequencer. That will cause the "did not exit" message. Probably the compiler should detect this; some folks use a Sequencer as a placeholder when iteratively designing job sequences, so they've left it (a Sequencer with no output) as a "valid" construct.

Jumping out can cause the "but did not complete all its iterations" or "was not exited" messages. While they're harmless, the original questions were about how to eliminate these messages.

What else does this job do? In particular, how many times do you repartition your data? Are you on an SMP environment or some form of multiple machine configuration?

All files/directories in the project that have names of the form DS_namennn or RT_namennn are the Repository tables in which information about job number nnn are stored. The only safe way to delete these is to delete the job (using one of the clients). If you need the job, then you need these files/...

Not setting the Restrict Memory Usage property does not give unlimited memory; it gives 20MB per node (unless this has been overridden by setting a different value in the environment variable APT_TSORT_STRESS_BLOCKSIZE.

DSXchange Learning Center has a DVD available on programming with the DataStage BASIC language. Or you can take a class

Not true. Before/after subroutines are written as server routines whose type is "before/after subroutines", even when they are deployed into parallel jobs. This works because before/after subroutines only ever have to execute on the conductor node, and (typically) the conductor node is where the Dat...

U will need to use some kind of mainframe scheduler, like IBM's TWS (Tivoli Work scheduler), which will handle the scheduling for u. In the scheduler u can set up multiple jobs and set up dependancies betn these jobs (JCLs). U is one of our posters, and I know for a fact that he is not currently wo...