Hi,


I try to precompile [options: cpc -n (...) -d (...) -u (...,...) -E cplus -o -c FILE] sourcecode, which contains the following sequence twice (with a short variation)

[begin]
// ...

exec sql begin declare section;
        VARCHAR _pname [100];
        int i_pname;
        VARCHAR _vname [100];
        int i_vname;
        VARCHAR _geb   [100];
        int     i_geb;
        VARCHAR _kennung   [100];
        int     i_kennung;
        int _lfdnr;
        int i_lfdnr;
exec sql end declare section;

exec sql declare mycurs cursor for
         select pname,vname,geb,kennung,lfdnr from Patienten
         WHERE gueltig_bis =0
         ORDER BY pname,vname,geb ;

exec sql open mycurs;
if(sqlca.sqlcode <0) {return -1;}

do {
        exec sql fetch mycurs into
                                        :_pname  :i_pname,
                                        :_vname  :i_vname,
                                        :_geb    :i_geb,
                                        :_kennung        :i_kennung,
                                        :_lfdnr  :i_lfdnr;

//  KERNEL WARNING  :   -4000   Unknown result table
// ....
[end]

the behaviour is: the first occurence of the FETCH statement generates a

warning -4000 Unknown result table

Running the program this warning occures in also. After changing the inquired table the warning is generated and after a small delay (!) the program continues...

do you have some ideas to avoid those warnings?

with kind regards g.abraham

------------------------------------------------------------------
Guenter Abraham | Tel. 030-35 10 58 97 | Fax. 01805 39160 - 40468
Informations-Technologie Babelsberg GmbH
http://www.itbb.de
------------------------------------------------------------------

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to