DSXchange

If the problem is fixed please mark the thread as Resolved.

And post a little more information - what do you mean by "created by Ascential"? That company ceased to exist in 2005.

Modify stage, Transformer stage, External Filter stage, Build stage, to name a few. What will you do if the 64-bit quantity is too large to fit into a 32-bit field? Do you have a plan/design for this? Probably the Transformer stage is best in this case, because you can include IF tests, for example ...

What would you do with the output of "multiple SELECT statements" in a Close command anyway?

You could always build them into a stored procedure and invoke that. Might even make redirecting/capturing their output easier.

Just don't expect it to work after you upgrade to version 8.0 or later.

If you must run it from the Command window, use this form:

And even that requires that PATH is set so as to include the parent directory of the dsjob.exe file (that is, the bin directory in the DataStage Engine folder).

Please advise what your Record Delimiter and Final Delimiter properties are set to in the Sequential File stage (or if they are not used, tell us that and report whether the Record Length property is being used and with what setting). Do you happen to know the provenance of this file? That is, where...

Please mark the thread as Resolved. For future searchers, please consult the manual before using BitXOR() function; it expects two decimal integer arguments. It performs XOR on each of the corresponding pairs of bits in these integers. Depending on what you're doing you may need to convert binary, ...

Why? That is, why did you "come up with a requirement"? Do you mean to read the content of an email from a text file, or do you mean to try to winkle the email directly out of OutLook or Lotus Notes? The first is do-able, the second would be really tough (particularly since you've indicated UNIX for...

Is your DataStage client running on Windows XP sp2 and, if so, do you have the DataStage xpsp2 patch installed? Triggers do not magically propagate - if you are creating new job activities, you must put in your own triggers. You might try copy/paste to try to capture the activities supplied by Peopl...

Wave number is a number used internally by DataStage to identify a unique instance of a job run. You don't need to interact with it. Stage status is the status of an active stage (for example starting, waiting, running, finished), as reported in the Monitor view in Director. As far as I am aware the...

Maybe it's a typo, but I can't see any way 1.999 would be a result if 1.997 is. Anyway, there are lots of ways to avoid rounding; for example by specifying "T" in the Fmt() function. It really depends, as Arnd says, on where you are (not) doing the rounding. To do rounding is DataStage's default beh...

Sage advice. Write a specification of how matches are to be identified and only then worry about a tool. It may be, for example, that QualityStage is a better tool. Yes, DataStage can do pattern matching, but what does it have to match? QualityStage can do probabilistic matching, rather than determi...

DataStage architecture is client/server when designing. There is no web-based client with the product from the vendor, though Kim Duke does have some browser-based functionality available. You can get Director client on a PDA through to version 7.5 but I believe that's been removed from the suite at...

What it puts is a default. Change it if you want it different.

Does the source file perhaps come from a Windows system, so that there's a two character line terminator rather than the single character line terminator expected by the "UNIX" record delimiter property setting?