Examples

There are some small example programs for demonstrating how to use the SQLDBC SDK and building applications.

Some are written in C++ like HelloWorld.cpp. Other once are written in native C like HelloWorld_C.c.

The example programs HelloWorld.cpp and HelloWorld_C.c shows the following:

1. How to connect to the database
2. Execute a simple SQL statement
3. Retrieving the result from a query

Other example programs for UNICODE etc. are exists. You will find all files neccessary to build the examples here.
Unpack this archive to any folder you want or use the demo sources, if you have an full installation, in your examples directory under <indep_prog>/samples/SQLDBC .

Building the example program

All of the examples can build at the same way. We like to describe the way for building the HelloWorld example.

MS Windows (32 and 64 Bit)

• Switch to the directory where the HelloWorld example files are located.
  

  cd "C:\\Program Files\\sdb\\programs\\samples\\SQLDBC\\HelloWorld"
  

• Make the example by calling 'nmake SQLDBCSDK=<sqldbc_sdk_path> win32
  

  nmake SQLDBCSDK="C:\Program Files\sdb\programs" win32
  

UNIX

• Switch to the directory where the HelloWorld example files are located.
  

  cd /opt/sdb/programs/samples/SQLDBC/HelloWorld
  

• Make the example by calling 'make SQLDBCSDK=<sqldbc_sdk_path> <os>'.
  Dependend on your operating system you should set <os> to one of the following value
  

  <os> := linux | linuxIa64 | linuxppc | sun | hpux | hpIa64 | dec | aix | win32 | amd64

  For LINUX call:

  make SQLDBCSDK="/opt/sdb/programs" linux
  

Testing the example program

• Be sure that the environment variable PATH (Windows) or LD_LIBRARY_PATH (UNIX) is set to the MaxDB shared libraries.
  
  • To set the environment variable on Windows enter the following command:
    set PATH="C:\Program Files\sdb\programs\pgm";%PATH%
  • To set the environment variable on UNIX enter the following command:
    export LD_LIBRARY_PATH=/opt/sdb/programs/lib:$LD_LIBRARY_PATH
    
• To run the example test program enter the following command:

  HelloWorld MONA RED HOTELDB
  

• If the test was succeesfull the example program outputs the following lines:
  

  Sucessfull connected to HOTELDB as user MONA
Hello world