OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: tabuhr on May 16, 2011, 04:53:05 PM

Title: Looking for data in DB2 tables
Post by: tabuhr on May 16, 2011, 04:53:05 PM
If I want to know what application groups are included in each group, what internal DB2 tables, would I find this data?
Title: Re: Looking for data in DB2 tables
Post by: Michel de Kraker on May 16, 2011, 07:24:39 PM
Hi,

In the application group, tab storage , advanced you see on top of the screen your db2 table name.
In db2 you can query :

select * from <instanceowner>.db2 tablename

example:

select * from root.YDK1

with describe table root.YDK1 you can see all the fields

Kind regards,

Michel.
Title: Re: Looking for data in DB2 tables
Post by: Alessandro Perucchi on May 17, 2011, 05:47:39 AM
Hello,

just a precision from the post of Michel, you can only do that (the "select" and the "describe table") if you have at least done a load of a document in this application group, otherwise CMOD won't even create the table.

Cheers,
Alessandro