DSXchange

Stop dealing with American vendors who think that "#" (Shift-3) is the pound symbol.

Then take Rob's advice.

Join stage does support more than two inputs (all must have the same join key). Execution is pairwise, as it is in most database servers.

Parameters should only be entered into Connector stage types by clicking the multi-coloured icon.

The routines that Craig mentioned are here - however there isn't a TimestampDifference in that set. This can be done with a simple expression (it only looks complex). That expression can be used in a sequence or in server job components or even in a BASIC Transformer stage. (Iconv(Field(Timestamp2, ...

That certainly looks like Oracle 10g is not on the list.
You could always stand up a Microsoft SQL Server instance at little cost.

There's a link on the DSXchange Home page to a place where you can get "this" (premium membership).

Cease killing processes or issuing Stop requests to jobs.

Probably the firewall. One of the port numbers that needs to be open (most likely 31538) may not be.

Second possibility is that the dsrpcd process is not running. Confirm whether or not it's listening using netstat commands.

Your string contains more than 14 digits. A precision of 14 in your metadata will cause this alert to be generated.

The stage defaults to the same amount of memory as the inlink sort. The difference is that you can change it in the stage. The global memory for tsort operators is set by environment variable APT_TSORT_STRESS_BLOCKSIZE Yes, you can demand more memory than the system can provide. You can even do this...

Does your DataStage user use the same default schema name as does the TOAD user? Maybe you need a fully qualified table name.

You don't need a .dsx, at least until IBM eschews use of the local repository for design-time information. It's all there in DS_JOBOBJECTS (and can be verified against RT_CONFIGnnn if necessary).

Can't we read the datasets which are ftp'd from one environment to other environment using Orchadmin command..? In general no. The descriptor file contains information about the hostname, the configuration and the segment file locations from the original system. These will not be the same on the ta...

Do you have write permission to the parent directory of the Data Set descriptor file? You need rwx permission to a parent directory in order to be able to delete any of its contained objects.

"problem"? Be more specific. Does your new system have a supported C++ compiler properly installed and configured?