DSXchange

My priority is always to those that pay me. Misspelling my name and using SMS-style abbreviations reduces my desire to help. If you were paying for my time you would be in a better position to demand help from me personally. I post on the forum as and when I can, and I am probably in a different tim...

Is the PATH environment variable correctly set in the dsenv script for DataStage processes?

Actually you don't need PXEngine/lib for server jobs.

Please post your configuration file so that we can see how node1 is defined. Also post the first two messages from the job log, one showing the job parameter values and the other showing environment variable values. Without this information your question is too general to be able to be answered othe...

The zeroes are displayed by View Data so that you can verify that precision and scale are being handled properly. You can do regular comparisons (such as InLink.MyColumn = 0.0) to test for zero. You ought not to need the Trim() functions at all.

Set up a rejects link from the SQL Server Enterprise stage. This will capture any row rejected by the database. You can then inspect the data and make an informed decision as to the cause of the problem.

That's not the only scenario. Modify ---> Peek will also not report a row count to the Designer.

Have you provided any friendly feedback so that they can try to get it right? These guys are as new to what we do as you once were; if we can be constructive in our feedback we can make friends and maybe even influence people.

Sometimes you have to help them to help you.

Red Brick still is set up to install off 1.44MB floppy disks!

Has anyone successfuly installed MetaStage 7.5 with Oracle 10g ?

If so, was it a "straight" installation, or did you need to employ some kind of workaround? The site I'm at is new - it does not have Oracle 9 client software.

It could be that the first job is still flushing buffers to disk, which is why the delay is efficacious. Interpose an Execute Command activity or Routine activity that sleeps for the desired interval.

Did you import the stored procedure definition into your project and Load it (as a "table definition") into your job design? Have you tried just sending the three input values, and receiving back the two output values?

Under certain circumstances other links also are not updated, for example the output link from a Modify stage. The display of "performance statistics" in Designer was only ever a marketing gimmick; prefer the Director client "stage finishing" messages, or Monitor, to get row counts (if not the API)....

There are some null-handling properties in the Aggregator stage that give you some alternative strategies. Investigate these.

You need to make sure that the requisite libraries are installed on the machine on which you want to execute the dsjob command and that they are findable via the shared library search list (the LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH environment variable, depending on exactly which UNIX platform you ...