OTL 4.0, Example 239 (OTL/ODBC, accessing the system data dictionary via ODBC functions, MS SQL Server)

Source Code

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

#define OTL_ODBC // Compile OTL 4.0/ODBC
#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 $1:'%' $2:'' $3:''",
         // get a list of databases on the current connection's server.
         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 ODBC environment
 try{

  db.rlogon("scott/tiger@mssql"); // connect to ODBC

  select(); // query the system data dictionary via ODBC 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 ODBC

 return 0;

}
 Output
ROW#1 TABLE_CAT=DMS TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULL 
ROW#2 TABLE_CAT=master TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULL 
ROW#3 TABLE_CAT=msdb TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULL 
ROW#4 TABLE_CAT=Northwind TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULL 
ROW#5 TABLE_CAT=pubs TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULL 
ROW#6 TABLE_CAT=tempdb TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL 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.