DSXchange

Any way that works. I would do it in a job control routine, because that's what I'm familiar and comfortable with. But it could be done completely graphically - though you would need a job sequence.

You could also investigate EtlStats from Kim Duke's website

No. But you will need DB2 client software installed (and configured) co-resident with DataStage.

I do not intend to type out the Installation and Configuration Guide here.

WHO advised and, more importantly, for what reason? After-job subroutines are a very useful part of the product. I put an annotation on the canvas to alert future developers to the use of before/after subroutines, so that they (the developers) are not caught unawares when the subroutine does whateve...

Two choices. One is to purchase Enterprise MVS edition which will write COBOL programs you can run on the mainframe to extract the data (and can then FTP the text file to your DataStage server). The other is to have a person write the same COBOL extract program and create a text file. You can then s...

Why are you asking Chulett if U can reply? U hasn't posted here for some months.

Exactly the same.
The file is %WINNT_ROOT%\System32\drivers\etc\services
(but you probably don't have a grep command; just inspect the file).

Try specifying a size for the VarChar, even if it's obscenely large. The "trailing null" about which Oracle is complaining is the string-terminator character 0x00, which is how strings are terminated in C languages. An unbounded VarChar may well be missing this character, and Oracle just doesn't lik...

Are they being created (owned) by DataStage processes? DataStage inherently does not use any RFC mechanism; however in certain circumstances - such as extracting from SAP R/3 - then RFC may be the mechanism involved. Take a look in one or two of them and see what you can discern.

You can always include a sorting clause on the Selection tab when reading from a Hashed File stage. Syntax is that of the RetrieVe query language. BY field (for ascending order) BY.DSND field (for descending order) You need one clause for each sorted field. For example: BY REGION BY COUNTY BY.DSND S...

It's still highly variable, but always in posting.php

PWD is an operating system environment variable.

Search the forum for more information - you are not the first to post this issue.

How many entries (total) are in the log for the most recent run? If the number is not too large, please print them to file and post here. Then we will see whether any of them might have caused the status to be aborted.

What is it that makes such restrictions "best" practices? Who said?

You do NOT want to remove the "-" character.

All of those values are perfectly valid (signed) integers.

Removing the "-" characters would be a loss of information.

If you must, use an Abs() function.

Yes, but that stage would have to be a Modify or Transformer stage. If the latter, then you may as well take the outputs from it directly.