DSXchange

There are several ways to solve this. Do you have any ideas about how you wish to proceed? For example, is the comparison to be performed row by row?

The following functions are available for the Modify stage. trimc(string) trimc(string, ch) trimc(string, ch, option) trim_trailing(string) trim_leading(string) strip_whitespace(string) compact_whitespace(string) trim_leading_trailing(string) I think that the last of these might be close to what you...

Have you taken a training class such as DX434 DataStage Essentials Enterprise Edition ? There you would have learned about the orchestra metaphor used by Orchestrate; the conductor, section leader and player processes. Search the forum for error code -14, which suggests that the server is overloaded...

Please post the result of the command

string_trim[character,direction,justify](string)

or

trim_leading_trailing(string)

See page 13-7 of Orchestrate Operators manual for full details.

Delete then add is fast, cheap and probably error-free (provided you get the pathname correct). Copy the pathname before deleting the project, paste it when re-creating.

With a hashed file that size, do the initial population in a separate job, WITH write cache enabled. Be amazed!

I don't think it's possible to use DS functions in before-SQL. A reference to a DS macro (surrounded by "#" characters) may be possible, but I'd be dubious about that too.

You might also try using Write Cache, having allowed the maximum possible cache size (999MB).

Where do you find this script? DataStage only generates SELECT statements where there is a stage that both supports SQL and has an output link. Unless "Source File" in your design is not a file but a table, I can't envisage this job generating this SELECT statement. The only possibility is that some...

There's a formatting tool in the server routines editor.

It's correct. Logic is left to right where there are no parentheses. So the two AND operators will have been evaluated before it gets to the OR operator. (Optimized it may not even get to the OR operator if one of the preceding conditions is not true.)

Ask your support provider to provide the "OEM 75" (Orchestrate) manuals. They should be able to get them from IBM in PDF format. They are handed out on all IBM training classes.

That approach would probably also work in an External Filter stage.