"Nyul" <ny***@largon.hu> wrote in message news:<qF*********************@news.chello.at>...
<snip>
We have a DB2 V6.1.0 on AIX 4.3
The development server was an UDB V6.1.0 on W2K.
Warning: odbc_execute(): SQL error: [IBM][CLI Driver][DB2/6000] SQL10010N
The specified library, "sbprogs1", was loaded, but the function
"S_GetProductList" could not be executed. , SQL state S1000 in SQLExecute
<snip>
You say it Works OK in Windows , but fails on AIX 4.3.
What were the command-line options/switches that you gave
to the "ld" program (or "cc" ) on AIX ?
Did you verify that the executable really contains an
exported symbol identical to what you expect ?
(On AIX, Use commands "dump" (with options) and "nm" (with options)
to help in this area).
If you cannot get it to work with *your* stored procedure
on AIX, then verify that you can get the IBM supplied sample
stored procedures to work on AIX (with the sample database).
If you still cannot proceed, use DIAGLEVEL 4, and retry, then
check the most recent messages in db2diag.log to see if it
gives any more details. But in my opinion it seems likely
to be a build problem.
Good luck.