You can subscribe to this list here.
2003 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(6) |
Nov
(3) |
Dec
|
---|---|---|---|---|---|---|---|---|---|---|---|---|
2004 |
Jan
(8) |
Feb
(9) |
Mar
(2) |
Apr
|
May
(12) |
Jun
|
Jul
|
Aug
|
Sep
(3) |
Oct
|
Nov
|
Dec
(6) |
2005 |
Jan
(10) |
Feb
|
Mar
(4) |
Apr
|
May
|
Jun
|
Jul
(4) |
Aug
|
Sep
(2) |
Oct
(2) |
Nov
|
Dec
|
2006 |
Jan
(3) |
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
(21) |
Jul
|
Aug
(2) |
Sep
|
Oct
|
Nov
(1) |
Dec
|
2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(3) |
Jun
|
Jul
(2) |
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
|
2008 |
Jan
|
Feb
(13) |
Mar
(5) |
Apr
|
May
(1) |
Jun
(2) |
Jul
|
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
(1) |
2009 |
Jan
|
Feb
(3) |
Mar
|
Apr
(6) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2010 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
From: Thomas L. W. <mr...@gm...> - 2010-09-24 14:54:25
|
I am trying to build version 1.1.1. of your module with "python setup.py build", but I get: "_db2_module.c:27:21: error: sqlcli1.h: No such file or directory". I am using Ubuntu 10.04, and I hope that I just need to install some dev lib with apt-get. But what library/package is that? Sincerely, Thomas |
From: Lennart J. <len...@la...> - 2010-06-07 13:56:19
|
Is anyone using PyDB2 on 64 bit linux for 9.5? I'm getting a link error when trying to compile since there is both a lib32 and a lib64 for 9.5 (on 64 bit, on 32 bit there is only a lib32), and lib32 is found first. Reversing the order of suggested libs in setup.py seems to work for 9.5 64 bit, havent tried other relaeases. [... ~/PyDB2/PyDB2_1.1.1]# diff -ruN setup.py.orig setup.py --- setup.py.orig 2010-06-07 15:21:10.000000000 +0200 +++ setup.py 2010-06-07 15:23:06.000000000 +0200 @@ -79,7 +79,7 @@ # the library directory is either lib32 or lib64. According to some, a # "lib" symlink should point to the appropriate dir, but it certainly # doesn't in the installs I've seen... - for path in ['lib', 'lib32', 'lib64']: + for path in ['lib64', 'lib32', 'lib']: if os.path.exists(os.path.join(db2rootdir, path)): return os.path.join(db2rootdir, path) # Give up noisily /Lennart |
From: Costas P. <cpi...@gm...> - 2010-02-23 22:23:43
|
Hi, I've installed the DB2 Linux Python Adapter, and I'm getting this stack trace below. I'm running the DB2 9.5 client connecting to DB2 9.5.4 Also, I've noticed the the setup.py file should be updated as newer db2 clients have the libs in lib32 (or lib64) instead of just lib... (I can submit a patch for that if you like) *** glibc detected *** /usr/bin/python: free(): invalid pointer: 0x0993cc00 *** ======= Backtrace: ========= /lib/libc.so.6[0x456751] /usr/lib/python2.6/site-packages/_db2.so(+0x5ec5)[0xc0bec5] /usr/lib/libpython2.6.so.1.0[0x612e924] /usr/lib/libpython2.6.so.1.0[0x61053e3] /usr/lib/libpython2.6.so.1.0[0x612cc61] /usr/lib/libpython2.6.so.1.0(PyDict_SetItem+0x82)[0x612f9e2] /usr/lib/libpython2.6.so.1.0(_PyModule_Clear+0x176)[0x6131856] /usr/lib/libpython2.6.so.1.0(PyImport_Cleanup+0x402)[0x61a1e82] /usr/lib/libpython2.6.so.1.0(Py_Finalize+0xb5)[0x61ab045] /usr/lib/libpython2.6.so.1.0(Py_Main+0x59f)[0x61b85df] /usr/bin/python(main+0x28)[0x80485c8] /lib/libc.so.6(__libc_start_main+0xe6)[0x3febb6] /usr/bin/python[0x8048501] ======= Memory map: ======== 00110000-00113000 r-xp 00000000 fd:01 45896 /usr/lib/python2.6/lib-dynload/timemodule.so 00113000-00115000 rw-p 00002000 fd:01 45896 /usr/lib/python2.6/lib-dynload/timemodule.so 00115000-00129000 r-xp 00000000 fd:01 20695 /usr/lib/python2.6/site-packages/_pokereval_2_6.so.1.0.0 00129000-0012a000 rw-p 00013000 fd:01 20695 /usr/lib/python2.6/site-packages/_pokereval_2_6.so.1.0.0 0012a000-0012d000 r-xp 00000000 fd:01 126032 /opt/ibm/db2/V9.5/lib32/libdb2install.so.1 0012d000-0012e000 rw-p 00003000 fd:01 126032 /opt/ibm/db2/V9.5/lib32/libdb2install.so.1 0012e000-00130000 rw-p 00000000 00:00 0 00130000-00133000 r-xp 00000000 fd:01 126140 /opt/ibm/db2/V9.5/security32/plugin/IBM/client/IBMOSauthclient.so 00133000-00134000 rw-p 00002000 fd:01 126140 /opt/ibm/db2/V9.5/security32/plugin/IBM/client/IBMOSauthclient.so 00134000-00143000 r-xp 00000000 fd:01 125986 /opt/ibm/db2/V9.5/lib32/icc/icclib/libicclib.so 00143000-00144000 rw-p 0000f000 fd:01 125986 /opt/ibm/db2/V9.5/lib32/icc/icclib/libicclib.so 00144000-00148000 r-xp 00000000 fd:01 41615 /usr/lib/python2.6/lib-dynload/selectmodule.so 00148000-0014a000 rw-p 00003000 fd:01 41615 /usr/lib/python2.6/lib-dynload/selectmodule.so 0014a000-00169000 r-xp 00000000 fd:01 93149 /usr/lib/libpoker-eval.so.1.0.0 00169000-001c6000 rw-p 0001f000 fd:01 93149 /usr/lib/libpoker-eval.so.1.0.0 001c6000-001cd000 r-xp 00000000 fd:01 22243 /lib/libcrypt-2.11.1.so 001cd000-001ce000 r--p 00007000 fd:01 22243 /lib/libcrypt-2.11.1.so 001ce000-001cf000 rw-p 00008000 fd:01 22243 /lib/libcrypt-2.11.1.so 001cf000-001f6000 rw-p 00000000 00:00 0 001f6000-0023b000 r-xp 00000000 fd:01 22564 /usr/lib/libfreebl3.so 0023b000-0023c000 rw-p 00044000 fd:01 22564 /usr/lib/libfreebl3.so 0023c000-00240000 rw-p 00000000 00:00 0 00240000-00251000 r-xp 00000000 fd:01 45875 /usr/lib/python2.6/lib-dynload/cPickle.so 00251000-00252000 rw-p 00011000 fd:01 45875 /usr/lib/python2.6/lib-dynload/cPickle.so 00256000-00258000 r-xp 00000000 fd:01 45856 /usr/lib/python2.6/lib-dynload/_functoolsmodule.so 00258000-00259000 rw-p 00001000 fd:01 45856 /usr/lib/python2.6/lib-dynload/_functoolsmodule.so 00259000-00308000 r-xp 00000000 fd:01 24823 /usr/lib/libstdc++.so.5.0.7 00308000-0030d000 rw-p 000ae000 fd:01 24823 /usr/lib/libstdc++.so.5.0.7 0030d000-00312000 rw-p 00000000 00:00 0 0032f000-00343000 r-xp 00000000 fd:01 126000 /opt/ibm/db2/V9.5/lib32/libdb2dascmn.so.1 00343000-0034a000 rw-p 00013000 fd:01 126000 /opt/ibm/db2/V9.5/lib32/libdb2dascmn.so.1 0034a000-0034c000 rw-p 00000000 00:00 0 003aa000-003ac000 r-xp 00000000 fd:01 47202 /lib/libutil-2.11.1.so 003ac000-003ad000 r--p 00001000 fd:01 47202 /lib/libutil-2.11.1.so 003ad000-003ae000 rw-p 00002000 fd:01 47202 /lib/libutil-2.11.1.so 003c6000-003e4000 r-xp 00000000 fd:01 10936 /lib/ld-2.11.1.so 003e4000-003e5000 r--p 0001d000 fd:01 10936 /lib/ld-2.11.1.so 003e5000-003e6000 rw-p 0001e000 fd:01 10936 /lib/ld-2.11.1.so 003e8000-00557000 r-xp 00000000 fd:01 23884 /lib/libc-2.11.1.so 00557000-00559000 r--p 0016e000 fd:01 23884 /lib/libc-2.11.1.so 00559000-0055a000 rw-p 00170000 fd:01 23884 /lib/libc-2.11.1.so 0055a000-0055d000 rw-p 00000000 00:00 0 0055f000-00587000 r-xp 00000000 fd:01 32794 /lib/libm-2.11.1.so 00587000-00588000 r--p 00027000 fd:01 32794 /lib/libm-2.11.1.so 00588000-00589000 rw-p 00028000 fd:01 32794 /lib/libm-2.11.1.so 0058b000-0058e000 r-xp 00000000 fd:01 27912 /lib/libdl-2.11.1.so 0058e000-0058f000 r--p 00002000 fd:01 27912 /lib/libdl-2.11.1.so 0058f000-00590000 rw-p 00003000 fd:01 27912 /lib/libdl-2.11.1.so 00592000-005a8000 r-xp 00000000 fd:01 24069 /lib/libpthread-2.11.1.so 005a8000-005a9000 r--p 00015000 fd:01 24069 /lib/libpthread-2.11.1.so 005a9000-005aa000 rw-p 00016000 fd:01 24069 /lib/libpthread-2.11.1.so 005aa000-005ac000 rw-p 00000000 00:00 0 005ae000-005b5000 r-xp 00000000 fd:01 25067 /lib/librt-2.11.1.so 005b5000-005b6000 r--p 00006000 fd:01 25067 /lib/librt-2.11.1.so 005b6000-005b7000 rw-p 00007000 fd:01 25067 /lib/librt-2.11.1.so 006d9000-006ed000 r-xp 00000000 fd:01 30213 /lib/libresolv-2.11.1.so 006ed000-006ee000 ---p 00014000 fd:01 30213 /lib/libresolv-2.11.1.so 006ee000-006ef000 r--p 00014000 fd:01 30213 /lib/libresolv-2.11.1.so 006ef000-006f0000 rw-p 00015000 fd:01 30213 /lib/libresolv-2.11.1.so 006f0000-006f2000 rw-p 00000000 00:00 0 0071b000-00727000 r-xp 00000000 fd:01 126034 /opt/ibm/db2/V9.5/lib32/libdb2locale.so.1 00727000-0072d000 rw-p 0000b000 fd:01 126034 /opt/ibm/db2/V9.5/lib32/libdb2locale.so.1 007a3000-007a5000 r-xp 00000000 fd:01 41599 /usr/lib/python2.6/lib-dynload/fcntlmodule.so 007a5000-007a6000 rw-p 00002000 fd:01 41599 /usr/lib/python2.6/lib-dynload/fcntlmodule.so 007c0000-007c5000 r-xp 00000000 fd:01 22252 /lib/libnss_dns-2.11.1.so 007c5000-007c6000 r--p 00004000 fd:01 22252 /lib/libnss_dns-2.11.1.so 007c6000-007c7000 rw-p 00005000 fd:01 22252 /lib/libnss_dns-2.11.1.so 00896000-0089e000 r-xp 00000000 fd:01 45884 /usr/lib/python2.6/lib-dynload/itertoolsmodule.so 0089e000-008a1000 rw-p 00008000 fd:01 45884 /usr/lib/python2.6/lib-dynload/itertoolsmodule.so 009c7000-009ca000 r-xp 00000000 fd:01 45876 /usr/lib/python2.6/lib-dynload/cStringIO.so 009ca000-009cb000 rw-p 00003000 fd:01 45876 /usr/lib/python2.6/lib-dynload/cStringIO.so 009cf000-009d6000 r-xp 00000000 fd:01 45867 /usr/lib/python2.6/lib-dynload/_struct.so 009d6000-009d8000 rw-p 00006000 fd:01 45867 /usr/lib/python2.6/lib-dynload/_struct.so 009da000-009df000 r-xp 00000000 fd:01 41578 /usr/lib/python2.6/lib-dynload/_multiprocessing.so 009df000-009e0000 rw-p 00004000 fd:01 41578 /usr/lib/python2.6/lib-dynload/_multiprocessing.so 009e1000-009e8000 r-xp 00000000 fd:01 125999 /opt/ibm/db2/V9.5/lib32/libdb2trcapi.so.1 009e8000-009ea000 rw-p 00007000 fd:01 125999 /opt/ibm/db2/V9.5/lib32/libdb2trcapi.so.1 00a3a000-00a3b000 r-xp 00000000 fd:01 45870 /usr/lib/python2.6/lib-dynload/_weakref.so 00a3b000-00a3c000 rw-p 00000000 fd:01 45870 /usr/lib/python2.6/lib-dynload/_weakref.so 00b5f000-00b66000 r-xp 00000000 fd:01 41609 /usr/lib/python2.6/lib-dynload/operator.so 00b66000-00b68000 rw-p 00006000 fd:01 41609 /usr/lib/python2.6/lib-dynload/operator.so 00c06000-00c0e000 r-xp 00000000 fd:01 93181 /usr/lib/python2.6/site-packages/_db2.so 00c0e000-00c0f000 rw-p 00007000 fd:01 93181 /usr/lib/python2.6/site-packages/_db2.so 00c58000-00c5c000 r-xp 00000000 fd:01 45893 /usr/lib/python2.6/lib-dynload/stropmodule.so 00c5c000-00c5e000 rw-p 00004000 fd:01 45893 /usr/lib/python2.6/lib-dynload/stropmodule.so 00c86000-00c8c000 r-xp 00000000 fd:01 41562 /usr/lib/python2.6/lib-dynload/_collectionsmodule.so 00c8c000-00c8d000 rw-p 00005000 fd:01 41562 /usr/lib/python2.6/lib-dynload/_collectionsmodule.so 00ca4000-00cca000 r-xp 00000000 fd:01 126023 /opt/ibm/db2/V9.5/lib32/libdb2osse_db2.so.1 00cca000-00cd3000 rw-p 00026000 fd:01 126023 /opt/ibm/db2/V9.5/lib32/libdb2osse_db2.so.1 00cfb000-00d22000 r-xp 00000000 fd:01 126002 /opt/ibm/db2/V9.5/lib32/libdb2genreg.so.1 00d22000-00d2e000 rw-p 00026000 fd:01 126002 /opt/ibm/db2/V9.5/lib32/libdb2genreg.so.1 00d8c000-00da9000 r-xp 00000000 fd:01 9410 /lib/libgcc_s-4.4.3-20100127.so.1 00da9000-00daa000 rw-p 0001c000 fd:01 9410 /lib/libgcc_s-4.4.3-20100127.so.1 00e94000-00e96000 r-xp 00000000 fd:01 30840 /lib/libnss_mdns4_minimal.so.2 00e96000-00e97000 rw-p 00001000 fd:01 30840 /lib/libnss_mdns4_minimal.so.2 00ec5000-00ec6000 r-xp 00000000 00:00 0 [vdso] 00ecb000-00ed6000 r-xp 00000000 fd:01 22253 /lib/libnss_files-2.11.1.so 00ed6000-00ed7000 r--p 0000a000 fd:01 22253 /lib/libnss_files-2.11.1.so 00ed7000-00ed8000 rw-p 0000b000 fd:01 22253 /lib/libnss_files-2.11.1.so 00ed8000-00f9c000 r-xp 00000000 fd:01 125988 /opt/ibm/db2/V9.5/lib32/icc/osslib/libcrypto.so.0.9.7 00f9c000-00fac000 rw-p 000c4000 fd:01 125988 /opt/ibm/db2/V9.5/lib32/icc/osslib/libcrypto.so.0.9.7 00fac000-00faf000 rw-p 00000000 00:00 0 00fce000-00fd2000 r-xp 00000000 fd:01 45873 /usr/lib/python2.6/lib-dynload/binascii.so 00fd2000-00fd3000 rw-p 00004000 fd:01 45873 /usr/lib/python2.6/lib-dynload/binascii.so 00ffa000-00ffc000 r-xp 00000000 fd:01 45894 /usr/lib/python2.6/lib-dynload/syslog.so 00ffc000-00ffd000 rw-p 00001000 fd:01 45894 /usr/lib/python2.6/lib-dynload/syslog.so 00ffd000-01a7a000 r-xp 00000000 fd:01 126035 /opt/ibm/db2/V9.5/lib32/libdb2.so.1 01a7a000-01d66000 rw-p 00a7d000 fd:01 126035 /opt/ibm/db2/V9.5/lib32/libdb2.so.1 01d66000-029f9000 rw-p 00000000 00:00 0 029f9000-0303f000 r-xp 00000000 fd:01 126017 /opt/ibm/db2/V9.5/lib32/libdb2g11n.so.1 0303f000-03058000 rw-p 00645000 fd:01 126017 /opt/ibm/db2/V9.5/lib32/libdb2g11n.so.1 03058000-03059000 rw-p 00000000 00:00 0 060c9000-06224000 r-xp 00000000 fd:01 19240 /usr/lib/libpython2.6.so.1.0 06224000-06250000 rw-p 0015a000 fd:01 19240 /usr/lib/libpython2.6.so.1.0 06250000-06259000 rw-p 00000000 00:00 0 08048000-08049000 r-xp 00000000 fd:01 16275 /usr/bin/python 08049000-0804a000 rw-p 00000000 fd:01 16275 /usr/bin/python 092d2000-09536000 r-xp 00000000 fd:01 126010 /opt/ibm/db2/V9.5/lib32/libdb2osse.so.1 09536000-0958d000 rw-p 00263000 fd:01 126010 /opt/ibm/db2/V9.5/lib32/libdb2osse.so.1 0958d000-0958f000 rw-p 00000000 00:00 0 09848000-09a43000 rw-p 00000000 00:00 0 [heap] b741d000-b753d000 rw-p 00000000 00:00 0 b753d000-b753e000 r--p 02c7d000 fd:01 91590 /usr/lib/locale/locale-archive b753e000-b757a000 r--p 02c24000 fd:01 91590 /usr/lib/locale/locale-archive b757a000-b777a000 r--p 00000000 fd:01 91590 /usr/lib/locale/locale-archive b777a000-b77bd000 rw-p 00000000 00:00 0 b77d6000-b77d7000 rw-p 00000000 00:00 0 bff71000-bff95000 rwxp 00000000 00:00 0 [stack] bff95000-bff96000 rw-p 00000000 00:00 0 |
From: Dan S. <dan...@gm...> - 2009-04-14 04:24:35
|
I've tried unsuccessfully to use PyDB2 with py2exe. In my code I have a standard connection string but when the code is executed the containing frame just disappears. It's as if there's something missing that py2exe is not detecting. As you may know py2exe only scans Python code, not C/C++ code, so it cannot determine what code PyDB2 imports. I'd sure appreciate it if someone could tell me what I'm missing. BTW, everything works fine when running my code within Eclipse (using PyDev) or when executing 'python my_prog.py' at a DOS prompt. |
From: Brent S. E. <we...@ai...> - 2009-04-06 15:58:27
|
It looks to me like the file that the command writes to is on the server machine. Whereas when I just run the export command from the command line I can write to my client machine. The only access I have to the server machine is db2 access. So, the only directory I can write to using the admin_cmd is /tmp on the server which doesn't do me much good. I have changed my python code to fetch all of the records and then manually write the data to the file where I want it on the client machine. Thanks, Brent On Mon, 2009-04-06 at 17:02 +0200, len...@la... wrote: > > So how do I use the admin_cmd procedure from pydb2? > > Never tried it myself so I made up a rather silly example. Note how one > have to quote string literals inside the sql string sent to admin_cmd: > > [db2inst1@wbv9 ~]$ rm -f /tmp/TT.ixf > [db2inst1@wbv9 ~]$ cat admin_cmd_example.py > #!/usr/bin/python > > import DB2 > import sys > > dbname = sys.argv[1] > username = sys.argv[2] > passwd = sys.argv[3] > > conn = DB2.connect(dsn=dbname, uid=username, pwd=passwd) > > c1 = conn.cursor() > c1.execute("call sysproc.admin_cmd('export to /tmp/TT.ixf of ixf select x > from lateral(values (''a'')) T (x)')") > for row in c1.fetchall(): > print row > > > [db2inst1@wbv9 ~]$ ./admin_cmd_example.py <yourdb> <youruser> <yourpasswd> > (1L, None, None) > [db2inst1@wbv9 ~]$ ls -l /tmp/TT.ixf > -rw-r--r-- 1 db2fenc1 db2fadm1 2768 Apr 6 16:57 /tmp/TT.ixf > > > HTH > /Lennart > > > ------------------------------------------------------------------------------ > _______________________________________________ > PyDB2-discuss mailing list > PyD...@li... > https://lists.sourceforge.net/lists/listinfo/pydb2-discuss |
From: <len...@la...> - 2009-04-06 15:03:06
|
> So how do I use the admin_cmd procedure from pydb2? Never tried it myself so I made up a rather silly example. Note how one have to quote string literals inside the sql string sent to admin_cmd: [db2inst1@wbv9 ~]$ rm -f /tmp/TT.ixf [db2inst1@wbv9 ~]$ cat admin_cmd_example.py #!/usr/bin/python import DB2 import sys dbname = sys.argv[1] username = sys.argv[2] passwd = sys.argv[3] conn = DB2.connect(dsn=dbname, uid=username, pwd=passwd) c1 = conn.cursor() c1.execute("call sysproc.admin_cmd('export to /tmp/TT.ixf of ixf select x from lateral(values (''a'')) T (x)')") for row in c1.fetchall(): print row [db2inst1@wbv9 ~]$ ./admin_cmd_example.py <yourdb> <youruser> <yourpasswd> (1L, None, None) [db2inst1@wbv9 ~]$ ls -l /tmp/TT.ixf -rw-r--r-- 1 db2fenc1 db2fadm1 2768 Apr 6 16:57 /tmp/TT.ixf HTH /Lennart |
From: Brent S. E. <we...@ai...> - 2009-04-06 14:21:23
|
So how do I use the admin_cmd procedure from pydb2? I tried import DB2 conn = DB2.connect(... curs = conn.cursor() Then I assume curs.execute(something). But what would the exact syntax be to try admin_cmd on the following statement? export to /home/brente/file.del of del select * from schema.table where working = 'PREVIOUS' for read only My db2 client is 8.2 and the db2 server I am connecting to is 9.2. On Sun, 2009-04-05 at 17:47 +0200, len...@la... wrote: > > > Can pydb2 handle an export command in an execute statement? > > export is not part of sql so that wont work. You don't mention which > version of db2 you are running, but at least for 9.5 you should be able to > run export via the admin_cmd procedure: > > http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.sql.rtn.doc/doc/r0012547.html?resultof=%22%61%64%6d%69%6e%5f%63%6d%64%22%20 > > Not sure of earlier versions, and I haven't tried it myself though. > > HTH > /Lennart > > [...] > > > > > > > > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > PyDB2-discuss mailing list > > PyD...@li... > > https://lists.sourceforge.net/lists/listinfo/pydb2-discuss > > > |
From: <len...@la...> - 2009-04-05 16:06:59
|
> Can pydb2 handle an export command in an execute statement? export is not part of sql so that wont work. You don't mention which version of db2 you are running, but at least for 9.5 you should be able to run export via the admin_cmd procedure: http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.sql.rtn.doc/doc/r0012547.html?resultof=%22%61%64%6d%69%6e%5f%63%6d%64%22%20 Not sure of earlier versions, and I haven't tried it myself though. HTH /Lennart [...] > > > > ------------------------------------------------------------------------------ > _______________________________________________ > PyDB2-discuss mailing list > PyD...@li... > https://lists.sourceforge.net/lists/listinfo/pydb2-discuss > |
From: Brent S. E. <we...@ai...> - 2009-04-03 15:57:50
|
Can pydb2 handle an export command in an execute statement? When I use the execute statement on an export command I get the following error: Error('42601', -104, '[IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "EXPORT TO /home/brente/supply_load/MDCP_TES" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<space>". SQLSTATE=42601\n') Here is the sql statement I am trying to execute: EXPORT TO /home/brente/supply_load/MDCP_TEST/ALLOC.PREV.3 OF DEL SELECT * FROM ATPGUI.WORK_ALLOC_TAB WHERE WORKING = 'PREVIOUS' FOR READ ONLY If I run the export statement directly in db2 from the command line it works. I have no problems with select statements in the execute command. I thought execute was supposed to execute any valid sql. Any ideas? |
From: Gregory G. <gr...@sn...> - 2009-02-24 23:58:37
|
Hi all, When a GRAPHIC type is retrieved, the result is almost always an empty string. Which is because, of course, GRAPHIC is a double-byte char, and something like "ABC" would be returned as 0x00 0x41 0x00 0x42 0x00 0x43 and when PyString_AsString() is called, it appears to it that the string terminates right there in the first byte. (I am talking about the case SQL_C_DBCHAR in _db2_module.c). I hesitated to file a bug, because perhaps this problem goes away is compiled with wide character support? But I haven't had any luck, not that I know much about Python internals either. Any thoughts? -Greg |
From: Jan P. <pa...@gm...> - 2009-02-20 20:28:28
|
Hi everybody, My name is Jan Palach, i`m a brazilian developer, and i need to set TRANSACTION_READ_UNCOMMITTED isolation level when i create my connection using pyDB2. So, how i do that? Sorry, my english is very bad :), but i try :) .... Jan Palach Development ( Backend / Agents ) Development center - Rio de Janeiro www.virtus-ti.com.br |
From: <Har...@ga...> - 2008-12-31 18:52:49
|
Hi I need a win32 binary of PyDB2_1.1.1-1 for Python 2.6 What are the plans for Python 3.0? Thanks in advance |
From: Marcin K. <mr...@gm...> - 2008-08-26 16:06:55
|
Hello everyone, First, thanks for developing this thing! Then, is there a way to connect to remote DB2 instance over TCP/IP using PyDB2? I didn't find any tutorial that would show how to do it. Regards, Marcin |
From: Mynthon <myn...@gm...> - 2008-08-04 14:49:50
|
when executing: >>> c.fetchone() (or any other fetch...()) i get error: Traceback (most recent call last): File "<stdin>", line 1, in <module> File "C:\Python25\lib\site-packages\DB2.py", lin if type(r[i]) == TupleType: ValueError: invalid literal for float(): 0,00000 im not sure but it may be caused by locale set for db2 - i my case it is float with comma (eg. 0,5 instead of 0.5) I'm a python newbie and dont know how to resolve that problem. Any ideas? I have no acces to db2 settings so for me it is impossible to change db2 setting (even if it is possible to change float "settings") best regards. |
From: Troels A. <tr...@ar...> - 2008-06-15 13:56:07
|
Hello, When using DB2's command line processor, the user doesn't have to specify username/password when connecting to a DB2 on the same host as the user is logged on to. Username/password is only needed if connecting through a network connection (or if the username in DB2 is different from the user logged on to the server). I would like to be able to do the same with PyDB2: Is there a way to use DB2.connect() in a way where username/password doesn't have to be specified? -- Regards, Troels Arvin <tr...@ar...> http://troels.arvin.dk/ |
From: Eunsoo P. <eun...@ho...> - 2008-06-02 15:37:37
|
Hi, I've been using pyDB2 and editing here and there, just to get additional support for the features that I need. I never worked on open source code before so I don't really know about editing and sharing etiquette for this, so pardon me if I'm doing anything wrong. Attached is edited version of _db2_module.c and _db2_module.h - I just moved it to .h just to reduce .c size. - and DB2.py which supports, 1. procedure calling 2. large LOB support thru file handle. 3. scrollable cursor Usage for number 1 is unchaned. For large LOB support, here is the sample code. import os import DB2 f = open( 'sample.jpg' ) data = f.read() f.close() conn = DB2.connect( dsn='test', uid='testuser', pwd='testpass') curs = conn.cursor() curs.execute( 'INSERT INTO test(Data) values(?)", data ) ; curs.close() conn.close() scrollable cursor, you'll need to set bScrollable = 1 in cursor creation. Only static cursor is supported. import DB2 conn = DB2.connect( dsn='test', uid='testuser', pwd='testpass') curs = conn.cursor(bScrollable=1) curs.execute( 'select * from test') curs.fetchscroll( size=10, orient = 5, offset = 5 ) # this will get you record set size of 10, starting from offset 5 from absolute position ( SQL_FETCH_ABSOLUTE ). scrollable cursor will be a bit slower than non-scrollable cursor, but good thing with that is, SQLRowCount will return row count for SELECT command with scrollable cursor. Thanks, Eunsoo Park |
From: Rumbalski, S. (Dublin) <ser...@ch...> - 2008-05-21 20:16:22
|
I just switched from using a generic ODBC connection to using PyDB2. For the most part the transition was painless, but I encountered some trouble. With the old library I would only maintain a reference to the cursor, but not to the connection object. When I tried this with PyDB2 I got an error: Error: ('I', -1, 'Invalid Handle'). I fixed this by keeping a reference to the connection object. Apparently the cursor object does not keep a reference to the connection object, so when I call cur.execute(query_text), the connection object has been garbage collected. Is this correct behavior? It seems like a usability bug, if not an actual one. Steven Rumbalski Data Analyst, E-Banking Services CheckFree - now part of Fiserv Phone: 614.564.4198 Fax: 614.564.3570 http://www.checkfree.com<http://www.checkfree.com/> |
From: gongjingqun <gon...@ba...> - 2008-03-31 05:42:50
|
Hey, :This email responses the topic "PyDB2-discuss] db2 callproc error" because of Email Archive: pydb2-discuss showing to me read-only. I just use following test case coming from ./PyDB21.1.1/test/test_basic.py: import DB2 db = DB2.connect(dsn=db,uid=usr,pwd=ps) cur = db.cursor() cur.execute( """CREATE PROCEDURE CP_TEST_1 (IN P1 CHAR(5), OUT P2 VARCHAR(5), INOUT P3 INTEGER) LANGUAGE SQL BEGIN SET P2 = 'YYY'; SET P3 = 3; END""") db.commit() params = ( 'XXXXX', None, 1 ) r = self.cs.callproc('CP_TEST_1', params) To make sure of the procedure,i call it under the administrator mode: >db2 >connect to db usr usr using ps >call CP_TEST_1('XXXXX',None,1) and its ok. Then ,i installed the old version of v1.1.0-3, it also doesn't work. Thanks! |
From: Jon T. <jon...@gm...> - 2008-03-30 18:29:22
|
Hey, there's a known bug that if you call a proc that's not in the default schema, it fails. Could that be your problem? There is a fix in an old revision 1.10, which I haven't merged into the current revision. Let me know if that could be your problem, or if not, maybe you could submit a code sample to reporduce your problem? Thanks, Jon On Thu, Mar 27, 2008 at 7:08 AM, gongjingqun <gon...@ba...> wrote: > > > > Hi, > > python: 2.4.1 > OS: AIX5.3 > DB2: 8.2 > PyDB2:1.1 > I got a problem when calling db2 stored procedure: > > Traceback (most recent call last): > File "<stdin>", line 1, in ? > File "DB2.py", line 170, in callproc > return self._sql_execute(self._cs.callproc, procname, *args) > File "DB2.py", line 160, in _sql_execute > return func(what, *(args, )) > _db2.Error: ('?', -1, 'SQLGetDiagRec() failed') > > By the way, it works ok when calling other sql codes like insert / > create / delete /update and so on. > > In my mind,callproc is a basic function.so maybe i made a smally foolish > mistake.but what it is? > > Need you help! > > AKA.MG > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > PyDB2-discuss mailing list > PyD...@li... > https://lists.sourceforge.net/lists/listinfo/pydb2-discuss > > |
From: gongjingqun <gon...@ba...> - 2008-03-27 07:09:19
|
Hi, python: 2.4.1 OS: AIX5.3 DB2: 8.2 PyDB2:1.1 I got a problem when calling db2 stored procedure: Traceback (most recent call last): File "<stdin>", line 1, in ? File "DB2.py", line 170, in callproc return self._sql_execute(self._cs.callproc, procname, *args) File "DB2.py", line 160, in _sql_execute return func(what, *(args, )) _db2.Error: ('?', -1, 'SQLGetDiagRec() failed') By the way, it works ok when calling other sql codes like insert / create / delete /update and so on. In my mind,callproc is a basic function.so maybe i made a smally foolish mistake.but what it is? Need you help! AKA.MG |
From: Jon T. <jon...@gm...> - 2008-03-19 11:14:27
|
Hi, Sorry about taking my time to respond, I've not had much free time. I have a few questions: 1) what is DDL statement used to create this table? I'm guessing something like CREATE TABLE Table1 (Column1 LONG VARCHAR FOR BIT DATA) ; Is that correct? 2) What codepage and region do you have set for your db? What is the locale on the db computer? 3) Are you setting the value of the column from python? If so, can you show me a code snippet, that shows how you're setting the value? Thanks a lot, Jón 2008/2/27 SERXIO BARRAL PAN/ Generali-España <s.b...@ge...>: > > Hi! > > I'm struggling to retrieve a LONGVARBINARY column with pydb2 module. By > using several fetchone(), or one fetchall() I get several 32000 bytes chunks > that are the ascii hex representation of the binary data in the database. > The problem is that I should be getting chunks of 32000 bytes being them the > real binary data, not its ascii hex double-byte representation. And of > course, If I translate these ascii data to the binary data, I do have just > 16000 bytes, missing 16000 more. > > I'm using pydb2 1.1.1 > |
From: Nils L. <nil...@gm...> - 2008-03-14 09:42:05
|
Is there any way to determine if the driver is connected to the database? If I create the connection fra pydb2, force the connection in DB2 I may create a cursor (even though it has just been forced) but when I cursor.execute(sql) I get the expected (connection closed). I may of course make the test my self using a try-except but it is not very neat. In other API's I have a isConnected()... Nils |
From: SERXIO B. P. Generali-E. <s.b...@ge...> - 2008-02-27 14:44:54
|
Hi! I'm struggling to retrieve a LONGVARBINARY column with pydb2 module. By using several fetchone(), or one fetchall() I get several 32000 bytes chunks that are the ascii hex representation of the binary data in the database. The problem is that I should be getting chunks of 32000 bytes being them the real binary data, not its ascii hex double-byte representation. And of course, If I translate these ascii data to the binary data, I do have just 16000 bytes, missing 16000 more. I'm using pydb2 1.1.1 Any help will be greatly appreciated! Regards, Serxio Barral. --------------- AVISO LEGAL Le informamos, como destinatario de este mensaje, que el correo electrónico y las comunicaciones por medio de Internet no permiten asegurar ni garantizar la confidencialidad de los mensajes transmitidos, así como tampoco su integridad o su correcta recepción, por lo que el emisor no asume responsabilidad alguna por tales circunstancias. La información contenida en este mensaje de correo electrónico y, en su caso, en cualquier fichero anexo al mismo, tiene carácter reservado y confidencial y sujeta al secreto profesional para uso exclusivo de su destinatario o destinatarios, por lo que su divulgación, copia o distribución a terceros están expresamente prohibidas por la Ley. En el caso de haber recibido este mensaje por error se ruega comunicarlo inmediatamente mediante reenvío a la dirección electrónica del remitente, eliminándolo a continuación. |
From: Jon T. <jon...@gm...> - 2008-02-19 00:08:32
|
New release is up and tested on win32 and Suse Linux 9.1. On Feb 18, 2008 11:31 PM, Jon Thoroddsen <jon...@gm...> wrote: > Ok, I've setup linux so that we don't have this sort of mess again. > There was a compilation warning about an implicit declaration of max :-/ > > I'll have a new release v. soon. > Jón > > > > On Feb 18, 2008 10:03 PM, Jon Thoroddsen <jon...@gm...> wrote: > > I find this a bit odd to say the least. > > Did it link without errors? > > Anyway it's easy enough to get rid of this, I'll get a new release out > > soon that doesn't use max. > > Could I send it to you direct, so you can verify before I release? > > > > regards, > > Jón > > > > > > On Feb 18, 2008 5:15 PM, Bolli Palmason <hro...@ya...> wrote: > > > Hello, > > > > > > I've installed the DB2 Application Development Client on linux (v. 8.1) and version 1.1.1 of PyDB2, but > > > when I try to import DB2 I get the following error: > > > > > > Python 2.5.1 (r251:54863, May 4 2007, 16:52:23) > > > [GCC 4.1.2] on linux2 > > > Type "help", "copyright", "credits" or "license" for more information. > > > >>> import DB2 > > > Traceback (most recent call last): > > > File "<stdin>", line 1, in <module> > > > File "/usr/lib/python2.5/site-packages/DB2.py", line 12, in <module> > > > import _db2 > > > ImportError: /usr/lib/python2.5/site-packages/_db2.so: undefined symbol: max > > > >>> > > > > > > > > > Thanks in adv. > > > Bolli > > > > > > |
From: Jon T. <jon...@gm...> - 2008-02-18 23:31:31
|
Ok, I've setup linux so that we don't have this sort of mess again. There was a compilation warning about an implicit declaration of max :-/ I'll have a new release v. soon. Jón On Feb 18, 2008 10:03 PM, Jon Thoroddsen <jon...@gm...> wrote: > I find this a bit odd to say the least. > Did it link without errors? > Anyway it's easy enough to get rid of this, I'll get a new release out > soon that doesn't use max. > Could I send it to you direct, so you can verify before I release? > > regards, > Jón > > > On Feb 18, 2008 5:15 PM, Bolli Palmason <hro...@ya...> wrote: > > Hello, > > > > I've installed the DB2 Application Development Client on linux (v. 8.1) and version 1.1.1 of PyDB2, but > > when I try to import DB2 I get the following error: > > > > Python 2.5.1 (r251:54863, May 4 2007, 16:52:23) > > [GCC 4.1.2] on linux2 > > Type "help", "copyright", "credits" or "license" for more information. > > >>> import DB2 > > Traceback (most recent call last): > > File "<stdin>", line 1, in <module> > > File "/usr/lib/python2.5/site-packages/DB2.py", line 12, in <module> > > import _db2 > > ImportError: /usr/lib/python2.5/site-packages/_db2.so: undefined symbol: max > > >>> > > > > > > Thanks in adv. > > Bolli > > > |