RPG Embedded SQL connect to PC Websphere db

When I'm in interactive SQL (strsql), I can connect to the PC Websphere
db by doing:
       connect to webdev user username using 'password'
(I then see it change data refresh from *always to *forward, commit from
*none to *cs, allow copy data from *yes to *optimize, naming from *sys
to *sql, datfmt from *mdy to *usa, and timfmt from *hms to *jis.)
>From there I can then interact with the database.
 
But in RPG, I'm having issues connecting.
I'm attempting to emulate the parenthetical above (the allow copy data
is the compile default, and I don't know how to change the refresh to
*forward).
C/EXEC SQL

C+ Set Option COMMIT =*CS, NAMING =*SQL, DATFMT =*USA, TIMFMT =*JIS

C/END-EXEC
 
I issue the connect (the host variables are all defined as 10a):
C/EXEC SQL
C+ Connect To :rdb User :userid Using :pw
C/END-EXEC
I then get SQL0862
"Local program attempted to connect to a remote relational database."
The recovery says to use the RDB parameter on the compile.  I'd rather
not because the relational database I'm connecting to is different
depending on what box this program is running on.
 
v5r2
 
Thanks for any help, and feel free to ask me about any information I
forgot to mention.
 
Kurt Anderson
Application Developer
Highsmith Inc.
W5527 State Road 106, P.O. Box 800
Fort Atkinson, WI 53538-0800
TEL (920) 563-9571  FAX (920) 563-7395
EMAIL kjanderson@xxxxxxxxxxxxx