Path: utzoo!attcan!uunet!zaphod.mps.ohio-state.edu!mips!troi!wookie!ivan
From: ivan@dbaccess.com (Ivan Covdy)
Newsgroups: comp.databases
Subject: Max number of open cursors in DB2?
Message-ID: <395@wookie.dbaccess.com>
Date: 24 Oct 90 23:31:53 GMT
Organization: DB/Access Inc., Santa Clara, CA
Lines: 22


I couln't find any limitations on a number of cursors in DB2, which can
be simultaneosly opened in a program with embedded SQL code.
Are there any? Primarily, I'm interesting in DB2, but that information
will be useful for any SQL Database. 
The same question is for PREPARE:
are there any limitations on the number of statements, which can be prepared
(without execution) simultaneuosly?
And are there any limitations on the number of SQLDAs in a program?

Thank you in advance for your help.

-- 
Ivan Covdy                        INTERNET: ivan@dbaccess.com
c/o DB Access Inc.                UUCP: {uunet,mips}!troi!ivan
2900 Gordon Avenue, Suite 101     FAX: (408) 735-0328
Santa Clara, CA 95051             TEL: (408) 735-7545
-- 
Ivan Covdy                        INTERNET: ivan@dbaccess.com
c/o DB Access Inc.                UUCP: {uunet,mips}!troi!ivan
2900 Gordon Avenue, Suite 101     FAX: (408) 735-0328
Santa Clara, CA 95051             TEL: (408) 735-7545