MVSFORUMS.com

ashutosh_agl3 · Beginner Joined: 14 Aug 2003 Posts: 28 Topics: 15

How can we use dynamic sql in cobol.

I need to know how can we specify parameters to Fixed List SELECT class of dynamic sql.

eg:

SELECT <parm1>, <parm2> from <tablename> where <colname1> = :<Value1> and <colname2> = :<Value2>

<tablename>, <colname1>, <Value1>,<colname2> and <Value2> are the possible dynamic values which will be coming from somewhere else.

kolusu · Posted: Mon Mar 22, 2004 7:30 am Post subject:

Ashutosh,

This is a formal warning for your posting the same topic in more than 1 forum. Also you posted a similar question a few days back(Mar 17th) and did you go thru the responses? Did you even bother to read the manual listed by me? The link to your topic if you have forgotten.

http://www.mvsforums.com/helpboards/viewtopic.php?p=9285

Thanks

Kolusu

Ps: I have deleted your other post in application programming forum.
_________________
Kolusu
www.linkedin.com/in/kolusu

ashutosh_agl3 · Beginner Joined: 14 Aug 2003 Posts: 28 Topics: 15

I had gone thru the link but it didnt solve the purpose as the link had a number of issues unresolved and the examples were not clear.

I am sorry if i violated any rules of the forum and will try to make sure that next time it wont happen.

kolusu · Posted: Mon Mar 22, 2004 10:30 am Post subject:

Ashutosh,

If you had gone thru the link provided you would have found this section(6.16) which explains in detail as to how to code Dynamic SQL for fixed-list SELECT statements

Hope this helps...

Cheers

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

ashutosh_agl3 · Beginner Joined: 14 Aug 2003 Posts: 28 Topics: 15

the link does not describe how to supply PARAMETER MARKERS...most of the book i refered used some default characer like '?' to show the use of PARAMETER MARKER...but didnt actually specify how PARAMETER markers are specified so that one to one mapping can be done while supplying the values of parameters at time of OPEN.

eg:

SELECT <parm1>, <parm2> from <tablename> where <colname1> = ? and <colname2> = ?

open cursor using :value1 ,:value2

now how exactly the earlier dynamic query must be built so that value1 and value 2 are replaced at their appropriate place.

kolusu · Posted: Mon Mar 22, 2004 11:38 am Post subject:

Ashutosh,

You need to generate the sql statement to be used in the dynamic sql. Let us say you wanted this sql statement.

ashutosh_agl3 · Beginner Joined: 14 Aug 2003 Posts: 28 Topics: 15

this is exactly the way i have done...but i wanted to know how to use PARAMETER MARKERS whichhave been described in text but the usage is not clear.

Maton_Man · Beginner Joined: 30 Jan 2004 Posts: 123 Topics: 0

There is extensive discussion of parameter markers and their use in the DB2 Application Programming Guide (eg Look under topic 6.1.5.2.1 Using parameter markers) and in the DB2 SQL Reference (eg. Look under topic 5.74 PREPARE)

Basically they replace host variables in dynamic SQL, so where you would have:

Static SQL
SELECT EMP_NO FROM A.EMPTABLE WHERE EMP_NO = :EMP

...in dynamic SQL you would have...

SELECT EMP_NO FROM A.EMPTABLE WHERE EMP_NO = ?

You would supply the value for EMP_NO when you EXECUTE the statement.

Read the manuals I have pointed you to because there is too much to write about it here.
_________________
My opinions are exactly that.