pydb2-discuss — Python DB2 Discussion List

Re: [Might be spam] Re: [Might be spam] Re: [PyDB2-discuss] Windows binaries

[Kristjan G. B. <kg...@ve...>]

Hi Bryan,

Got the file via http and tested the binaries.  Works great!   Million=20
thanks for the help.

Regards,
Kristjan

>Hi Kristjan,
>
>I think you're trying to connect behind a firewall, so 'active' mode of =
FTP transfer will fail.
>Please try 'passive' mode of your FTP client.
>
>Or just use this http url:
>
>http://people.linuxkorea.co.kr/~yong/tmp/
>
>Please let me know you succeed or not with this module.
>
>Regards,
>Bryan
>
>----- Original Message -----=20
>From: "Kristjan Gudni Bjarnason" <kg...@ve...>
>To: "???" <yo...@li...>
>Cc: <pyd...@li...>
>Sent: Tuesday, September 28, 2004 10:25 PM
>Subject: Re: [Might be spam] Re: [PyDB2-discuss] Windows binaries
>
>
>Hi Bryan,
>
>Didn't get to my email until today.  Thanks for the effort of compiling=20
>them for me.  For some reason I can't get the binaries from your site. =20
>I log in as anonymous.  Here is the log...
>
>ftp> pwd
>257 "/pub/DB2/win32" is current directory.
>ftp> get DB2-0.998a.win32-py2.3.exe
>200 PORT command successful.
>425 Can't build data connection: No route to host
>ftp>
>
>Is the file still there?
>
>Thanks,
>Kristjan
>
>
>
> =20
>

--=20
------------------------------------------
Kristjan G. Bjarnason   (kg...@ve...)
Tel. +354 522 6000
Verkefnisstj=F3ri t=F6lvu=FEj=F3nustu - IT Manager
Vedurstofa Islands (Icelandic Met. Office)
Bustadavegur 9, IS-150, Reykjavik, Iceland
------------------------------------------=20

Re: [Might be spam] Re: [PyDB2-discuss] Windows binaries

[Kristjan G. B. <kg...@ve...>]

Hi Bryan,

Didn't get to my email until today.  Thanks for the effort of compiling=20
them for me.  For some reason I can't get the binaries from your site. =20
I log in as anonymous.  Here is the log...

ftp> pwd
257 "/pub/DB2/win32" is current directory.
ftp> get DB2-0.998a.win32-py2.3.exe
200 PORT command successful.
425 Can't build data connection: No route to host
ftp>

Is the file still there?

Thanks,
Kristjan


??? wrote:

>Hi,
>
>OK, I've just downloaded Windows version of DB2 V8.1 now and compiled th=
e newest version of PyDB2
>from CVS.
>
>You can download it at ftp://people.linuxkorea.co.kr/pub/DB2/win32.
>
>The filename is DB2-0.998a.win32-py2.3.exe.  As you can see from the fil=
ename, the binary is built with
>Python 2.3.
>
>Bryan
>
>----- Original Message -----=20
>From: "Kristjan Gudni Bjarnason" <kg...@ve...>
>To: <pyd...@li...>
>Sent: Wednesday, September 22, 2004 6:21 PM
>Subject: [PyDB2-discuss] Windows binaries
>
>
> =20
>
>>Hi,
>>
>>Successfully I have been using pydb2 on AIX for few months now. =20
>>Unfortunaly I need to run it also on Windows operating system but I=20
>>don't have MS Visual Studio V6.  Does anyone have pydb2 binaries=20
>>available?  Need to run them on Windows2000/XP and with DB2 v8.1.=20
>>
>>Thanks,
>>Kristjan G
>>
>>
>>-------------------------------------------------------
>>This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
>>Project Admins to receive an Apple iPod Mini FREE for your judgement on
>>who ports your project to Linux PPC the best. Sponsored by IBM.
>>Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
>>_______________________________________________
>>PyDB2-discuss mailing list
>>PyD...@li...
>>https://lists.sourceforge.net/lists/listinfo/pydb2-discuss
>>
>>   =20
>>
>
>
> =20
>

