execute a prepared stmt

Posted in 2000

steveFarris — Thu, 26 Oct 2000 17:33:24 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, could someone fill in the blank for me?? sprintf(sql_text, "select count(*) into :cnt from arc where blahblah"); EXEC SQL PREPARE astmt from :sql_text; ?????? How do i execute a prepared stmt that is not a cursor?? (sorry, i don't have any manuals around me to look at right now)

↪ replying to steveFarris

Sergey E. Volkov — Fri, 27 Oct 2000 11:59:11 +0400 — source: Informix-list mailing list archive (1991-1998)

sprintf(sql_text, "select count(*) from arc where blahblah"); exec sql prepare astmt from :sql_text; exec sql execute astmt into :same_variable; Good luck; Sergey. steveFarris <nlymbo@mindspring.com> ''''' ' ''''''''':8ta7tj$no8$1@slb3.atl.mindspring.net... > Hi, could someone fill in the blank for me?? > > sprintf(sql_text, "select count(*) into :cnt from arc where blahblah"); > EXEC SQL PREPARE astmt from :sql_text; > > ?????? > > How do i execute a prepared stmt that is not a cursor?? > > (sorry, i don't have any manuals around me to look at right now) > > > >