×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Other candidates for implicitly hidden columns:
Anything defaulted like this:
default-clause
.-WITH-.
|--+------+--DEFAULT--+--------------------------------------------------------------------+--|
+-constant-----------------------------------------------------------+
+-USER---------------------------------------------------------------+
+-NULL---------------------------------------------------------------+
+-CURRENT_DATE-------------------------------------------------------+
+-CURRENT_TIME-------------------------------------------------------+
| .-(--6--)-------. |
+-CURRENT_TIMESTAMP--+---------------+-------------------------------+
| '-(--integer--)-' |
'-cast-function-name--(--+-constant-----------------------------+--)-'
+-USER---------------------------------+
+-CURRENT_DATE-------------------------+
+-CURRENT_TIME-------------------------+
| .-(--6--)-------. |
'-CURRENT_TIMESTAMP--+---------------+-'
'-(--integer--)-'
Or updated with this:
as-row-change-timestamp-clause
|--FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP---------------|
Or 'secure' data. Columns masked using Row and column access control
(RCAC)
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzahf/rzahfrcactitle.htm?lang=en
Rob Berendt
midrange.com
