MVSFORUMS.com

pzmohanty · Posted: Tue Oct 05, 2004 5:57 am Post subject: What is SQLDA

hi all,
what is SQLDA & how it is different from SQLCA.
when should we use SQLDA & how to use it.

Thanx in advance

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

pzmohanty,
It's surprising that people keep posting for information that is readily available, for ex: type SQLDA in google and the first hit is
"SQLDA (SQL descriptor area). An SQLDA is a collection of variables that is required
for execution of the SQL DESCRIBE statement. ... SQLDA field descriptions. ... "

similar for SQLCA, there are a ton of material in the reference section of this site. Do your DD and then ask questions. Thanks

kolusu · Posted: Tue Oct 05, 2004 8:45 am Post subject:

Pzmohanty,

You have been on this site for nearly 6 months. By now you should be able to do some homework before posting a question. As sureshkumar mentioned , the information is readily available. The information can be found in either sql reference manual or application programming guide manual. Don't get used to the spoon-feeding routine. You will learn nothing if you rely on that routine.

Anyway check this link for explanation of SQLCA & SQLDA. In simple terms , SQLDA is used when you are working with dynamic sql.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/C.0?DT=20010718164132

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu