IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

What is the purpose of SQLDA


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
soundari

New User


Joined: 23 Feb 2007
Posts: 7
Location: chennai

PostPosted: Fri Feb 23, 2007 3:05 pm
Reply with quote

what is the purpose of SQLDA?
Back to top
View user's profile Send private message
UmeySan

Active Member


Joined: 22 Aug 2006
Posts: 771
Location: Germany

PostPosted: Fri Feb 23, 2007 3:28 pm
Reply with quote

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
View user's profile Send private message
prav_06
Warnings : 1

Active User


Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands

PostPosted: Fri Feb 23, 2007 3:29 pm
Reply with quote

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
View user's profile Send private message
soundari

New User


Joined: 23 Feb 2007
Posts: 7
Location: chennai

PostPosted: Mon Feb 26, 2007 10:55 am
Reply with quote

Thanks for your reply
Back to top
View user's profile Send private message
DeepaBala

New User


Joined: 20 Feb 2007
Posts: 13
Location: Trivandrum

PostPosted: Tue Feb 27, 2007 11:49 am
Reply with quote

Hi Soundari,

This link contain all details about SQLDA.
I hope its very useful to u.

publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/rbafzmstsqldda.htm
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts What is the purpose of z/OS dataset e... All Other Mainframe Topics 3
No new posts REXX-DB2 with SQLDA DB2 7
No new posts Tool to access DB2 Zos - For Query pu... DB2 6
No new posts What is the purpose of LIBDEF keyword? TSO/ISPF 1
No new posts SQLTYPE in SQLDA = '16' with SQLSTATE... DB2 1
Search our Forums:

Back to Top