--=20
------------------------------------------
Kristjan G. Bjarnason   (kg...@ve...)
Tel. +354 522 6000
Verkefnisstj=F3ri t=F6lvu=FEj=F3nustu - IT Manager
Vedurstofa Islands (Icelandic Met. Office)
Bustadavegur 9, IS-150, Reykjavik, Iceland
------------------------------------------=20

[PyDB2-discuss] Windows binaries

[Kristjan G. B. <kg...@ve...>]

Hi,

Successfully I have been using pydb2 on AIX for few months now.  
Unfortunaly I need to run it also on Windows operating system but I 
don't have MS Visual Studio V6.  Does anyone have pydb2 binaries 
available?  Need to run them on Windows2000/XP and with DB2 v8.1. 

Thanks,
Kristjan G

RE: [PyDB2-discuss] inconsistency

[<yu...@ad...>]

Quoting Atli Thorbjornsson <at...@ga...>:

> I am porting an ingres application over to db2, hence the strange syntax.
> Extra quotes do not help but as I said removing them does. I can live with
> that fix myself but I was just wondering why it works in command line db2
> and not in pydb2.
I have no idea... single quotes in the command line don't work for me 
actually...

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

RE: [PyDB2-discuss] inconsistency

[Atli T. <at...@ga...>]

I am porting an ingres application over to db2, hence the strange syntax.
Extra quotes do not help but as I said removing them does. I can live wit=
h
that fix myself but I was just wondering why it works in command line db2
and not in pydb2.

	Atli.

-----Original Message-----
From: yu...@ad... [mailto:yu...@ad...]
Sent: 28. ma=ED 2004 15:11
To: at...@ga...
Cc: pyd...@li...
Subject: RE: [PyDB2-discuss] inconsistency


Quoting Atli Thorbjornsson <at...@ga...>:

> It seems to have something to do with having '3 hours' enclosed in quot=
es.
> If I remove the quotes then pydb2 works fine. Does that clarify?
> 	Atli
I dont understand... you simply write CURRENT TIMESTAMP - '3 hours' ?
I mean '3 hours' as a string ?
Cause if so, try to replace '3 hours' with ''3 hours'' but i dont think
that's
the case (I wasn't even aware that you could subtract timestamps in that
manner)

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

RE: [PyDB2-discuss] inconsistency

[<yu...@ad...>]

Quoting Atli Thorbjornsson <at...@ga...>:

> It seems to have something to do with having '3 hours' enclosed in quotes.
> If I remove the quotes then pydb2 works fine. Does that clarify?
> 	Atli
I dont understand... you simply write CURRENT TIMESTAMP - '3 hours' ?
I mean '3 hours' as a string ?
Cause if so, try to replace '3 hours' with ''3 hours'' but i dont think that's 
the case (I wasn't even aware that you could subtract timestamps in that 
manner)

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

RE: [PyDB2-discuss] inconsistency

[Atli T. <at...@ga...>]

It seems to have something to do with having '3 hours' enclosed in quotes.
If I remove the quotes then pydb2 works fine. Does that clarify?
	Atli

-----Original Message-----
From: yu...@ad... [mailto:yu...@ad...]
Sent: 28. ma=ED 2004 10:48
To: at...@ga...
Cc: pyd...@li...
Subject: Re: [PyDB2-discuss] inconsistency


Quoting Atli Thorbjornsson <at...@ga...>:

> Hi,
> 	I am dealing with an inconsistency between replies from db2. The
following
> comparison works fine using db2 command line
>
> select ... from ... where a.time >=3D CURRENT TIMESTAMP - '3 hours'
>
> but when using pydb2 I get:
>
> SQLSTATE : 42818, NATIVE ERROR CODE : -401
> [IBM][CLI Driver][DB2/6000] SQL0401N  The data types of the operands fo=
r
the
> operation ">=3D" are not compatible.  SQLSTATE=3D42818
>
> Any ideas?
> 	Atli Thorbjornsson.
I'm assuming that a.time is defined to be of type timestamp, right ?

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

Re: [PyDB2-discuss] Segmentation fault

[<yu...@ad...>]

