Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Multiple Database - SQLCA

    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?

  2. #2
    Join Date
    Jul 2003
    Location
    india
    Posts
    15

    Re: Multiple Database - SQLCA

    Originally posted by VijiSeenivasan
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •