Hi,
I am trying to create a stored procedure from DB 8.0 control center and I am getting the following error.
SQL0104N An unexpected token "END-OF-STATEMENT" was found
following "END P1 ". Expected tokens may include: "JOIN
<joined_table>
However the same...
Hi Elena,
Set the following registry variable
"DB2_SQLROUTINE_COMPILER_PATH"
as below
db2set DB2_SQLROUTINE_COMPILER_PATH="D:\Micros~1\vc98\bin\vcvars32.bat"
it should point to vcvars32.bat.
Then build the stored proc.
hope it will work.
Sandip
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.