I am running windows 7 professional (64 Bit) with the 64 bit version
of DB2 9.7.4. I am using the 32 bit version of Oorexx 4.1.0. I have
moved several programs from an old machine that
was using the 32 bit version of Oorexx 4.0, DB2 version 8.1. , and
Windows XP.

When I attempt to run a program that uses DB2, I get a message that
says:

"The procedure entry point ?sqlrxf2a@@YAPADPAXHPAEH@Z could not
be located in the dynamic link library DB2SYS.dll."

This error seems to be related to the loading of the DB2 functions. I
have noticed
that if I continue on with the program, I get another error say that
the SQLEXEC
routine can not be found. I have added below the call to get the DB2
functions
added.

I am using the 32 bit Oorexx since all the other machines in the
office still run
32 bit operating systems.

Any help would be appriciated. Thank you.

Call to load DB2 functions
if RxFuncquery('SQLDBS') <> 0 then
do
rcy = RxFuncAdd('SQLDBS','DB2AR','SQLDBS')
if rcy \= 0 then
do
say 'SQLDBS was not successfully added to the REXX
environment.'
exit
end
end

if RxFuncquery('SQLDB2') <> 0 then
do
rcy = Rxfuncadd('SQLDB2','DB2AR','SQLDB2')
if rcy \= 0 then
do
say 'SQLDB2 was not successfully added to the REXX
environment.'
exit
end
end

if RxFuncquery('SQLEXEC') <> 0 then
do
rcy = Rxfuncadd('SQLEXEC','DB2AR','SQLEXEC')
if rcy \= 0 then
do
say 'SQLEXEC was not successfully added to the REXX
environment.'
exit
end
end

It seems like you DB2 Runtime client is missing a library or is
otherwise not properly installed.

Best to open a PMR.

Cheers
Serge


--
Serge Rielau
SQL Architect DB2 for LUW, IBM Toronto Lab
Blog: tinyurl.com/SQLTips4DB2
Wiki: tinyurl.com/Oracle2DB2Wiki
Twitter: srielau

On May 12, 10:20*am, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:
How do I open a PMR?

I have removed 64 bit DB2 and installed the 32 bit DB2. I also removed
and reinstalled the 32 bit
OORexx. All to no avail.

Paul Yohn