DSXchange

What, precisely, do you mean by "rejected" rows? A join by definition does not generated reject rows. It simply generates the result of the join.

You have been misled by your job design. The message refers to IDENT8, which is an invisible Transformer stage added by the compiler because your design directly links two passive stages. It may be, for example, that the failure occurred because Oracle was temporarily unavailable, perhaps due to bac...

No, it does take a long time. Critical is that you manage their expectations; they are NOT going to get this at the end of a single sleepless weekend from you. Multiple sleepless weekends fall into the occupational health and safety risk categories (primarily) and data inaccuracy category (secondari...

In particular what are you doing around line 60? Improper data type can stem from a number of causes, the most common being an attempt to use a variable as a file variable when that variable is not, in fact, a file variable, perhaps because the file was not opened, perhaps because it's been closed i...

And if that's the case, IBM will own the code.

Try SH -c "od -x hashedfile/DATA.30 | head -1" as your command. Examine the first four bytes. If they show acef 010c (or 010c acef on an Intel CPU), then it is a 32-bit hashed file. If they show acef 020c (or 020c acef on an Intel CPU), then it is a 64-bit hashed file. For static hashed fi...

Any BASIC can only execute where the BASIC run machine is. Before-job and after-job subroutines execute in the conductor process (and therefore on the conductor node) which, by default at least, is where the DataStage server is, so you get away with it. If you start fiddling around with the configur...

There is no such thing as the "parallel reader" stage. I presume that you are using a Sequential File stage. If your data have no line terminators then each row must be of the same length or of a known length described in the data. Otherwise there is no way that any utility can accurately read the d...

I want to create a user to test job, who can not edit the job but only complie and run the job. I don't konw how to create the group and the role. I don't find any way to do that in Administrator. Does any one can help me? Thans a lot. What you seek is not possible. To be able to compile, a user mu...

There are NO job log files in DataStage. DataStage stores log information in database tables in the Repository. There is a separate table for each base job. The name of the table is RT_LOGnnn where nnn is the job number of the particular base job (obtained from the DS_JOBS table). All invocations of...

Welcome aboard. :D

If the data type is numeric, then the comparison operators suggested by thumsup9 will be appropriate.

If the data are of string data type, then you could use a function such as Left() or Index() to determine whether your sign character appears.

If you choose About from the Help menu in any DataStage client it also reports the version of the server to which it is connected.

It's just how it works - an engineering solution to the possibility of, and need to prevent - integer overflow from occurring.

The Data Browser puts leading and trailing zeroes on Decimal data so that you can be user that precision and scale are being handled correctly. When stored - for example in a database table - the leading and trailing zeroes are not significant. It is only an issue if you want to write to text files....

Have you searched the forum for "dbx not found"? You might find it instructive to do so.