connecting to two databases

[logic4fun]

All,
I need to connect to two different db2 databases in a single pro*C application

For eg:

int main {

exec sql connect to X;

select a into valA from X.tableA;
{
do some caluculations with valA
}
exec sql connect to Y;

insert into Y.tableB values (valA);

terminate;
}

Any suggestions
Thanks in advance

logic4fun

 

[sathyarams]

You'll have to use CONNECT TYPE 2 ...

I have not used it in C, but I think you will have to prepare your c program using CONNECT 2

Cheers
Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8