-
assigned issue to
ODBC transport doesn't work
There are a couple of small fixes needed to bring it up to minimal functionality:
-
On the cursor
execute
(currently line 111 iniodbccall.py
),ipc
andclt
are undefined. They need to beself.ipc
andself.ctl
, respectively. (Note the flipping of letters in the latter.) -
The "rows" being returned are true database rows (as you would expect from PEP 249) so they cannot be directly appended to the XML output string. You have to get the first (and only) element, which is a string, and strip off the nulls (currently line 116):
xml_out += row[0].rstrip('\x00')
When I made those changes, the simple iCmd example (with RTVJOBA) worked.
Comments (3)
-
-
FYI, I improved the iDB2Call transport in bacc74170264043f13c4eca662e0bc6b075a1546 to support passing a PEP-249 compliant driver. Theoretically you could implement XMLSERVICE in any DBMS and it would work, thus the "iDB2Call" name is a misnomer and ideally would be fixed. Along with that change, I'd propose fixing
#1and just have a "DatabaseCall" or similar name. Leave modules with the old names that merely load and re-export the ones in the right location. -
- changed status to resolved
Migrated to https://github.com/IBM/python-itoolkit/issues/15
- Log in to comment