StarQuest Technical Documents

StarSQL Technical Frequently Asked Questions


Last Update: 17 July 2017
Product: StarSQL
Version: 5.x, 6.x
Article ID: SQV00SQ061

The following technical FAQs are designed to answer common questions regarding StarSQL.

Should I rebind StarSQL packages when upgrading StarSQL?

 

Can StarSQL access implicitly hidden columns?

Recent versions of DB2 introduced a column attribute called "IMPLICTLY HIDDEN". A column that is defined as implicitly hidden is not part of the result table of a query that specifies * in a SELECT list. However, an implicitly hidden column can be explicitly referenced in a query.

If you want the hidden columns to appear in the results of SQLColumns() - for instance, when using SQDR - use v6.33 or later of StarSQL, and set the advanced property useDSCRDBTBL to No (the default is Yes).