Обсуждение: ecpg and multiple connections

It is my first post to this group. Hello to everybody!

I have problem in my application.
I must handle queries to multiple databases concurrently.
In a documentation set there is only information how to open named
connections in order to differentiate them.
In documantaion the query statements 'EXEC SQL SELECT ...'
does not provide interface for the connection name.
ECPGdo has the second aprameters set to NULL, what is the purpose of
this parameter ?  Connection name ? Other object type ?

Can anybody help me ?
----------
Edward

>I have problem in my application.
>I must handle queries to multiple databases concurrently.
>In a documentation set there is only information how to open named
>connections in order to differentiate them.
>In documantaion the query statements 'EXEC SQL SELECT ...'
>does not provide interface for the connection name.
>ECPGdo has the second aprameters set to NULL, what is the purpose of
>this parameter ?  Connection name ? Other object type ?

If I read you correctly, the syntax you are after is

EXEC SQL CONNECT TO db1 AS conn1;
EXEC SQL CONNECT TO db2 AS conn2;

EXEC SQL AT db1 SQL_STATEMENTS;
EXEC SQL AT db2 SQL_STATEMENTS;

EXEC SQL DISCONNECT db1;
EXEC SQL DISCONNECT db2;

Hope this helps.

cheers,
Jason Davis