Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is the purpose of SQLDA

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: What is the purpose of SQLDA
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: 755
Location: Germany

PostPosted: Fri Feb 23, 2007 3:28 pm    Post subject:
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:

http://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    Post subject:
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    Post subject: SQLDA
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    Post subject: Detail about SQLDA
Reply with quote

Hi Soundari,

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

http://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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts REXX-DB2 with SQLDA Susanta DB2 7 Mon Dec 31, 2012 11:35 am
No new posts Tool to access DB2 Zos - For Query pu... gylbharat DB2 6 Thu Oct 04, 2012 6:17 pm
No new posts What is the purpose of LIBDEF keyword? enrico-sorichetti TSO/ISPF 1 Tue Oct 18, 2011 11:22 am
No new posts SQLTYPE in SQLDA = '16' with SQLSTATE... GuyC DB2 1 Wed May 04, 2011 12:50 pm
No new posts SQLDA - Dynamic SQL Naish COBOL Programming 4 Mon Feb 21, 2011 4:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us