OTL 4.0, Example 238 (OTL/DB2-CLI, accessing the system data dictionary via DB2 CLI functions, DB2)

Source Code

#include <iostream>
#include <stdio.h>
using namespace std;

#define OTL_DB2_CLI // Compile OTL 4.0/DB2-CLI
#include <otlv4.h> // include the OTL 4.0 header file

otl_connect db; // connect object


void select()
{ 
 otl_stream s;

 s.set_all_column_types(otl_all_num2str|otl_all_date2str); 
    // map all numeric and date/time output columns to strings for simplicity.

 s.open(100, // buffer size
         "$SQLTables",
         // get a list of all tables in the current database
         db // connect object
        ); 

 otl_column_desc* desc;
 int desc_len;
 desc=s.describe_select(desc_len); 
    // describe the structure of the output columns of the result set.

 int rpc=0;
 while(!s.eof()){
   ++rpc;
   char str[512];
   cout<<"ROW#"<<rpc<<" ";
   for(int col_num=0;col_num<desc_len;++col_num){
     s>>str;
     if(s.is_null())
       cout<<desc[col_num].name<<"=NULL ";
     else
       cout<<desc[col_num].name<<"="<<str<<" ";
   }
   cout<<endl;
 }

}

int main()
{
 otl_connect::otl_initialize(); // initialize DB2 CLI environment
 try{

  db.rlogon("scott/tiger@db2sql"); // connect to DB2

  select(); // query the system data dictionary via DB2 CLI functions.

 }

 catch(otl_exception& p){ // intercept OTL exceptions
  cerr<<p.msg<<endl; // print out error message
  cerr<<p.stm_text<<endl; // print out SQL that caused the error
  cerr<<p.sqlstate<<endl; // print out SQLSTATE message
  cerr<<p.var_info<<endl; // print out the variable that caused the error
 }

 db.logoff(); // disconnect from DB2

 return 0;

}
 Output
