TomLiotta Nov 4, 2010   2:31 AM GMT

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

125,585 pointsBadges: