Re: 7.1 broke REMARKS column from JAVA getcolumns method

[CRPence <CRPbottle@xxxxxxxxx>]

On 31 Mar 2013 19:04, Jim It wrote:
> I've noticed that since we have been upgrading our partitions
> that the column label text returned for any files from JAVA is
> now returning only null values. <<SNIP>>

  Hmmm... REMARKS I thought were for COMMENT ON rather than LABEL ON 
information.  Regardless...

  I would check the value for the REMARKS column in SYSCOLUMNS [in 
QSYS2 and SYSIBM] for some specific file names that are exhibiting the 
issue.  The LONG_COMMENT FOR REMARKS column was changed to have the data 
type VARGRAPHIC(2000) CCSID 1200 on IBM i 7.1:
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzcatsyscol.htm

  The change was made from the data type VARCHAR(2000) with the CCSID 
of the installed Primary Language, as defined on prior releases:
http://pic.dhe.ibm.com/infocenter/iseries/v6r1m0/topic/db2/rbafzcatsyscol.htm

  Perhaps similarly look at the COLUMN_TEXT FOR LABELTEXT and 
COLUMN_HEADING FOR LABEL columns if perhaps the client request for 
/REMARKS/ is to return one of those instead.  Those columns had the 
/same/ change made for v7r1.

  If a duplicate of a file exhibiting the problem [CRTDUPOBJ or CREATE 
TABLE ... AS\LIKE] does not have the same problem, then the issue likely 
originated due to the upgrade\conversion.  If the duplicate of the file 
exhibits the same issue, then there is likely a problem either with the 
tracking of the columns in the catalogs or with the interface to the client.

  FWiW there is an APAR and PTF for an [un-described other than 
"corrupt"] issue with that column in the catalogs, and there is no 
mention in the APAR that the issue corrected by a PTF was manifest as 
the NULL value:
http://www.ibm.com/support/docview.wss?uid=nas3e8e2d87e616b0e0386257ab0004cf0c2
_i SI48143 - OSP-DB-OTHER-THREADS LONG_COMMENT FIELD GETS CORRUPT i_
"... v7r1m0 C3037710"