DSXchange

In the Transformer stage call a "rule dispatcher" routine. This receives the name of a rule routine as well as the value to be checked (or a dynamic array if more than one). It uses "indirect call" to invoke the actual rule routine. RoutineName = "DSU." : Arg1 ValueToProcess = Arg2 Call @R...

You need to run a Character Concatenate investigation on the unhandled pattern (C-mask), unhandled data (X-mask) and anything else you think would assist (X-mask). You do this after the standardization has been run.

I doubt that you will get Line 2 or Line 3 very easily. Take a look at the standardized field names (street number, street directional, street name, etc.) and work out what you want in the various lines. DataStage can then read the file and direct the appropriate pieces into the correct places in a ...

I suspect the problem is more likely whether the ODBC DSN for the test database was set up on the server.

Check everything. How large are the VarChar specifications? Are there more characters in the line than the total of these. I am not sure what you mean by \v when describing the delimiter nor, really, \v|\n. Are you using Delimiter or Delimiter String properties? What (exact) values are you giving th...

In version 8 things change a little, in that you can have just an MQ Series client co-resident with the DataStage server.

That requirement was not stated in your original question.

An Exception Handler has a couple of activity variables that can identify what went wrong and where. You can use that as a starting point to drill down (in a routine, probably) until you find the underlying cause.

Yes, using the techniques that have been discussed in this thread. But you will need some mechanism, whether it be a job sequence, a shell script or anything else, to collect the value modified by Job1 and feed it as a parameter value before requesting a run of Job2.

The warning is generated because you need a string[max=20] or larger. There are at most 19 digits in an int64 but there is also a sign character that DataStage expects to put into the string - this is either " " or "-" by default.

Have you really got dates, or strings? If you've really got dates, why are you specifying a format string, and where?
If you have strings, check your data for any date that does not conform to your specified format (for example, a single digit day or month number).

... or has it open in Designer. It might even be you! Check for minimized windows.

Did you leave the "#" characters off DirPath anywhere?

Delimited file with too many delimiters on that row?

Ok. I stated it as a general rule. But by looking at your message I think thats not the case. Can 2 jobs share same RT_CONFIG file? Is this file any way related to hash partitioning? Thanks The configuration file all of the rest of us have been talking about is the one whose pathname is specified b...

Why would two jobs not have the same configuration file? Are you stating this as a general principle, or as a specific case?