DSXchange

Welcome aboard! :D You need to eliminate one thing at a time. To check whether the dsprc "daemon" is running, open Control Panel, open Services (under Administrative Tools) and look for the DataStage RPC service. If it is not running, you can try to start it manually, provided that you're logged in ...

Repository indexes can become corrupted (out of date) if any updating process is abnormally terminated. It is possible to verify whether the indexes need rebuilding without actually doing it, using the LIST.INDEX command. It would be useful to have this on the DS.TOOLS menu. LIST.INDEX DS_DATATYPES ...

Are all your DataStage Repository indexes intact?
Do you have appropriate permissions to all the Repository tables?

"cast" means an attempt to change a data type.

Somewhere in your design, either explicitly or implicitly, you are trying to perform a data type conversion but the source data are not amenable, for example trying to load "FR" into an integer column.

Try Iconv with "MX0C" (a zero, not a letter).

The "device" here is the disk, in particular the disk on which the folder referred to in your UVTEMP configuration parameter exists. By default, on Windows, this is the DataStage Engine folder, the only directory that the installation process can be sure exists. If you want to change UVTEMP, edit th...

The internal format is a negative number for dates prior to the base date. So, if the internal format of 2004-11-09 is 104314 then your base date is 104314 days prior to that. OCONV(ICONV('2004-11-09','DYMD') - 104314, 'D-YMD[4,2,2]') returns 1719-04-04, which is the base date for th...

Y10K alert...

Derivations are simple compared to generating reports containing decoded parameter values!

See other post on this identical topic.

I have used it, though the trick is that you have to type it in; you can not select previous reference inputs from the "Input Column" dialog. I guess this was too hard to integrate with changeable execution order of reference input links. In turn this means that you have to be careful with casing an...

Use a job sequence to run the jobs.

In the job that generates the value, have it also place the value in that job's user status area.

In the next job, use Job2.UserStatus$ to retrieve the previous job's user status area value when loading the parameter value.

You need to determine the base date on which your Julian dates are based. Typical base dates are 01/01/1900 and 01/01/1970. DataStage uses a base date of 31/12/1967, so you need to determine the offset between your base date and DataStage's; this becomes the constant in your calculation. Date DataSt...

Error 1 is a metadata mismatch; there are more columns in the row than are specified in your column definitions; or perhaps an unaccounted-for delimiter character. Error 2 is caused by there being a path through your Routine code that does not assign a value to the variable named InData before attem...

Documentation for dsjob is to be found in the Server Job Developer's Guide and in the Parallel Job Developer's Guide. It's the same text in each; you only need to read one.