python-sybase-misc

[python-sybase] installation problem of the Sybase module

[Harri P. <har...@tr...>]

Me again,

Forgot to mention an installation/build problem with the Sybase module.  
On Linux Mandrake 8.1 + some patches, Python 2.2,  the module linked with
libintl.so from Sybase.  But at runtime it picked up the library from
/usr/lib, which is of course not the Sybase lib, even if has the same name.

My workaround for the above was to create a symlink libsybintl.so ->
libintl.so in the sybase lib directory, and tweak the setup.py to use
libsybintl.so.


-Harri

[python-sybase] Problem with calling stored procedures

[Harri P. <har...@tr...>]

Hello,

I think the old problem with calling some stored procedures still seems to be
there.

Namely, I still can't get any sensible results from calling sp_helpindex. 
The code is something like:


def getindex(table):
    print "getindex", table
    c = cnx.cursor()
    c.callproc("sp_helpindex", [table])
    l = c.fetchall()
    print l
    while c.nextset():
        l = c.fetchall()
        print l

cnx=Sybase.connect("<server>","<uname>","<pass>")
cnx.cursor().execute("use mydb")

getindex("mytable")


-Harri

Re: [python-sybase] stored procedure

[Dave C. <dj...@ob...>]

> Hi listers, I am trying to call a stored procedure using module v2.0
> on Sybase version 11.9.2.  The problem is that not all the records I
> am querying for using the stored procedure are returned in the
> result set.  Below is a snippet of my code:
> 
> #
> #Call stored procedure to get MO notification list(based on outage type)
> #
> db=Sybase.connect("<server>","<uname>","<pass>#",auto_commit=1)
> c=db.cursor()
> c.callproc('sp_get_mo_notification_list',tkt)
> c.nextset()
> 
> r=c.fetchall()
> 
> print "NTFY LIST: " +str(r)
> 
> Is there anything else I should be doing in order to fetch all the
> records I need?  Any help is greatly appreciated.

The first call to nextset() is going to be discarding a set of rows I
think.

Can you try doing this:

c.callproc('sp_get_mo_notification_list',tkt)
while 1:
    r=c.fetchall()
    print "NTFY LIST: " +str(r)
    if not c.nextset():
        break

- Dave

-- 
http://www.object-craft.com.au

[python-sybase] stored procedure

[Potian, J. (Exchange) <jp...@be...>]

Hi listers,

I am trying to call a stored procedure using module v2.0 on Sybase version
11.9.2.  The problem is that not all the records I am querying for using the
stored procedure are returned in the result set.  Below is a snippet of my
code:

#
#Call stored procedure to get MO notification list(based on outage type)
#
db=Sybase.connect("<server>","<uname>","<pass>#",auto_commit=1)
c=db.cursor()
c.callproc('sp_get_mo_notification_list',tkt)
c.nextset()

r=c.fetchall()

print "NTFY LIST: " +str(r)

Is there anything else I should be doing in order to fetch all the records I
need?  Any help is greatly appreciated.

Regards,

Jon-Marcelius Potian
Bear Stearns & Co.
IT - Problem Management
Phone: 973-793-7053
Fax:     973-793-5775
Pager:  1-800-515-BEAR




**********************************************************************
Please be aware that, notwithstanding the fact that the person sending
this communication has an address in Bear Stearns' e-mail system, this
person is not an employee, agent or representative of Bear Stearns.
Accordingly, this person has no power or authority to represent, make
any recommendation, solicitation, offer or statements or disclose
information on behalf of or in any way bind Bear Stearns or any of its
affiliates.
**********************************************************************

[python-sybase] First message for python-sybase list

[Andrew M. <an...@ob...>]

A message to get the wrinkles out of Mailman.

-- 
Andrew McNamara, Senior Developer, Object Craft
http://www.object-craft.com.au/