ajlull
Active Member
Hi all:
I am working at an AS400 OS/DB2 shop that is having downstream issues with characters that SQL server finds as invalid upon trying to assimilate the data from the source. We are XE SP24(Looking to upgrade) and are looking to see if there is a solution on our source system(AS400) to eliminate the constant errors on our outlying systems not recognizing these invalid chars.
1. It appears that these characters come from importing or cut/paste from excel.
2. Are there changes that can be made to OS400 that can eliminate chars that are incompatible?
Any suggestions for how we can eliminate these characters without customization?
AJ
SYS: AS400 os/DB2 XE SP24
Config: High AV. Mimix Multi Site.
Data replication for other systems to SQL Server 2000, 2005.
**any other info available at any time.
I am working at an AS400 OS/DB2 shop that is having downstream issues with characters that SQL server finds as invalid upon trying to assimilate the data from the source. We are XE SP24(Looking to upgrade) and are looking to see if there is a solution on our source system(AS400) to eliminate the constant errors on our outlying systems not recognizing these invalid chars.
1. It appears that these characters come from importing or cut/paste from excel.
2. Are there changes that can be made to OS400 that can eliminate chars that are incompatible?
Any suggestions for how we can eliminate these characters without customization?
AJ
SYS: AS400 os/DB2 XE SP24
Config: High AV. Mimix Multi Site.
Data replication for other systems to SQL Server 2000, 2005.
**any other info available at any time.