Previous Topic: SQLCA -- CA Datacom/DB Format (Assembler)Next Topic: SQL State Classes


SQLCA in C Language

 struct sqlca {
                          char  sqlca_eye_catch [8];
               #define sqlcaid  sqlca_eye_catch
                          int   sqlca_len;
               #define sqlcabc  sqlca_len
               #ifndef DB2
                          char  sqlca_db_vrs    [2];
                          char  sqlca_db_rls    [2];
                          char  sqlca_luwid     [8];
               #endif
                          int   sqlca_code;
               #define sqlcode  sqlca_code
               #define sqlcade  sqlca_code
               #ifndef DB2
                          short sqlca_err_len;
               #define sqlerrml sqlca_err_len
               #endif
                          char  sqlca_err_msg SQLCA_MSG_LEN&hyphen. ;
               #define sqlerrmc sqlca_err_msg
               #define sqlerrm  sqlca_err_msg
                          char  sqlca_error_pgm  [8];
               #define sqlerrp  sqlca_error_pgm
               #ifdef DB2
                          int   sqlerrd 6&hyphen. ;
               #else
                          char  sqlca_filler_1   [2];
                          char  sqlca_dsfcode    [4];
                          int   sqlca_infcode;
                          char  sqlca_dbcode_ext [2];
                          short sqlca_dbcode_int;
                          int   sqlca_misc_code1;
                          char  sqlca_sqlstate   [5];
               #define sqlstate sqlca_sqlstate
                          char  sqlca_filler_2   [3];
               #endif

(Continued on Next Page)

               char     sqlca_wrn_area SQLCA_WARN_LEN&hyphen. ;
               #define sqlca_warn0 sqlca_wrn_area[0]
               #define sqlca_warn1 sqlca_wrn_area[1]
               #define sqlca_warn2 sqlca_wrn_area[2]
               #define sqlca_warn3 sqlca_wrn_area[3]
               #define sqlca_warn4 sqlca_wrn_area[4]
               #define sqlca_warn5 sqlca_wrn_area[5]
               #define sqlca_warn6 sqlca_wrn_area[6]
               #define sqlca_warn7 sqlca_wrn_area[7]
               #define sqlwarn0    sqlca_wrn_area[0]
               #define sqlwarn1    sqlca_wrn_area[1]
               #define sqlwarn2    sqlca_wrn_area[2]
               #define sqlwarn3    sqlca_wrn_area[3]
               #define sqlwarn4    sqlca_wrn_area[4]
               #define sqlwarn5    sqlca_wrn_area[5]
               #define sqlwarn6    sqlca_wrn_area[6]
               #define sqlwarn7    sqlca_wrn_area[7]
               #ifdef DB2
                          char     sqlext        [5];
              }
      sqlca = {"SQLCA   ",136,0,"                            ",
               "        ",0,0,0,0,0,0,"           ",0,0,0,0,0
              };
               #else
                          char     sqlca_pgm_name  [8];
                          char     sqlca_authid    [18]
                          char     sqlca_plan_name [18];
              }
      sqlca = {"SQLCA***",196,"10", "0 ","        ",0,0,
               "                           ","        ","  ", "    ",0,"  ", 0,
               ' ', ' ', ' ',"        ","        ","CA AuthID","<pgmname>"
              };
               #endif