jwflicker
commented
1 month ago The customer has reported seeing unprintable characters in their results. But i suspect we need information about how the codepages were setup for Db2 and what the actual column values in the database are. Can you forward the relevant DDL statements and details about the tables involved?
Can you also attach the relevant query result file from your workspace? To do this, reproduce the issue, then right click on teh Db2 Connection and select properties, navigate to the Tracing tab, and press the Show Logs button:
In the Finder, go up one level and go into the queryResults folder. Find the most recently created file and send that to us.
Chetan03899
Problem description
After connecting to a Db2 database and viewing Db2 table data in IDz v16 with Db2 for z/OS it is not showing the data in proper format, and when we view the same table data in the SPUFI, it is coming in as expected.
Detailed steps for reproducing the problem:
Scenario explanation: Let's take the below as a sample table (the below snippet is not related to the actual issue, just used to explain the scenario):
In the above snippet, we are viewing the CUST DATA table for field LNAME, which is showing properly as expected, and it will also show the same format in the SPUFI if we check.
Actual issue: For example, when we are viewing the ABC table in the IDZ for FIELD1, we are not getting the correct data as it is showing in the SPUFI. It is giving squares instead of blank spaces and giving the @ instead of that character.
Observed behavior
Giving squares instead of blank spaces Its giving the @ instead of that character.
Expected behavior
Should be blank spaces and actual character.