IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50

Taken from pg 2-226 of Guide to SQL Syntax: 
For most database operations, the ifx_insert_checksum and 
ifx_row_version columns are hidden. For example, if you 
include the WITH VERCOLS keywords when you create a table, the 
ifx_insert_checksum and ifx_row_version columns have the 
following behavior: 
- They are not returned by queries that specify an asterisk ( * 
) as the projection list, as in the  statement: SELECT * FROM 
tablename; 
-They do not appear in DB-Access when you ask for information 
about the columns of the table. 
-They are not included in the number of columns (ncols) in the 
systables system catalog table entry for tablename. 
However, when using 11.50.xC1, with the following example you 
will see the behavior below: 
create table tab2 
  ( 
    col1 char(20) not null , col2 char(20),  col3 integer, 
col4 date,  col5 money(16,2), 
    ifx_insert_checksum integer  default null, 
    ifx_row_version integer  default 1 
  ); 
select tabname, ncols from systables where taname ='tab2'; 
result: 
tabname  tab2 
ncols  7         <=== this should be 5. 
This behavior was also observed when the vercols were added to 
a 5 column table subsequent to the create table -- by way of an 
alter table: 
"ALTER TABLE tab2 add VERCOLS"

**************************************************************** 
USERS AFFECTED: 
All users of v11.50 documentation. 
**************************************************************** 
PROBLEM DESCRIPTION: 
Prior to version 11.50.xc3, documentation about the behavior of 
ifx_insert_checksum and ifx_row_version columns was incomplete. 
This error existed in the Using the WITH VERCOLS Option (IDS) 
topic of the Guide to SQL: Syntax. 
**************************************************************** 
RECOMMENDATION: 
Update to the v11.50.xc3 documentation. 
****************************************************************

Beginning with version 11.50.xc3, the following 
ifx_insert_checksum and ifx_row_version column behavior is added 
to the Using the WITH VERCOLS Option (IDS) topic: 
* They appear in DB-Access when you ask for information about 
the columns of the table. 
* They are included in the number of columns (ncols) in the 
systables system catalog table entry for tablename.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

15.07.2008
17.12.2008
17.12.2008

11.50.c30