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-2024, Sergei Kuchin, email: skuchin@gmail.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. THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.