[Sqlrelay-discussion] SQLRelay 0.35 + Perl API + DB2

[Lee S. <st...@st...>]

Hey Guys,

I've been trying to get SQLRelay 0.35 working with DB2, and now that I finally got it to connect, I'm having trouble with the Perl API munging the SQL into an invalid format.   Here's an example:

Original SQL: SELECT oid FROM service WHERE oid=?
Perl API Query: SELECT oid FROM service WHERE oid=:1
Error: [IBM][CLI Driver][DB2/LINUX] SQL0312N  The host variable "1" is used in a dynamic SQL statement, a view definition, or a trigger definition.

This is just a simple query I've tried to replicate the issue, but it obviously happens with any.

SQLRelay 0.35
Client Version: 8.1.0.48 (Fixpak 5)

Note: This works perfectly fine if I bypass the SQLRelay server and go direct to the database.

So I have two quick questions:

1.       Is this a known issue which has been fixed in a later version? (I'd try this, but newer versions won't build on my OS without serious hacky library updates)

2.       If this is not fixed, is there a patch floating around I can apply to 0.35 to make this work?

Thanks J