Quoting Atli Thorbjornsson <at...@ga...>:

> Hi again,
> 	I keep getting segfaults whenever I try to retrieve a timestamp in 
pydb2
> without first converting it to a string via char(). I realise one should
> probably always cast first anyway but I have a lot of inexperienced python
> programmers working under my supervision and segfaults are rather scary.
> Shouldn't this either work or just be caught in an exception printing
> something informative out instead of the timestamp?
> 
> Example:
> 
> import DB2
> 
> conn = DB2.connect()
> curs = conn.cursor()
> 
> curs.execute("select intime from hra where intime > current timestamp -
> dec(120000,6)"
> one_row = curs.fetchone()
> print one_row[0]
> curs.close()
> del curs
> conn.close()
> del conn
> 
> 
> intime is a timestamp in table hra. This segfaults in pydb2 on
> (curs.fetchone()) but obviously runs fine on command line.
> 
> If you point me in the right direction I might even be able to do it for you
> ;)
> 
> 	Atli Thorbjornsson.
This is an old bug (segfault when querying a timestamp field) - we fixed it i 
think.  What version are you using ?

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

[PyDB2-discuss] RE: Segmentation fault

[Atli T. <at...@ga...>]

Yet again I shoot to soon... forgot to look through the archives before
posting, missed the bit about the segfault fixed in cvs, my apologies.

	Atli.

-----Original Message-----
From: Atli Thorbjornsson [mailto:at...@ga...]
Sent: 28. mai 2004 11:32
To: Patrick K. O'Brien
Cc: pyd...@li...
Subject: Segmentation fault


Hi again,
	I keep getting segfaults whenever I try to retrieve a timestamp in pydb2
without first converting it to a string via char(). I realise one should
probably always cast first anyway but I have a lot of inexperienced python
programmers working under my supervision and segfaults are rather scary.
Shouldn't this either work or just be caught in an exception printing
something informative out instead of the timestamp?

Example:

import DB2

conn = DB2.connect()
curs = conn.cursor()

curs.execute("select intime from hra where intime > current timestamp -
dec(120000,6)"
one_row = curs.fetchone()
print one_row[0]
curs.close()
del curs
conn.close()
del conn


intime is a timestamp in table hra. This segfaults in pydb2 on
(curs.fetchone()) but obviously runs fine on command line.

If you point me in the right direction I might even be able to do it for you
;)

	Atli Thorbjornsson.

[PyDB2-discuss] Segmentation fault

[Atli T. <at...@ga...>]

Hi again,
	I keep getting segfaults whenever I try to retrieve a timestamp in pydb2
without first converting it to a string via char(). I realise one should
probably always cast first anyway but I have a lot of inexperienced python
programmers working under my supervision and segfaults are rather scary.
Shouldn't this either work or just be caught in an exception printing
something informative out instead of the timestamp?

Example:

import DB2

conn = DB2.connect()
curs = conn.cursor()

curs.execute("select intime from hra where intime > current timestamp -
dec(120000,6)"
one_row = curs.fetchone()
print one_row[0]
curs.close()
del curs
conn.close()
del conn


intime is a timestamp in table hra. This segfaults in pydb2 on
(curs.fetchone()) but obviously runs fine on command line.

If you point me in the right direction I might even be able to do it for you
;)

	Atli Thorbjornsson.

RE: [PyDB2-discuss] inconsistency

[Atli T. <at...@ga...>]

That's correct. I have to use a different time duration for this to work
with pydb2 like
current timestamp - decimal(030000,6) which is a bitch because I am actua=
lly
porting a bunch of sql code from ingres and the less I have to change the
better.

	Atli

-----Original Message-----
From: yu...@ad... [mailto:yu...@ad...]
Sent: 28. ma=ED 2004 10:48
To: at...@ga...
Cc: pyd...@li...
Subject: Re: [PyDB2-discuss] inconsistency


Quoting Atli Thorbjornsson <at...@ga...>:

