DSXchange

More efficient is the Convert function. Convert(Char(25), "", String) However, the Change function should have worked, if the character really is Ctrl-Y. What you may actually be seeing is the non-first character of a multi-byte character. In that case, it's not Char(25) or...

You're right, you can't. But, if you're in the routine activity that is the final piece of the sequence, the time "now" should be close enough.

Are you using exactly the same user name that you used to install MetaStage? If not, try that one.

Mention to your DBA that you're wanting to execute a query that includes a correlated subquery to a 830000 row table and another correlated subquery to a 400000 row table, then run for your life! Seriously, this is a tough query for a database server. It could probably be made much more efficient if...

The routine is called once per row. You seem to have assumed it is called once per job invocation. The upshot is that you don't need either loop. A simple test is all you need to implement your logic. Indeed, you don't need a routine at all; the counter could be accumulated in a stage variable, test...

That set of error messages results from not wrapping the message in quotes.

The easiest way to remember the architecture is this simple statement.

DataStage Engine is the client to the database servers.

When DataStage runs a job, it is just another client application as far as your database servers (Sybase and MS SQL Server) are concerned.

Having uvodbc.config in the $DSHOME directory and not in the projects is a perfectly valid approach, though you lost the ability to have different sets of DSNs per project. When a BCI call to connect to a DSN is made, DataStage searches first in the project directory for uvodbc.config , next in the ...

You can add a Routine Activity and modify your routine slightly (copy it to a transform function) so it's callable by that means. Make the Routine Activity the last activity in the Sequence.

I use the same style as Roy. Each Job Activity can have three triggers - finished OK, finished with warnings and failed. The latter two go to an "Any" sequencer that triggers a Routine Activity, that invokes UtilityWarningToLog and logs a message indicating that some problem has occurred, and identi...

A counter will consume CPU cycles.

Prefer SLEEP or NAP.

If you really need an interruptable routine, create a loop that includes a SLEEP or NAP statement.

SLEEP is in seconds (or until a particular time), NAP is in milliseconds.

81011 means "unknown host".

Check that your host name (or IP address) is correctly entered and, as the others have suggested, reachable.

The DataStage RPC daemon listens on port number 31538; check that this port is not blocked by the firewall.

No, I can't explain, unless you explain "inconsistent". What results did you expect to get and with what values, and what results did you get? Otherwise it's like asking me to tell you, from the other side of the world, why your car won't go. It might be nulls, as Ken suggested. Otherwise, post some...

A perfectly tuned hashed file will be very scalable based on the number of rows processed in the main stream. Remember that the hashed file is for lookups. For example, the hashed file might only have ten rows in it (for example ten different customer type codes). You could perform millions of looku...

Don't quote the names of the columns. Column names must be qualified with their link names. Use the expression editor (right mouse click) to choose Input column names. This avoids typing errors. You should end up with something like the following. If InLink.Col1 = InLink.Col2 And InLink.Col5 = InLin...