DSXchange

I guess you are asking us how long it takes, based on experience. Do you know which patches you'll need to install after installing FP1? Have you searched for these on IBM Fix Central?

A better approach would be not to move the files to the archive directory until they have been processed. Given what you have, you can still use cat in the Filter command - two cat commands, in fact:

The fact there's an Oracle error code suggests that there's an Oracle issue. Did you try CAST .. AS VARCHAR2 instead of VARCHAR ? That said, your substring syntax is incorrect; you need a comma rather than a colon. string[1,1999] returns the first 1999 characters from string. You could also specify ...

Anything in the logs that might indicate what the invalid character might be?

Assuming they are moved from the directory once processed, I'd use cat as the filter command.

Why ASAP? We don't do "urgent". DSXchange is an all volunteer forum whose members post if, as and when they can. Search DSXchange for examples of how to pad strings and of how to convert from fixed-length string to variable-length string. However you accomplish it, your values (with traili...

As a general rule, if the join is totally supported by indexes in the database then performing the join in the database will be more efficient than in DataStage because it will be performed in the indexes. Beyond that the factors mentioned in others' posts will come into play. Another general rule i...

Your configuration file might have the pathname of scratchdisk directory misspelled. This is one example of something that could cause this symptom.

If you're running 8.1 you are running 32-bit version.

Are we talking about CDC here (capturing of changed records from databases) or change detection (that is, Change Capture, Difference or Compare stage types)?

All of these solutions require some sys admin intervention. For example FTP must be enabled or Samba must be configured. There is no solution in my experience that does not involve some kind of sys admin action to enable.

In your copious free time (!) it would be grand if you could expand on that with simple examples, possibly in a "how to" blog.

Choose any character (for example @FM) that will never appear in data, and then use Ereplace() function to effect the substitution.

Do you have the "auto backup" selected in the Hashed File stage? If so, resetting includes reinstating the hashed file to its state prior to the job run. This can take some time if the hashed file is large.

plink.

Part of PuTTY. Command line connection tool somewhat like ssh.