| Database schema / Database schema extractor options | |
Starting with IBM® Informix® IDS version 11.50.xC1, you can create shadow columns on tables by using DDL options such as ADD VERCOLS. These columns are visible in the system catalog tables and would be listed in the column descriptions of the .sch schema file. However, as shadow columns are not part of the SELECT * list, it is not expected to get these columns in the schema file.
By default, the fgldbsch tool will not extract shadow columns from an IBM Informix database. You can use the -sc option to force the extraction of shadow columns:
fgldbsch -db test1 -sc