EXEC SQL DECLARE dbname1 DATABASE;
EXEC SQL DECLARE dbname2 DATABASE;
EXEC SQL CONNECT :username1 IDENTIFIED BY :password1 AT dbname1 USING :dbstring1
EXEC SQL CONNECT :username2 IDENTIFIED BY :password2 AT dbname2 USING :dbstring2
EXEC SQL DECLARE dbname2 DATABASE;
EXEC SQL CONNECT :username1 IDENTIFIED BY :password1 AT dbname1 USING :dbstring1
EXEC SQL CONNECT :username2 IDENTIFIED BY :password2 AT dbname2 USING :dbstring2
执行sql语句时怎么标示数据库吗?是不是像这样:
EXEC SQL AT Dbname1 SELECT * FROM MYTABLE INSERT INTO :XXXX;
EXEC SQL AT Dbname2 SELECT * FROM MYTABLE INSERT INTO :YYYY;