Programmatic access to data dictionary?

SoCalled · #1 (**permalink**) 12-15-05, 17:36

Not sure if this can be done, but can you access the table dictionaries via programs ? Haven't found anything detailing this in the documentation.

Am using

db2 8.2 Express, vb6.

TIA

Marcus_A · #2 (**permalink**) 12-15-05, 20:14

Yes, the layouts of the Syscat views are documented in the SQL Reference VOL I Appendix.

SoCalled · #3 (**permalink**) 12-18-05, 18:20

Thanks Marcus.

Looks like SYSCAT.COLUMNS and SYSCAT.TABLES are what l want to use, now need to determine what properties .TABLES have. Basically want to list current db2 tables, then allow for selection of a single table returning column details.

Will keep checking the manual to see if it lists the available properties for SYSCAT.TABLES.

Internet Services

Web Development

Digital Marketing

Consumer Tech