Can I include the SQL Query from a string

aavugari mayuri · New User Joined: 15 Aug 2006 Posts: 10

hi all,
is this possible..

str='select * from tablename'

and

EXEC SQL
STR
END-EXEC.

instead of

EXEC SQL
SELECT * FROM TABLENAME
END-EXEC.

i'm new to mainframe world so may ask some weird qns..please bear with me..

mayuri

ofer71 · Posted: Mon Sep 25, 2006 12:59 pm

What is your host language?

O.

aavugari mayuri · New User Joined: 15 Aug 2006 Posts: 10

host language is COBOL only

anamikak · New User Joined: 10 May 2006 Posts: 64 Location: Singapore

If you want to construct a string to execute an SQL, you can do so using dynamic SQL. But to execute Fixed list dynamic SQL you will also need to declare a cursor the result set.Then prepare,fetch and close the cursor.

Anamika

cj10 · New User Joined: 18 Sep 2006 Posts: 9

In embedded SQL, such declarations are not possible.

Executable SQL statements must be placed between the EXEC SQL ......END-EXEC statements.

Corrections welcome !!!!!!

Thanks,
CJ.

DavidatK · Posted: Mon Sep 25, 2006 10:39 pm

Anamika is correct, chech the link below

6.1 Chapter 6-1. Coding dynamic SQL in application programs

Dave

aavugari mayuri · New User Joined: 15 Aug 2006 Posts: 10

hi all..
thanx for the inputs..it helped..