> Hi,
> 	I am dealing with an inconsistency between replies from db2. The
following
> comparison works fine using db2 command line
>
> select ... from ... where a.time >=3D CURRENT TIMESTAMP - '3 hours'
>
> but when using pydb2 I get:
>
> SQLSTATE : 42818, NATIVE ERROR CODE : -401
> [IBM][CLI Driver][DB2/6000] SQL0401N  The data types of the operands fo=
r
the
> operation ">=3D" are not compatible.  SQLSTATE=3D42818
>
> Any ideas?
> 	Atli Thorbjornsson.
I'm assuming that a.time is defined to be of type timestamp, right ?

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

Re: [PyDB2-discuss] inconsistency

[<yu...@ad...>]

Quoting Atli Thorbjornsson <at...@ga...>:

> Hi,
> 	I am dealing with an inconsistency between replies from db2. The 
following
> comparison works fine using db2 command line
> 
> select ... from ... where a.time >= CURRENT TIMESTAMP - '3 hours'
> 
> but when using pydb2 I get:
> 
> SQLSTATE : 42818, NATIVE ERROR CODE : -401
> [IBM][CLI Driver][DB2/6000] SQL0401N  The data types of the operands for the
> operation ">=" are not compatible.  SQLSTATE=42818
> 
> Any ideas?
> 	Atli Thorbjornsson.
I'm assuming that a.time is defined to be of type timestamp, right ?

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

[PyDB2-discuss] inconsistency

[Atli T. <at...@ga...>]

Hi,
	I am dealing with an inconsistency between replies from db2. The following
comparison works fine using db2 command line

select ... from ... where a.time >= CURRENT TIMESTAMP - '3 hours'

but when using pydb2 I get:

SQLSTATE : 42818, NATIVE ERROR CODE : -401
[IBM][CLI Driver][DB2/6000] SQL0401N  The data types of the operands for the
operation ">=" are not compatible.  SQLSTATE=42818

Any ideas?
	Atli Thorbjornsson.

[PyDB2-discuss] timestamp segfault resolved, found another bug

[Jeremy H. <je...@hi...>]

Hi all,

I somehow missed that there was a mailing list for this project and sent
an email directly to Patrick.

Anyway, the problem I had with a segfault on timestamp columns is
apparently already fixed in CVS HEAD.  As a result, that's the version
that I'll be using.

I did find another bug, that I believe I have fixed correctly. I
submitted it as a patch.  The gist of it from my patch submission:

    Select statements of the type for selecting from an insert, update,
    or delete statement are not supported.  i.e.

    SELECT i FROM FINAL TABLE (INSERT into test1(a,b,c) VALUES (?,?,?))

    This type of SQL results in a segmentation fault on Linux when the
    cursor.fetchone/many() Python method is called.

    The cause is that the num_cols from SQLNumResultCols() has a value >
    0 but the row_count from SQLRowCount() results in a number
    indicating how many rows were updated by the DML statement.

    The end result is that the SQL statement was executed successfully,
    but when trying to retrieve the result from the statement PyDB2
    segfaults.

enjoy,

-jeremy

-- 
========================================================================
 Jeremy Hinegardner                              je...@hi... 

[PyDB2-discuss] Re: Python and DB2 V8.1.5

[<po...@or...>]

Jeremy Hinegardner <je...@hi...> writes:

> Hi Peter,

It's Patrick, actually.  But I've been called worse.  ;-)

> I read your article on DB2 and Python in the DB2 Developer Domain and
> I've  been experimenting with Python and DB2 for some items we're doing
> on our team.
> 
> I've come across a troubling problem.  There seems to be a major problem
> with the PyDB2 module and timestamp columns.
> 
> We're using the latest packaged download from SourceForge and compiling
> against DB2 V8.1.5 on RHEL.  Any select that includes a timestamp column
> immediately segfaults the python module.
> 
> I don't know if you are still actively involved in the development of
> the PyDB2 module, but you're the only developer listed on the
> SourceForge page.

I'm not actively involved in the development, so I'm copying this
response to the PyDB2 mailing list in the hopes that one of the other
developers can look into this.

Regards,

Pat

-- 
Patrick K. O'Brien
Orbtech  http://www.orbtech.com
Blog     http://www.sum-ergo-cogito.com

[PyDB2-discuss] CLOB example

