Problem:
Embedded SQL allows you to change the actual XDB or DB2 location by CONNECT TO. The location may be an XDB PC location or a mainframe DB2 location. You may switch between locations even within one program.
Resolution:
You must specify an XDB PC location as default in your SQL Client Options. An Authid is required, which enables SQL Logon to DB2 and to XDB. If the Option default is a DB2 location, then the CONNECT TO will not work. The next SQL statement will end with SQLCODE -501.
Old KB# 6661
#EnterpriseDeveloper
#MFDS
