Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Getting number of tables per database from within C program
Is there an API or CLI call that I can make from within a C program to get the number of tables for a particular database ?? I know that I can run 'LIST TABLES' from the CLP, but this doesn't help me. I need to execute this from within a program. Thanks in advance, Bill -
Extracting database, instance, tablespace info using CLI
I've checked the sample programs, no luck. Also, I can't call the CLP commands from a processor window. I need to execute them from a 'C' program. Thanks for the replies, Bill -
syscat.tables vs. 'LIST TABLESPACES SHOW DETAILS'
Is there a non-intrusive way to get this information. I need to extract it without the ability to execute any commands that may steal processing time. The information must already exist, since the LIST TABLESPACES command returns it ?? Any ideas ?? -
Extracting database, instance, tablespace info using CLI
Are there commands, either CLI or API to list: o Instances on the server o Databases for each instance o Tablespaces for each databases ?? Basically, I'm trying to re-create the tree that comes up in the left side of the control center and need to extract all this information from within a... -
syscat.tables vs. 'LIST TABLESPACES SHOW DETAILS'
Why is it when, using the CLP, I issue 'LIST TABLESPACES SHOW DETAILS' I get the correct number of pages allocated for each tablespace, yet when I use a select statement, say for tablespace id=0 SELECT NPAGES, FPAGES from SYSCAT.TABLES where TBSPACEID=0 I get -1 for each column ?? I need to use...
