Hi,

I am trying to find a database with support for the ODBC function
SQLDescribeParam. Hopefully a DB I can run on my Linux box.

I have looked at PostgreSQL and MySQL. Neither of them supports
SQLDescribeParam. PostgreSQL returns that it do not support this
function (at least that was all I could get it to do). MySQL returns
VarCHAR(255) for every parameter. Bug report here http://bugs.mysql.com/bug.php?id=1382.

From http://publib.boulder.ibm.com/infoce...cribeparam.htm
and here http://www.easysoft.com/support/kb/kb00755.html I gather that
DB2 and Oracle do not have support SQLDescribeParam either. Well DB2
on mainframe supports SQLDescribeParam, but that is not an option.

I also tried SQLite but it returns SqlWLongVarCharT for every
parameter.

So, which databases supports SQLDescribeParam?


Greetings,

Mads Lindstrøm

Mads wrote:

I am confused - did you look at this:


For DB2 V8.2:
http://publib.boulder.ibm.com/infoce...d/r0000582.htm

For DB2 V9.1:
http://publib.boulder.ibm.com/infoce...c/r0000582.htm

For DB2 V9.5:
http://publib.boulder.ibm.com/infoce.../r0000582.html


Certainly DB2 - IBM Database Sever for Linux, Windows and Unix supports
SQLDescribeParam().


Jan M. Nelken

Mads wrote:

I am confused - did you look at this:


For DB2 V8.2:
http://publib.boulder.ibm.com/infoce...d/r0000582.htm

For DB2 V9.1:
http://publib.boulder.ibm.com/infoce...c/r0000582.htm

For DB2 V9.5:
http://publib.boulder.ibm.com/infoce.../r0000582.html


Certainly DB2 - IBM Database Sever for Linux, Windows and Unix supports
SQLDescribeParam().


Jan M. Nelken

Mads wrote:

I am confused - did you look at this:


For DB2 V8.2:
http://publib.boulder.ibm.com/infoce...d/r0000582.htm

For DB2 V9.1:
http://publib.boulder.ibm.com/infoce...c/r0000582.htm

For DB2 V9.5:
http://publib.boulder.ibm.com/infoce.../r0000582.html


Certainly DB2 - IBM Database Sever for Linux, Windows and Unix supports
SQLDescribeParam().


Jan M. Nelken

Hi,

On 25 Maj, 22:22, "Jan M. Nelken" <Unknown.U... (AT) Invalid (DOT) Domain> wrote:
Yes, I was wrong. I misread IBM's documentation. Thank you very much
for clearing it up.


Greetings,

Mads

Hi,

On 25 Maj, 22:22, "Jan M. Nelken" <Unknown.U... (AT) Invalid (DOT) Domain> wrote:
Yes, I was wrong. I misread IBM's documentation. Thank you very much
for clearing it up.


Greetings,

Mads

Hi,

On 25 Maj, 22:22, "Jan M. Nelken" <Unknown.U... (AT) Invalid (DOT) Domain> wrote:
Yes, I was wrong. I misread IBM's documentation. Thank you very much
for clearing it up.


Greetings,

Mads