We re-done our DWH database in UTF-8 mode to use new features (BLUE aceleratio...)
Now we have alot of problem when we write special characters on new DB2.
Our first Datastage version was 7.x so, because of old jobs, we not have enabled NLS feature.
Is there a way to load correctly the records?
I seen, sometime, using API stage (blue stage) instead green stage some field is correct.
Someone have any idea?
Thanks alot
New IBM DB2 10.5 UTF-8
Moderators: chulett, rschirm, roy
New IBM DB2 10.5 UTF-8
Hi everybody!!!
Are you planning on turning on NLS in DataStage or continuing without it?
Specifically what problems are you having when writing to the database?
Specifically what problems are you having when writing to the database?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
He meant DB2 "BLU", that is fun to work with and can be incredibly fast or agonizingly slow. We had the latter initially but then got the former after redesigning the load process.
http://www-01.ibm.com/software/data/db2 ... eleration/
http://www-01.ibm.com/software/data/db2 ... eleration/
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>