Installing DBD::SQLAnywhere on Unix

Install the DBD::SQLAnywhere interface on the supported Unix platforms to use Perl to access SAP Sybase IQ databases.

Prerequisites

You must have ActivePerl 5.6.0 build 616 or later and a C compiler installed.

Task
  1. Download the DBI module source from http://www.cpan.org.
  2. Extract the contents of this file into a new directory.
  3. At a command prompt, change to the new directory and run the following commands to build the DBI module.
    perl Makefile.PL
    make

    If for any reason you need to start over, you can use the command make clean to remove any partially built targets.

  4. Use the following command to test the DBI module.
    make test
  5. To complete the installation, run the following command at the same prompt.
    make install
  6. Make sure the environment is set up for SAP Sybase IQ.

    Depending on which shell you are using, enter the appropriate command to source the SAP Sybase IQ configuration script from the SAP Sybase IQ installation directory:

    In this shell... Use this command...

    sh, ksh, or bash

    . bin/sa_config.sh

    csh or tcsh

    source bin/sa_config.csh

  7. At a shell prompt, change to the sdk/perl subdirectory of your SAP Sybase IQ installation.
  8. At a command prompt, run the following commands to build DBD::SQLAnywhere.
    perl Makefile.PL
    make

    If for any reason you need to start over, you can use the command make clean to remove any partially built targets.

  9. To test DBD::SQLAnywhere, copy the sample database file to your sdk/perl directory and make the tests.
    cp samples-dir/demo.db .
    iqsrv16 demo
    make test

    If the tests do not run, ensure that the bin32 or bin64 subdirectory of the SAP Sybase IQ installation is in your path.

  10. To complete the installation, run the following command at the same prompt.
    make install

The DBI Perl module and the DBD::SQLAnywhere interface are ready for use.

Next

Optionally, you can delete the DBI source tree. It is no longer required.