DSXchange

Check the spelling and casing of the job parameter names. #Year# and #year# are different.

By adding directories to your command search list and your shared library search list, and setting certain required environment variables such as ORACLE_BIN. The dsenv script is executed by all DataStage processes but, as an interactive (non-DataStage) process you must executed it explicitly.

Investigate the SDK utility routine UtilityRunJob().

It should not matter what the actual generated CRC value is, provided it remains consistent for all given values on any one platform.

Even though it's not related to this problem, DataStage BASIC dimensioned arrays do have an upper limit of 65535 elements.

Someone might be searching for this one day.

Dynamic arrays may have an arbitrary (and unlimited) number of elements, until you run out of memory.

Check the permission not only to the file but also to the parent folder.

Check the job log to determine what values were actually supplied in these cases.

Examine the SQL that was sent to Oracle, find where the missing right parenthesis ought to go, and supply it.

Actually, you will find that documented in the DataStage BASIC manual, in the section about COMMON variables.

There are known unknowns, and there are unknown unknowns...

I did get one wrong in the certification exam, if that's any consolation.

Welcome aboard.

This site is equipped with a Search facility, that you can use to locate previous postings of this question. You're not the first to encounter this. Start by searching for the specific error text, stripped of site-specific information.

Remember Thermopylae!

This forum is for making suggestions as to the format and running of the DSXchange web site. Please post your question in the appropriate forum (server or parallel) so that we gain more knowledge as to the operating system, version of DataStage, and so on. You might also like to be more specific abo...

The error message is
/home1/dsadm/Ascential/DataStage/PXEngine/etc/standalone.sh: not found.

Please verify that this file exists and is executable.

Define "performance". If you mean will there be more presentations of "Hamlet on Ice", then I doubt it.

Locks, almost certainly. Get your DBA to verify whether the one process is locking the other out.