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.