ROW#1 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSATTRIBUTES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#2 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSBUFFERPOOLNODES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#3 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSBUFFERPOOLS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#4 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSCHECKS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#5 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSCOLAUTH TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#6 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSCOLCHECKS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#7 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSCOLDIST TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#8 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSCOLOPTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#9 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSCOLPROPERTIES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#10 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSCOLUMNS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#11 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSCONSTDEP TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#12 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSDATATYPES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#13 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSDBAUTH TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#14 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSDEPENDENCIES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#15 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSEVENTMONITORS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#16 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSEVENTS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#17 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSFUNCMAPOPTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#18 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSFUNCMAPPARMOPTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#19 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSFUNCMAPPINGS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#20 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSFUNCPARMS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#21 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSFUNCTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#22 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSHIERARCHIES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#23 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSINDEXAUTH TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#24 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSINDEXCOLUSE TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#25 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSINDEXES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#26 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSINDEXEXPLOITRULES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#27 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSINDEXEXTENSIONMETHODS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#28 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSINDEXEXTENSIONPARMS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#29 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSINDEXEXTENSIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#30 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSINDEXOPTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#31 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSJARCONTENTS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#32 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSJAROBJECTS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#33 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSKEYCOLUSE TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#34 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSNAMEMAPPINGS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#35 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSNODEGROUPDEF TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#36 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSNODEGROUPS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#37 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSPARTITIONMAPS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#38 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSPASSTHRUAUTH TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#39 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSPLAN TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#40 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSPLANAUTH TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#41 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSPLANDEP TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#42 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSPREDICATESPECS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#43 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSPROCEDURES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#44 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSPROCOPTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#45 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSPROCPARMOPTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#46 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSPROCPARMS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#47 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSRELS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#48 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSREVTYPEMAPPINGS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#49 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSSCHEMAAUTH TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#50 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSSCHEMATA TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#51 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSSECTION TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#52 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSSEQUENCES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#53 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSSERVEROPTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#54 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSSERVERS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#55 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSSTMT TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#56 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSTABAUTH TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#57 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSTABCONST TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#58 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSTABLES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#59 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSTABLESPACES TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#60 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSTABOPTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#61 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSTBSPACEAUTH TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#62 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSTRANSFORMS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#63 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSTRIGGERS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#64 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSTYPEMAPPINGS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#65 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSUSERAUTH TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#66 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSUSEROPTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#67 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSVERSIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#68 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSVIEWDEP TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#69 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSVIEWS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#70 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSWRAPOPTIONS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#71 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSWRAPPERS TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#72 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=CL_SCHED TABLE_TYPE=TABLE REMARKS=NULL 
ROW#73 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=DEPARTMENT TABLE_TYPE=TABLE REMARKS=NULL 
ROW#74 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=EMP_ACT TABLE_TYPE=TABLE REMARKS=NULL 
ROW#75 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=EMP_PHOTO TABLE_TYPE=TABLE REMARKS=NULL 
ROW#76 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=EMP_RESUME TABLE_TYPE=TABLE REMARKS=NULL 
ROW#77 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=EMPLOYEE TABLE_TYPE=TABLE REMARKS=NULL 
ROW#78 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=IN_TRAY TABLE_TYPE=TABLE REMARKS=NULL 
ROW#79 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=ORG TABLE_TYPE=TABLE REMARKS=NULL 
ROW#80 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=PROJECT TABLE_TYPE=TABLE REMARKS=NULL 
ROW#81 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=SALES TABLE_TYPE=TABLE REMARKS=NULL 
ROW#82 TABLE_CAT=NULL TABLE_SCHEM=DEFAULT TABLE_NAME=STAFF TABLE_TYPE=TABLE REMARKS=NULL 
ROW#83 TABLE_CAT=NULL TABLE_SCHEM=SCOTT TABLE_NAME=T1 TABLE_TYPE=TABLE REMARKS=NULL 
ROW#84 TABLE_CAT=NULL TABLE_SCHEM=SCOTT TABLE_NAME=TEST_TAB TABLE_TYPE=TABLE REMARKS=NULL 
ROW#85 TABLE_CAT=NULL TABLE_SCHEM=SCOTT TABLE_NAME=TEST_TAB1 TABLE_TYPE=TABLE REMARKS=NULL 
ROW#86 TABLE_CAT=NULL TABLE_SCHEM=SCOTT TABLE_NAME=TEST_TAB2 TABLE_TYPE=TABLE REMARKS=NULL 
ROW#87 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=ATTRIBUTES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#88 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=BUFFERPOOLNODES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#89 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=BUFFERPOOLS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#90 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=CASTFUNCTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#91 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=CHECKS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#92 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=COLAUTH TABLE_TYPE=VIEW REMARKS=NULL 
ROW#93 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=COLCHECKS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#94 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=COLDIST TABLE_TYPE=VIEW REMARKS=NULL 
ROW#95 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=COLOPTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#96 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=COLUMNS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#97 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=CONSTDEP TABLE_TYPE=VIEW REMARKS=NULL 
ROW#98 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=DATATYPES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#99 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=DBAUTH TABLE_TYPE=VIEW REMARKS=NULL 
ROW#100 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=EVENTMONITORS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#101 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=EVENTS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#102 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=FULLHIERARCHIES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#103 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=FUNCDEP TABLE_TYPE=VIEW REMARKS=NULL 
ROW#104 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=FUNCMAPOPTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#105 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=FUNCMAPPARMOPTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#106 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=FUNCMAPPINGS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#107 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=FUNCPARMS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#108 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=FUNCTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#109 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=HIERARCHIES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#110 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=INDEXAUTH TABLE_TYPE=VIEW REMARKS=NULL 
ROW#111 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=INDEXCOLUSE TABLE_TYPE=VIEW REMARKS=NULL 
ROW#112 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=INDEXDEP TABLE_TYPE=VIEW REMARKS=NULL 
ROW#113 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=INDEXES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#114 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=INDEXOPTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#115 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=KEYCOLUSE TABLE_TYPE=VIEW REMARKS=NULL 
ROW#116 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=NAMEMAPPINGS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#117 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=NODEGROUPDEF TABLE_TYPE=VIEW REMARKS=NULL 
ROW#118 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=NODEGROUPS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#119 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=PACKAGEAUTH TABLE_TYPE=VIEW REMARKS=NULL 
ROW#120 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=PACKAGEDEP TABLE_TYPE=VIEW REMARKS=NULL 
ROW#121 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=PACKAGES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#122 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=PARTITIONMAPS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#123 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=PASSTHRUAUTH TABLE_TYPE=VIEW REMARKS=NULL 
ROW#124 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=PROCEDURES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#125 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=PROCOPTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#126 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=PROCPARMOPTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#127 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=PROCPARMS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#128 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=REFERENCES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#129 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=REVTYPEMAPPINGS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#130 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=SCHEMAAUTH TABLE_TYPE=VIEW REMARKS=NULL 
ROW#131 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=SCHEMATA TABLE_TYPE=VIEW REMARKS=NULL 
ROW#132 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=SERVEROPTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#133 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=SERVERS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#134 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=STATEMENTS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#135 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=TABAUTH TABLE_TYPE=VIEW REMARKS=NULL 
ROW#136 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=TABCONST TABLE_TYPE=VIEW REMARKS=NULL 
ROW#137 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=TABLES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#138 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=TABLESPACES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#139 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=TABOPTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#140 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=TBSPACEAUTH TABLE_TYPE=VIEW REMARKS=NULL 
ROW#141 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=TRIGDEP TABLE_TYPE=VIEW REMARKS=NULL 
ROW#142 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=TRIGGERS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#143 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=TYPEMAPPINGS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#144 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=USEROPTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#145 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=VIEWDEP TABLE_TYPE=VIEW REMARKS=NULL 
ROW#146 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=VIEWS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#147 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=WRAPOPTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#148 TABLE_CAT=NULL TABLE_SCHEM=SYSCAT TABLE_NAME=WRAPPERS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#149 TABLE_CAT=NULL TABLE_SCHEM=SYSIBM TABLE_NAME=SYSDUMMY1 TABLE_TYPE=SYSTEM TABLE REMARKS=NULL 
ROW#150 TABLE_CAT=NULL TABLE_SCHEM=SYSSTAT TABLE_NAME=COLDIST TABLE_TYPE=VIEW REMARKS=NULL 
ROW#151 TABLE_CAT=NULL TABLE_SCHEM=SYSSTAT TABLE_NAME=COLUMNS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#152 TABLE_CAT=NULL TABLE_SCHEM=SYSSTAT TABLE_NAME=FUNCTIONS TABLE_TYPE=VIEW REMARKS=NULL 
ROW#153 TABLE_CAT=NULL TABLE_SCHEM=SYSSTAT TABLE_NAME=INDEXES TABLE_TYPE=VIEW REMARKS=NULL 
ROW#154 TABLE_CAT=NULL TABLE_SCHEM=SYSSTAT TABLE_NAME=TABLES TABLE_TYPE=VIEW REMARKS=NULL 


Examples ContentsGo Home
Copyright © 1996, 2007, Sergei Kuchin, email: skuchin@ispwest.com, skuchin@gmail.com

  .
Permission to use, copy, modify and redistribute this document
for any purpose is hereby granted without fee, provided that the above
copyright notice appear in all copies.