DS CLI support multiple statements?
Posted in 1998
Topics: General Discussion
This is a multi-part message in MIME format. --------------2E3593E7A2A6F3D5248FF555 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I was wondering if CLI version 2.5 for Online Dynamic Server support multiple statements (handles) per connection (handle)? In other words, can I execute two concurrent SQL statements using the same connection handle? eg, SQLAllocEnve(&henv); SQLAllocConnect(henv, &hdbc); SQLConnect........ SQLAllocstmt(hdbc, &hstmt1); SQLAllocstmt(hdbc, &hstmt2); SQLExecuteDirect(hstmt1, "select * from customer", SQL_NTS); SQLExecuteDirect(hstmt2, "select * from emp", SQL_NTS); Do I need to execute hstmt1 and hstmt2 on two different hdbc? Thanks, Arun. --------------2E3593E7A2A6F3D5248FF555 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Arun Jamwal Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Arun Jamwal n: Jamwal;Arun org: Quality Consulting Services adr: 3003 Bunker Hill Lane, Suite 202;;;Santa Clara, CA 95054;;;USA email;internet: jamwal@quality.com title: Senior Associate Software Engineer tel;work: (408)-367-8809 tel;fax: (408)-367-8804 x-mozilla-cpt: ;0 x-mozilla-html: TRUE version: 2.1 end: vcard --------------2E3593E7A2A6F3D5248FF555--