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!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: billhoves
  • Content: Threads
  • Order by date
  1. billhoves

    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
  2. billhoves

    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...
  3. billhoves

    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...

Part and Inventory Search

Back
Top