DSXchange

Do you actually have WebSphere Transformation Extender? If not, the WTX map stage will be of no use at all to you.

I would seriously think about DataStage 8.5 in this case, for which there's a set of XML tools that can handle arbitrarily large XML files very efficiently.

OK, then I'll concur with Craig, because DataStage expects the database server (or ODBC driver) to be silent on request but yours is returning informational content. So DataStage alerts you to the fact that unexpected output has been received.

Use a Column Generator stage to generate a constant (cycle with single value) and group by that.

For absolutely best performance having the DataStage engine co-resident with the database server is the way to go. But performance is usually satisfactory where they are on different machines connected by a very high speed network.

Clustering yes, HA no. It's first supported in 8.5, at least for the services and repository tiers.

Of course, 8.1 will run on systems where HA is implemented, but does not have any failover capability.

I don't see any value in that recordset that could be converted to smalldatetime.

You need to be confident that you have NULL coming in. "" is not the same as null. Is the source a sequential file? If so, how is NULL mapped?

Did you re-boot after installation?

The DSParams routine code is not affecting the address, unless the entry in the parameter file itself is incorrect. Can you please check the entry in the parameter file and in tnsnames.ora for that particular system?

Probably not, except to the extent that the DSParams routine might not be well-written. Can you post the code of DSParams routine?

Search DSXchange for "vertical pivot", for this is what you are trying to accomplish.

DELETE is a slow operation, because it's transactional and, if row by row, as in your design, has first to execute a WHERE clause to establish the rows to delete. An index on the column(s) in the WHERE clause will help. How is your transaction size (record count) set? You can also run on more than o...

First off, don't shout (all capitals is "shouting" and bad netiquette).

You can program 100 jobs by adding 100 Job activities to the sequence.

You will then grind your server into dust trying to execute them. You have been warned.

Funnel DOES support two input links. I use it frequently. Please justify your assertion to the contrary.

Some intermittent database or network problem, then?