DSXchange

Shared Container is irrelevant. It will make no different if it's a parallel Shared Container, and a server Shared Container cannot contain a BASIC Transformer stage. The BASIC Transformer stage is not the same as the server Transformer stage; the latter accepts reference input links, the former doe...

Your job is only running on one node (for whatever reason) so that your expectation to see row counts for more than one node is unreasonable.

Check your metadata. What is the data type of the first column? What is the field delimiter character?

Then cause them both (all) to have the same nullability - either both (all) nullable or both (all) not nullable.

My answer, had you been able to read it all, IS in DataStage.

Premium membership is not expensive, at less than 30c (Rs12) per day, and well worth the investment.

Or even two adjacent single quotes?

You could read the file as a single VarChar per line and process it with the pxEreplace() function posted here some time ago.

Please indicate HOW this problem was resolved.

(My guess is a switch from Hash Table to Sort aggregation method.)

True in DB2, true in dBase, true in SQL Server, true in Red Brick. As far as I am aware, also true in Sybase and Informix IDS. Oracle always tries to be different.

Please mark this thread as Resolved using green button at top.

This would be quite simple as a routine. It needs one input argument (the string to be parsed) and will return a delimited string containing the values found. FUNCTION GetValues(aTheString) If UnAssigned(aTheString) Or IsNull(aTheString) Then Ans = @NULL End Else TheString = UpCase(aTheString) ; * h...

A correctly-programmed Transformer stage (after the Sort stage) WILL work to drop a column.

The error message is complaining about CURRVALUE (not CURRVAL) - maybe you've mistyped something somewhere?

Take a look at the metadata on both sides of the MatchAddress stage.

A flag never really needs to be bigger than a TinyInt (uint8).

Server DOES support this kind of functionality where the reference input is ODBC or UniVerse. Find the property called "allow multiple row return" in the Transformer stage properties and enable it.

Windows 7 is supported for the client, though I suspect that Home edition is not.

The other tiers are definitely not supported on Windows 7. As you note, they won't even install.