DSXchange

Why assume that it is DataStage? DataStage reports the number of records it sends to the ODBC driver. It may be the ODBC driver, it may be the interface into the AS/400 environment, it may be in the tables themselves where the problem occurs.

Or, putting it another way, perhaps the two values have different numbers of trailing space characters.

The stage that terminated was IDENT1, an invisible transformer stage inserted by the job compiler because you have a link joining two passive stages in your design. I suspect that the cause of your problem is not in the hashed file stage at all. Reset the job (not recompile, but reset) and tell us i...

Can you insert/update such a value in the table manually?

Please mark this thread as Resolved using the green button at the top of the page.

My main reason for keeping them on separate file systems is that if you lose one you don't lose the other, and may therefore be able to reconstruct at least the structure (maybe even restore from backups). My reason for keeping the control files in a subdirectory in the project directory is mainly &...

Guruji, the original post specified a Lookup stage. In a Lookup stage sorting is not required.

Why do you think that? Pipeline parallelism is automatically implemented in parallel jobs through the mechanisms of virtual Data Sets (on each link) and transport buffers (used primarily for repartitioning). Of course, internally, every stage processes record by record, but they are consuming and pr...

my requirement is to abort a job when data in a link has reached some threshold. thershold means the percentage of data which is dynamic. Why would you want to do this? Are these rejected records? Do you want to do this as the job is running, or is it OK to check in, say, an after-job subroutine on...

u can use a job control to read the records in the link once it goes beyond the perticular level u can abort it, The second person personal pronoun in English is spelled "you", not "u". U is the name of one of our posters. Please strive for a professional standard of written Eng...

I can only surmise that the hash keys were not identically specified and/or were not the same as (and incorporating all columns of) the reference key.

I can only surmise that the hash keys were not identically specified and/or were not the same as the reference key.

Which particular configuration file? There are at least four.

Is it being picked up in the SELECT clause? Then maybe you can use the column alias name in the WHERE clause. (I haven't tried this.) SELECT INSTANCE, DTM, MODIFIER, REASON,CAST(CAST(CURRENT_DATE -1 AS VARCHAR(10)) || ' ' || CAST(CURRENT_TIME AS VARCHAR(10)) AS VARCHAR(20)) AS DT FROM UNNEST DS_AUDI...

Clearly the installer is not identifying SP2 as being later than SP1. You need to contact your support provider and they need to contact IBM on this one - it appears to be a bug in the installer. Maybe you could change Windows to English, do the installation, then change Windows back to Polish. But ...