DSXchange

To clarify, we did indeed have the padchar set to blank and something changed it back to the default x'00'. That occurred on the same day that FP1 was applied. We did find it and fix it, unfortunately it was several weeks later and we had to spend a fair amount of time fixing data. The search for th...

We recently applied fixpack1 to DS 8.1 and encountered an unexpected result. All our character columns were padded with blanks up until the day the fix pack was applied then we began to see x'00' as the padchar. I set the APT_STRING_PADCHAR to x'20' and we've been OK since then. I'm trying to find o...

If you note the original post, Q2 did address this issue. I could put it in a different thread, but since the subject had already been brought up in this one... I reset the padchar to x'20' where it was prior to the fix pack. I understand that's "how it works". I want to know what changed ...

We saw DataStage 8.1 replacing spaces with x'00's after applying some patches. We haven't been able to pin down the cause but we know we had blanks before the patch and x'00's immediately afterwards. Has anybody else encountered this? If so, have you determined the root cause?

They exist for all projects in the /app/Projects directory.

While cleaning up some filesystems on our DS server, I ran across hundreds of files like orbtrc.15052009.0800.36.txt. Most of them have this exception in them: 08:00:36.381 com.ibm.rmi.pi.InterceptorManager runPreInit:176 P=834104:O=0:CT ORBRas[default] java.lang.ClassNotFoundException: com.ibm.ws.a...

I need a way to transform a column in a db2 table containing binary data to character values. For example, the source is a payment method and will have a value of 1 for MC, 2 for VISA and 3 means both Visa and MC were used. Are there any bit test functions that work on binary data? It seems like the...

That took care of the warnings. Thanks.

I'm "learning by doing" and have run into a problem. I'm reading a database using ODBC and copying the results to a text file. I get the following warning: IXDTHD: [IIS-CONN-DAAPI-000393] The length of WCHAR column QAQVST cannot be validated because the database column is CHAR and characte...