Problem with Pro *C

From: Ramprasad Santhanakrishnan <rsanthan_at_top.cis.syr.edu>
Date: Tue, 8 Feb 1994 18:01:36 GMT
Message-ID: <1994Feb8.180136.4044_at_newstand.syr.edu>


Hi folks
I am having problem with the following program segment in Pro *C.

This particular query is not inside any function or loop or switch statements. It is required to find the no. of unique csci_names in table .

I dont know why it puts a break statement in 'C' program...

/*
 EXEC SQL SELECT COUNT(DISTINCT csci_name)

             INTO :num_csci
             FROM breadth_of_testing
             WHERE system_name = :system_name
             AND csci_name <> "";

*/
{

    sqlstm.stmt = "SELECT COUNT(DISTINCT CSCI_NAME)INTO:b1 FROM BREADTH_OF_TESTING WHER
E SYSTEM_NAME=:b2 AND CSCI_NAME<>\"\"";

    sqlstm.iters = (unsigned short)1;
    sqlstm.offset = (unsigned short)77;
    sqlstm.selerr = (unsigned short)0;
    sqlstm.cud = sqlcud0;
    sqlstm.sqlest = (unsigned char *)&sqlca;
    sqlstm.sqlety = (unsigned short)0;
    sqlstm.sqhstv[0] = (unsigned char *)system_name;
    sqlstm.sqhstl[0] = (unsigned long)21;
    sqlstm.sqindv[0] = (short *)0;
    sqlstm.sqhstv[1] = (unsigned char *)&num_csci;
    sqlstm.sqhstl[1] = (unsigned long)4;
    sqlstm.sqindv[1] = (short *)0;
    sqlstm.sqphsv = sqlstm.sqhstv;
    sqlstm.sqphsl = sqlstm.sqhstl;
    sqlstm.sqpind = sqlstm.sqindv;

    sqlcex(&sqlctx, &sqlstm, &sqlfpn);
    if (sqlca.sqlcode == 1403) break;
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

}

Ramprasad

-- 
Hi
Received on Tue Feb 08 1994 - 19:01:36 CET

Original text of this message