DSXchange

Are you 100% certain that you have precision (length) and scale in the correct columns? Can you post the record schema that you are using? DataStage seems to believe you are using precision 2, scale 15.

Why are you replicating rumu's work?

WHY can't you count the number of rows in an empty file? You can count the number of rows in an empty table. There's nothing different.

The other way, of course, is to code it yourself in a Job Control routine. This is necessary if you're running a version earlier than 5 (where job sequences were introduced). If you're not, why re-invent the wheel?

Hash jobs should only be run in Amsterdam, where that kind of thing is legal.

The code is largely irrelevant. DataStage arithmetic (other than string math) will not handle numbers the size of 100!, much less 800! How many digits are there in 800! rumu? This is not a DataStage limitation; really any programming language, using standard data types, would have the same issue. An...

OF COURSE it takes a long time. It has to process 4GB of data!

Do you really have DataStage version 8.0 on Windows-NT, sachin1 ?

Can you please explain how you installed the same? I find that I am unable even to install version 7.5 on Windows-NT.

The same way you do with any character set. All the relevant DataStage NLS maps (for example GB2312 for Chinese, Shift-JIS for Japanese) include the CJK characters. You will probably need to create your own classification tables and, perhaps, Pattern Action Language scripts. These are text files - y...

Check the data types, in particular the string length (or max length) and the decimal precision and scale. Are these the same in both environments?

Not necessarily. For example it might be vmdsapiJPN.dll if you're redistributing in Japan.

What, just cat? Not cat filename perhaps?

Maybe you need DIGITS(CommandActivity.$CommandOutput) and/or to strip field marks from the command output.

The point is that it doesn't matter - in a constraint expression - whether anything is removed - the result does not propagate. The expression will return True if there is any non-space character in the string, and False otherwise.

Before/after subroutines in parallel jobs are exactly the same as in server jobs. They are written in DataStage BASIC.

Enrolling in a Programming with DataStage BASIC class might be beneficial.