DSXchange

We are currently wrapping up our evaluation of DS, which ran on one of our available window servers. We are looking to do our permanent install of DS on an AIX 8 way powerhouse. Does anybody know of any issues of running DS on an AIX platform VS a Sun Solaris Unix.

Thanks Ray, I think I already knew this, but I was being optimistic at the least that there may be a global solution to this problem. You are 100% correct the DW has to be clean unfortunately they did not take that in consideration when they built the Legacy system I am extracting this data from. Bu...

What a wonderful world it would be if it was that simple. Unfortunately that is not even a remote possiblility. Thanks for the reply.

Thanks for the Welcome and the advice. :D I did use the num constraint at first and it did work, as long as you know what coulmn is suspect. My problem is that there can be dirty data in any numeric coulmn for any of the tables that we are loading from our Legacy system, no way to know ahead of time...

Used Constraint REJECTEDCODE <> DSE.NOERROR the results was the first rec was written to the reject_tbl. The RECECTEDCODE Constraint is in 2nd output link, testing link 1 for non-numeric data. Using REJECTEDCODE = DSE.NOERROR all records written to both tables. Can not find any documentation to assi...