Re: SQLProcedureColumns ()

Huw G wrote in message <38f479f8.0@nnrp1.news.uk.psi.net>... >Does anyone know how to mimic this ODBC SDK function call to an Informix >database. (As a start point, I can mimic the function SQLProcedures () by >selecting various columns from the table "informix".sysprocedures). > >Thanks in advance. > >Huw > RTBM. Must use the statement "select procid, data from sysprocbody where datakey = 'T'", and parse the resulting text. I will let you all know how much fun this was.

Huw G wrote in message <38f70485.0@nnrp1.news.uk.psi.net>... > >Huw G wrote in message <38f479f8.0@nnrp1.news.uk.psi.net>... >>Does anyone know how to mimic this ODBC SDK function call to an Informix >>database. (As a start point, I can mimic the function SQLProcedures () by >>selecting various columns from the table "informix".sysprocedures). >> >>Thanks in advance. >> >>Huw >> >RTBM. Must use the statement "select procid, data from sysprocbody where >datakey = 'T'", and parse the resulting text. I will let you all know how >much fun this was. > 400 lines of code later, reasonably bomb-proof extraction. This has to fit inside a much larger ODBC Driver, and there is much fun to be had returning the column definitions to this. I regret that I can't make the code available to the public - it is company coptyright.