Trying to retrieve data from as400 using linked server via IBMDASQL. AS400 side table has an CCSID of 1153 and I think that is causing my error.
OLE DB provider "IBMDASQL" for linked server "AS400_POL" returned message "SQL0332: Character conversion between CCSID 1153 and CCSID 285 not valid. Cause . . . . . : Character or graphic conversion has been attempted for data that is not compatible. There is no conversion defined between CCSID 1153 and CCSID 285. If one CCSID is 65535, the other CCSID is a graphic CCSID. Conversion is not defined between 65535 and a graphic CCSID. If this is a CONNECT statement, conversion is not defined between the default application requester SBCS CCSID and the application server SBCS CCSID. If the second CCSID is 0, the application server did not return its default SBCS CCSID. An application server other than DB2 for IBM i may not support a CCSID of 65535. Recovery . . . : Ensure that all character or graphic comparisons, concatenation, or assignments are between columns or host variables with compatible CCSID values. If this is a CONNECT statement, change either the SBCS CCSID of the application requester or the application server, so conversion between the CCSID values is defined.".