DSXchange

I've seen this when loading data into a partitioned table (with partitioned indexes) and using maintenance mode on the indexes. When using the default parallel method, as you've seen, we would get the maximum sessions error. Like you, setting the stage to operate in sequential mode solved the proble...

rumu, read Ray's comment again.

He is saying to try it in SQL Server as a user-defined SQL statement. If it works there, then DataStage won't have any problem doing the same thing.

I have used TimestampFromSecondsSince(-86400, X) to do this without having to deconstruct/reconstruct anything. It has worked well for me.

I've seen the same problem when doing loads into Oracle. The "broken pipe" message usually comes up when Oracle's SQL*Loader has problems doing its work (a full tablespace, for example). I would imagine that the DB2 equivalent is having similar problem during the load in your case. To trou...

On the "Properties" tab, click on the "Connection" folder icon. In the lower right of the dialog is the "Available properties to add" section. Click on the "Remote Server" property to add that to the connection options. The value you enter in the top right of ...

Whenever you perform any sort of function (like NVL or MAX) in a SELECT statement, Oracle does not seem to preserve the datatype of the underlying column. Or, at least it doesn't seem to correctly communicate it back to DataStage as part of the metadata sent with the query results. As mentioned, jus...

I have the DataStage client running in a Windows XP virtual machine under VMWare Fusion on Mac OS X and it works great! I doubt that is a supported combination, either :D

The DS client (I am using v7.5.1A) doesn't work well with Vista (Business edition, RTM version). In particular, if you use the ellipsis button to try to choose things like job parameters or input columns in an expression box, the choice list displays "behind" the client window with no way ...