DSXchange

Did you build the expression(s) with the Expression Editor?

You probably need to map the job parameter to the container parameter in the container's properties tab.

Describe the Oracle-related sections of the DataStage dsenv script. My guess is that you have not completed these properly.

If the command which orchadmin returns "not found" then your PATH environment variable is not set up correctly. If you get errors about configuration, then APT_CONFIG_FILE and/or APT_ORCHHOME are not set correctly. If you get errors about libraries, then your shared library search path (LD...

NLS not installed.

But do let us know whether the data are in files, database tables or something else.

If you are using Director, no. But you could schedule using Director then edit the underlying operating system scheduler queue (crontab).

If one of you is a Suite Administrator that should suffice.

Tip: create a second, backup Suite Administrator "just in case" with the (non expiring) password for that user sealed in an envelope in a locked safe.

Repartitioning will, as a general rule, destroy any sorting (which is per-partition).

thanush9sep wrote:Dear Ray

Could you ...

Why me? And why when I have not yet responded to this post?

As you note, DataStage expects the column names to be the same for this particular check (same thing - same name). It seems to me that that's a reasonable requirement.

Name changing is free with a Copy stage.

Whatever you want to do in terms of restarting from a point of failure you must design. And that involves keeping track of, or discovering subsequently, which rows were successfully committed to the database. The only automatic restart in DataStage is from the start of the job that failed. You must ...

For some reason (I don't know what) the final column is being reported as raw. It might be worth finding out how the Sybase driver returns each row - whether there is a special, non-printing terminator, for example.

All current webinars are free with premium membership. I'm not sure of the mechanism for non-premium members.

The answer to the question is "yes".

Where are the first two fields coming from? Where is the third field coming from? How do you combine them? We can not give the best answer to your original question without this knowledge.

Reduce the total load and in particular don't do anything that needs to wait for an unexpected amount of time. Had you searched for SPINTRIES you would have found more useful tuning information.