We upgraded from V5R4M0 to V5R4M5 and now we are getting null fillers when using the CPYTOIMPF on varchar columns. Before the upgrade the the same command would remove trailing blanks. Anyone had to deal with this problem. Thanks
That's a question that might not get much help from here. It's almost guaranteed to be an IBM PTF issue, so IBM Support is the only reasonable place to go (assuming you have support through IBM, otherwise it will be your support organization). You'll have to go to IBM Support to get the PTF anyway.
You can search for PTFs in a few ways. My most common entry is through the PTF Cover Letters page. Click on [ Search ], enter perhaps [ cpytoimpf varchar ] into the 'Search' field, select 'Limit search to:' as "5.4 PTF Cover Letters" and click [Search].
I see at least two that could be related: SI37671 "CPYTOIMPF CREATES A FILE WITH NULLS AT THE END" and SI33864 "CPYTOIMPF - PAD HEX DATA WITH X'40' R". A few others are possible, but IBM might need to create a new PTF for you. Keep in mind that the exact symptoms might not be given in a PTF cover letter. The PTF was created to fix a particular reported problem, but related elements often become fixed as a result.
I could guess that SI33864 would fit even if it's unlikely. But it can't be more than a guess because I don't know the file CCSID, the column CCSID, the QCCSID system value nor anything else that might be related, not to mention not knowing anything about what PTFs you already have.
Maybe you can find other PTFs in the list that fit better.
Tom
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 1  Reply