Quick-Start Guide

This section describes how to precompile, build, and execute the Employees.exe example; contains a description of the preliminary requirements; and explains how to run the example; for the Windows platform.

These are the minimum preliminary requirements:

  • Install the latest version of the Adabas SQL Gateway.

  • Create an Adabas database with a sample EMPLOYEES table that is identical in content to the default sample Adabas EMPLOYEES table. The table may be created within ADADBA using the Employees.fdt provided in the PRECOMPILER/WINDOWS install directory.

  • Install either Visual Studio 6 or 7 and make sure it is available.

To quick-start the Adabas SQL Gateway Embedded SQL Employees.exe example file on a Windows machine:

  1. Create a new CDD using the DDL import option and the Employees.ddl provided in the PRECOMPILER/WINDOWS install directory or use an existing CDD containing the EMPLOYEES Adabas sample table.

  2. Verify that the CDD security allows Read/Write Queries.

  3. Create a new DSN by click Start, pointing to Programs, pointing to CONNX, and then clicking on the DSNRegistry tool.
    Click the Add button to create a new DSN.

    For more information, see "To add a new data source name for the JDBC driver" found in the Adabas SQL Gateway help file, available online and within the Adabas SQL Gateway product.

  4. Edit the _Employees.c source file so that all connection information is correct.

  5. Set the following environment variables within the build_test.bat file:

ADADIR = <Root of your Adabas install>

ADAVERS = <version of your Adabas installation, for example, V331>

SAG_COMMON = <Path to the Software AG common DLL repository>

VS_PATH = <Path to bin directory of Visual Studio>

  1. Inspect the pre_compile.bat and compile.bat files and edit if necessary to ensure that the sample will build in your environment.

  2. Start the CONNX JDBC Server as described in "Starting the JDBC Server" in the Adabas SQL Gateway help file.

  3. Start the Adabas database.

  4. Type the following at the command line, to precompile, build, and run the example:

build_test

   

Important: The example writes to and deletes from the database.  If all of the tests that do write/delete succeed, then the database should have returned to its original state.