I am writing embedded VC++ program using DB2 V 8.1.
I need to access two databases in a program. Do I need to maintain a SQLCA area for each database?

Hi VijiSeenivasan ,

The SQLCA Structure look like following

{
_SQLOLDCHAR sqlcaid[8];
sqlint32 sqlcabc;
#ifdef DB2_SQL92E
sqlint32 sqlcade;
#else
sqlint32 sqlcode;
#endif
short sqlerrml;
_SQLOLDCHAR sqlerrmc[70];
_SQLOLDCHAR sqlerrp[8];
sqlint32 sqlerrd[6];
_SQLOLDCHAR sqlwarn[11];
#ifdef DB2_SQL92E
_SQLOLDCHAR sqlstat[5];
#else
_SQLOLDCHAR sqlstate[5];
#endif
};

and there is no such a need to maintain more than one SQLCA, because it is complete independent Structure which you can Use for more than one Databases.

Regards,
Chalam N