MVSFORUMS.com

[enge]

goodmorning everyone,

is that a way to launch a command ,in a cobol cics application program , which contains a string (that is a select sql code) to query a db2 table?
the top is , retrieve the entirely row of the table.

for example:
working storage.
01 myqry pic x(80) value 'select * from mytable where mycol = 1)
.
.
EXEC SQL INCLUDE SQLCA END-EXEC.
EXEC SQL INCLUDE myrecord END-EXEC.
.
.
.
call ??????? using myqry giving myrecord

thanks in advance

[kolusu]

enge,

1. Click on "Quick Manuals " on top of this page
2. Scroll down to DB2 section
3. click on "DB2 V8 Application Programming and SQL Guide"
4. Read chapter 6.1

Kolusu

[enge]

thank you very much.(i feel a little lazy)