DSXchange

Integer -MDM_COMPANY asc, Integer -MDM_ITEM_NUMBER asc, Decimal 10,6 LineTransactionId dsc It works fine with fewer transactions. I am parsing a folder of xml files I then send them to a sort stage to group them so that I can remove duplicate LineTransactionId keeping the larger LineTransactionId an...

(jb_PARSE_ITEM..ss_ITEM_SORT: Arithmetic overflow) Arithmetic overflow is the error I am recieving from the job when trying to sort 219 rows

Go into your job log, right click on the warning message, and choose "add rule to message handler". A local message handler is specific to this job. You can also create named message handlers that y ... Thanks, that suppresses the warning just fine, though that is a jerry rig. The root pr...

This is an alert message. Negative int64 values will not be correctly represented as uint64. You can force the data type to be int64 everywhere, or demote this warning to informational - because of ... I have tried it defining maxkey as an integer, I get the same warning. What would I have to set t...

Surrogate_Key_Generator: When checking operator: When binding input interface field "MaxKey" to field "MaxKey": Implicit conversion from source type "int64" to result type "uint64": Possible range limitation. this is my sql in an ODBC stage ===================...

Currently I am working at a client and some contractors there are telling me that datastage server will be going away and IBM will no longer support it. I am hoping someone from IBM answers this. One client just recently purchased server and are beginning their ware house development. Could someone ...