View previous topic :: View next topic
|
Author |
Message |
soundari
New User
Joined: 23 Feb 2007 Posts: 7 Location: chennai
|
|
|
|
what is the purpose of SQLDA? |
|
Back to top |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006 Posts: 771 Location: Germany
|
|
|
|
Hi !
SQLDA (SQL descriptor area)
An SQLDA is a collection of variables that is required for execution of the SQL DESCRIBE statement. The SQLDA variables are options that can be used by the PREPARE, OPEN, FETCH, and EXECUTE statements. An SQLDA communicates with dynamic SQL; it can be used in a DESCRIBE statement, modified with the addresses of host variables, and then reused in a FETCH or EXECUTE statement.
SQLDAs are supported for all languages, but predefined declarations are provided only for C, REXX, FORTRAN, and COBOL.
The meaning of the information in an SQLDA depends on its use. In PREPARE and DESCRIBE, an SQLDA provides information to an application program about a prepared statement. In OPEN, EXECUTE, and FETCH, an SQLDA describes host variables.
More Information:
publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0001030.htm
Regards, UmeySan |
|
Back to top |
|
|
prav_06 Warnings : 1 Active User
Joined: 13 Dec 2005 Posts: 154 Location: The Netherlands
|
|
|
|
Soundari,
Its called as SQL Descriptor Area, Used mostly in Dynamic execution of SQL st. i belive , similar to SQLCA u have lot of variables inside this copy book , please check IBM's website for more info.
Thamilzan. |
|
Back to top |
|
|
soundari
New User
Joined: 23 Feb 2007 Posts: 7 Location: chennai
|
|
|
|
Thanks for your reply |
|
Back to top |
|
|
DeepaBala
New User
Joined: 20 Feb 2007 Posts: 13 Location: Trivandrum
|
|
Back to top |
|
|
|