Skip to Content
SAP IQ

Quick Setup Steps for Setting Python for SAP SYBASE IQ

Tags:

sqlanydb is SQL Antywhere Python database interfaces for data access API for the Phython language. Steps listed below can be used to set up Phython for Sap Sybase IQ. The Python database API is very powerful programming languge, set of  methods used  by this API provides a consistent  database interface independent of the database being used.   For detailed information about Python Database specification v2.0,

http://www.python.org/dev/peps/pep-0249/.

and for supported platforms refer to:

http://www.sybase.com/detail?id=1068981.

From SAP Sybste Release directory,  cd $SYBASE/IQ-15_4

1. [IQ-15_4]$ source IQ-15_4.csh
Sourcing SYBASE.csh
2. [ IQ-15_4]$ cd sdk
[sdk]$ ls
c  dbcapi  include  perl  perlenv  php  phpenv  python  ruby
3. [sdk]$ cd python
[ python]$ ls
build  scripts  setup.py  sqlanydb.py

4. As root


[ python]$ sudo python setup.py install
[sudo] password for user1:
running install
running build
running build_py
running install_lib
copying build/lib/sqlanydb.py -> /usr/lib/python2.6/site-packages
byte-compiling /usr/lib/python2.6/site-packages/sqlanydb.py to sqlanydb.pyc
running install_egg_info
Writing /usr/lib/python2.6/site-packages/sqlanydb-1.0.2-py2.6.egg-info
[ python]$

5, edit test.py(This script will start IQ server )  with correct dbn and dbname

6. python /rhvm1_work/rel154_iq_esd2/IQ-15_4/sdk/python/scripts/test.py

===================================
IQ server starting with:
     10 connections         (       -gm )
     14 cmd resources       ( -iqgovern )
    136 threads             (     -iqmt )
    512 Kb thread stack size   (   -iqtss  )
  69632 Kb thread memory size ( -iqmt * -iqtss )
      2 IQ number of cpus  ( -iqnumbercpus )
      0 MB maximum size of IQMSG file ( -iqmsgsz )
      0 copies of IQMSG file archives ( -iqmsgnum )
=============================================================

Warning: Using default value for -iqmc or -iqtc is insufficient for most applications
Warning: Using default value for -iqmc or -iqtc is insufficient for most applications
Using licenses from:/usr/sybase/rel154_iq_esd2/SYSAM-2_0/licenses/keyserver.syb
ase.com.lic:/usr/sybase/rel154_iq_esd2/IQ-15_4/demo/simplex/*.lic
Checked out license for 2 IQ_CORE (2013.0331/31-mar-2013/11F0 02BD A308 E97B) will expire Mon 01 Apr 2013 12:00:00 AM PDT.
WARNING: IQ functionality that requires the IQ_CORE license will be disabled on
Mon 01 Apr 2013 12:00:00 AM PDT, unless a suitable IQ_CORE license is obtained before that date.
sqlanydb successfully installed.
[simplex]$ Checked in license for 2 IQ_CORE (2013.0331/31-mar-2013/
11F0 02BD A308 E97B).
Checked in license for 2 IQ_CORE (2013.0331/31-mar-2013/11F0 02BD A308 E97B).

[simplex]$

The sqlanydb is now ready to use.