I was also getting the following warning, while using pivotPX to do an horizontal pivot. When we changed to pivotenterprise, there was no warning for the same columns.nagarjuna wrote:Hi Craig ,
Thank you very much for confirming the error in pivot stage .
PVT_splitAgents,0: Invalid character(s) ([xA9]) found converting string (code point(s): IBM Confidential, OCO Source Materials, [xA9] Copyright IBM Corp. 2006. All Rights R...) from codepage UTF-8 to Unicode, substituting.
We were pivoting 10 decimal(15,2) columns into one column. Also we were pivoting 10 varchar(unicode) columns into one column. We were using NLS (UTF-8) throughout.
Could you please let me know, the basic difference between pivotPX and pivotenterprise. Why was the warning arising in pivotPX and why not in enterprise. Is there anyspecific changes done in pivot enterprise to handle cases. Except for the graphical usability and index number creation, is there any more changes added in enterprise internally.