DSXchange

Normally using all uppercase is considered shouting, and "u" is not a valid English contraction for the word "you". Could you explain what you mean by incremental aggregation with an example? Chances are good that DataStage can somehow do this, but I am not quite sure what you me...

Aakash, I would be surprised if the 8.1 engine were to have been re-written for 64 bit code. If you mean whether or not the hashed files are 64 bit by default then the answer is "no", but you could also check the "uvconfig" file to confirm that. You can check the binaries and lib...

This is a classic example of the use of stage variables and works in both Server and PX jobs. If you have a stage var "LastValue = In.ColumnName" then any stage var defined before that assignment will have the value from the last value. In PX jobs you need to take the partitioning into acc...

So how do you declare this field in your CFF stage? If it is a DB2 query, then chances are high that the data is not transferred as binary, but as EBCDIC text data. You could check this with a binary display tool and see if you are getting actual binary data or text data on the UNIX machine.

Kumar,

do not take us too seriously - we are just playing with the use of the word "like" in English.

Your error was "ABC", not "like ABC". Just go ahead and post the full details and you will certainly get assistance.

0xE9 in UTF-8 is the French e-egu character and that is present in Unicode, so the error is odd. You stated that you are sourcing from 8859-1 but that isn't what the error message states. Are you explicitly reading 8859-1?

In what stage are you doing a "SELECT" and does this not return non-binary display values which can then be used by DataStage?

Craig - the solution is like 42.

I dobn't see the connection between increasing the T30FILE setting and job compilation but it might be worth going back to the original value and seeing if the job now compiles.

Have you tried "force compile"?

Yes, binary fields can be signed in DataStage. But you need to know which type of binary you are using and also which type of negative representation. This is easiest with the COBOL type fields, but can also be done with other binary representations.

So, what sort of a binary field do you have?

The official answer is "no", as IBM won't support any platforms not on their list. But it might work, and shouldn't take too long to find out.

Did you copy all of the KeyMgtGetNextValue code into your other routine and then make changes, or do you call the routine from yours? A value of "-1" usually means some sort of an error, in this case, without seeing the actual code, I would guess that it is because the file could not be op...

Would not do the trick?

Trollbot?

A sequence job is a server job. I am not sure what problem you are now seeing - a runtime issue or a reset issue?