IBM Mainframe Forum

hi
i am sandip. i have a question.
In dynamic sql can we retrive a specific record with out using cursor???if yes then how can i display the record???

Of course. How depends on the host language.

the YES/NO question disease has struck again

Hello and welcome to the forum,

Do you now have what you are looking for?

If not, you need to explain where you are stuck. . .

Sandip - Where are you running the dynamic sql...? Need more information. In the mainframe world running a sql via qmf or spufi is considered to be a dynamic sql. In that sense "YES" you can run a dynamic sql to retrieve data without using a cursor.

Hello,

Your post is misleading at best - if not simply incorrect . . .

Dynamic sql can be executed from within one's own code, not only SPUFI or QMF. And it may or may not use a cursor. . .

i need the code.and my host language is cobol.and i use spufi to run those sql statements.

If you need the code - write it! There is a COBOL Language Reference Manual and a SQL Language Reference Manual that you may need to consult.

This is a HELP forum, not a WRITE-THE-CODE-FOR-YOU forum. However, I'm sure a number of people who respond on this forum would write the code for you provided you pay the appropriate professional fee (rates usually run about U.S. dollars 700 to 1500 per day for professional work product). If you get stuck writing the code, ask for help -- but we're not going to just give you the code since you're not learning anything by that.