[Jaco S. <JS...@cl...>]

Hello there

I  am somewhat stuck. Any help would be appreciated. 

I am trying to read a CLOB column from a db2 database  using py2b2. 

The values I'm reading are fairly large, and I can't figure out how to 
retrieve the rest of the value.

I suspect the answer lies in the locator somewhere (from searching 
google), but I can't  figure out how to do it.

thanks in advance 

Jaco

[PyDB2-discuss] Re: PyDB2

[<po...@or...>]

"R.D.Ginsburg" <tac...@us...> writes:

> Ok, perhaps I'm an idiot.  Hoping you can give me some direction.
> Note, I am running Win/2K.  I have installed IBM DB2 personal
> edition.  It works fine.  Downloaded PyDB2 and untarred it to
> c:\python23 \lib\sitepackages\ and then ran "python setup.py build".
> Unfortunately, PyDB2 seems to have made the bold assumption that you
> have MS Visual C installed in order to compile the driver!!!
> Yikes...
> 
> Is there an alternative?  Is there a binary install?  I am desperate
> to use Python to access by iSeries DB2.  Any/All help is GREATLY
> appreciated.
> 
> -Roy G

Roy,

I'm copying your questions to the discussion list in the hopes that
others will be able to help.  There is no current binary install right
now.  It would be great if one of the developers could provide that as
I'm not in a position to do so.

Best wishes,

Pat

-- 
Patrick K. O'Brien
Orbtech  http://www.orbtech.com
Blog     http://www.sum-ergo-cogito.com

[PyDB2-discuss] Re: Plans for supporting DB/2 on iSeries ?

[<po...@or...>]

Patrick Bielen <pb...@us...> writes:

> Hi,
> 
> I was wondering if DB/2 for iSeries is going to be added in the
> future ?
> 
> The reason why i ask this is because i now always have to use jython
> in combination with IBM's Java Toolkit to get things done, but it
> would be nice if i simply could use Python instead.

Hi, Patrick.  Good question.  I don't know the answer, so I'm copying
this to the mailing list so that you might get a response.  Feel free
to join it here:

http://lists.sourceforge.net/lists/listinfo/pydb2-discuss

We've actually been getting more discussion going lately, so now is
probably a good time to get involved.  If you really want to get it
working on the iSeries, I can give you developer access to the code
and you can make sure it works for you.  Just let me know your
SourceForge account name (pbielen ?) and I'll set you up.

Best wishes,

Pat

-- 
Patrick K. O'Brien
Orbtech  http://www.orbtech.com
Blog     http://www.sum-ergo-cogito.com

Re: [PyDB2-discuss] Re: DB2

[<po...@or...>]

Frank Balzer <Fra...@su...> writes:

> > Great.  Would you like to be a developer on the project?

> Yes. My sourceforge name is kibosoft.

You are now a developer on the project.  Welcome aboard!

-- 
Patrick K. O'Brien
Orbtech  http://www.orbtech.com
Blog     http://www.sum-ergo-cogito.com

Re: [PyDB2-discuss] DB2 performance

[<yu...@ad...>]

Quoting Preston Landers <pla...@jo...>:

> On Fri, 27 Feb 2004, ??? wrote:
> 
> > Hi~ everyone
> >
> > As you can see in the source code, PyDB2 is not suited for performance yet.
> > The purpose of the first code I wrote was 'let's make it do something in
> hurry'.
> > There's a lot of things to improve to speed up the operation and should be
> coded in C.
> >
> > Welcome!
> >
> > I want to see the PyDB2 be speed-demon :)
> 
> 
> Hello everyone,
> 
> I'm curious to hear everyone's ideas on speeding up this driver.  I've
> only spent a small amount of time looking at the source code so far, but I
> don't have any ideas yet on speeding it up.  Then again I am not
> intimately familiar with DB2's low level protocol.
> 
> By the way, I have not yet checked in my enhacement to support the
> SQL_SUCCESS_WITH_INFO status code... I believe you had suggested there was
> a better way to handle storing the warning message, but I never quite
> understand what you wanted me to do with it.
> 
> thanks,
> Preston

