dynamobi/dynamobi — Issue #781: [FRG-89] !columns and !describe won't work on sys_fem."Config"."FarragoConfig" table
Author: dynamobi-build
Created: 2011-12-30 03:48:40+00:00
State: open
Labels: Catalog, FRG

[reporter="kinkoi", created="Wed, 22 Mar 2006 12:43:16 -0500 (GMT-05:00)"]
Here is the output

0: jdbc:farrago:> alter system set "calcVirtualMachine" = 'CALCVM_JAVA';

No rows affected (0.011 seconds)

0: jdbc:farrago:> !columns sys_fem."Config"."FarragoConfig";

+------------+--------------+-------------+--------------+------------+--------

+

| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | DATA_TYPE | TYPE_N

|

+------------+--------------+-------------+--------------+------------+--------

+

+------------+--------------+-------------+--------------+------------+--------

+

0: jdbc:farrago:> !describe sys_fem."Config"."FarragoConfig";

+------------+--------------+-------------+--------------+------------+--------

+

| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | DATA_TYPE | TYPE_N

|

+------------+--------------+-------------+--------------+------------+--------

+

+------------+--------------+-------------+--------------+------------+--------

+

------- Comment #1 From John Sichi 2004-07-16 12:25 [reply] -------

Right, Farrago doesn't currently have any metadata capability for virtual catalogs like sys_fem. This is not something planned for the near future so downgrading to P4.