PI25786: BIG SQL 3 - "SELECT * FROM SYSCAT.COLUMNS" NOT WORKING

APAR status

• Closed as Permanent restriction.

Error description

• Big SQL 3 - "select * from syscat.columns" not working
  
  
  Reproduction Steps:
  
  1) In jsqsh connect to bigsql source
  2) Run the following query:
  
  [bisup001.svl.ibm.com][biadmin] 1> select * from syscat.columns;
  SQL Exception(s) Encountered:
  [State: null][Code: -4220]: [jcc][t4][1065][12306][3.67.33]
  Caught java.io.CharConversionException.  See attached Throwable
  for details. ERRORCODE=-4220, SQLSTATE=null
  
  
  The issue is caused when we try to query the following 2 columns
   in syscat.columns catalog table: HIGH2KEY and LOW2KEY. Those 2
  columns are defined as Varchars, but they seem to contain binary
   data.
  

Local fix

• Do not query these 2 columns:
  HIGH2KEY
  
  LOW2KEY
  
  This query works:
  
  select TABSCHEMA,TABNAME,COLNAME, ... from syscat.columns;
  

Problem summary

• See problem Description
  

Problem conclusion

• This issue no longer exists in BI v4
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• NA
  

Fix information

Applicable component levels