I'm not really sure about the performance issue - I mean the DB2 api is fairly 
simple - prepare, execute and fetch (which is exactly what is being done in 
the module at the moment).  There are issues that I encountered, however.  One 
issue, for example, is that the connection and cursor objects are defined 
inside the c module itself which causes bad ref. counting management.  
Since the issue of a new implementation now arises I think that we could take 
a look in the MySQLdb code and learn how things are done there (module 
objects' definitions, error handling, various python optimizations, etc.)
What do you say?

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

[PyDB2-discuss] DB2 performance

[Preston L. <pla...@jo...>]

On Fri, 27 Feb 2004, ??? wrote:

> Hi~ everyone
> 
> As you can see in the source code, PyDB2 is not suited for performance yet.
> The purpose of the first code I wrote was 'let's make it do something in hurry'.
> There's a lot of things to improve to speed up the operation and should be coded in C.
> 
> Welcome!
> 
> I want to see the PyDB2 be speed-demon :)


Hello everyone,

I'm curious to hear everyone's ideas on speeding up this driver.  I've
only spent a small amount of time looking at the source code so far, but I
don't have any ideas yet on speeding it up.  Then again I am not
intimately familiar with DB2's low level protocol.

By the way, I have not yet checked in my enhacement to support the
SQL_SUCCESS_WITH_INFO status code... I believe you had suggested there was
a better way to handle storing the warning message, but I never quite
understand what you wanted me to do with it.

thanks,
Preston

[PyDB2-discuss] Re: DB2

[Frank B. <Fra...@su...>]

Hi Patrick,

On Feb 26, 2004 08:55 AM, Patrick K. O'Brien <po...@or...> wrote:

> Hi Frank.  Glad to have you involved.
Thanks. 
> Great.  Would you like to be a developer on the project?
Yes. My sourceforge name is kibosoft.
> As for your ideas, you could join the mailing list and try to get a
> discussion going.  The list info is available here:
> 
> http://lists.sourceforge.net/lists/listinfo/pydb2-discuss
I had subscribed  to the list.

Frank

Re: [PyDB2-discuss] Re: DB2

[Yuval T. <yu...@il...>]

Patrick K. O'Brien wrote:

>>On the other side the efficiency of the module seems to be very poor
>>and I have ideas to fix this.
>>    
>>
Ideas are always good... lets discuss them.
We would all love to see this module improve.... :-)
Thanks!

-- 
Yuval Turgeman
Content Technology, Aduva LTD.

[PyDB2-discuss] Re: DB2

[<po...@or...>]

Frank Balzer <kib...@us...> writes:

> Hi Patrick,

Hi Frank.  Glad to have you involved.

> I 've tried to use the DB2 module in a big database application and
> I had some problems related to CLOB and BLOB support.  I fixed the
> code and I want to give it back to the community.

Wonderful.  We'd love to have your fixes.

> On the other side the efficiency of the module seems to be very poor
> and I have ideas to fix this.

Great.  Would you like to be a developer on the project?  That way you
could get the latest code from CVS, make your changes, test them, and
check them in.  Just let me know your sourceforge name (kibosoft ?)
and I'll add you to the project as a developer.

As for your ideas, you could join the mailing list and try to get a
discussion going.  The list info is available here:

http://lists.sourceforge.net/lists/listinfo/pydb2-discuss

Thanks again!

-- 
Patrick K. O'Brien
Orbtech  http://www.orbtech.com
Blog     http://www.sum-ergo-cogito.com

[PyDB2-discuss] Re: pydb2 binaries?

[<po...@or...>]

kon...@sp... writes:

> Hi Patrick, would you by any chance have a Python 2.3 interface for
> DB2 7.2.5 on Windows NT that you could send me? Or maybe you know
> someone who might have it compiled?
> 
> I don't have access to any C compiler at this location, and I'm
> getting a bit tired of adodbapi...

Sorry, I don't.  But I'm copying this to the mailing list in the hopes
that someone else will.

-- 
Patrick K. O'Brien
Orbtech  http://www.orbtech.com
Blog     http://www.sum-ergo-cogito.com