Looking for data in DB2 tables

[tabuhr]

If I want to know what application groups are included in each group, what internal DB2 tables, would I find this data?

[Michel de Kraker]

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.

[Alessandro Perucchi]

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