Embeded sql statements in Cobol-db2 programs

Gops · New User Joined: 21 Jul 2005 Posts: 23

Hi Guys,

I have a query in a cobol-db2 program as follows.

EXEC SQL

SELECT * FROM EMPTAB WHERE EMP_NME = 'GOPS';

END EXEC.

Can I use such embeded sql statements in Cobol-db2 programs.

If not why?

will it gives me any error if I use such qurery, pls let me know the
SQL CODE.

Cheers,
Gops

Mamata · New User Joined: 01 Aug 2005 Posts: 4 Location: hyderabad

Hi,

We can not use embedded SQLs like
'SELECT * FROM.....' in a Cobol program.

this will not give any Error but if the Number fields in the table get modified (new field added or a field is deleted) it'll cause problem in the DCLGEN host variables.

Regards,
Mamata.

t1nt1n · New User Joined: 08 Jul 2005 Posts: 31

Hello

Generally when you want to use queries that selects more than one rows, you need to use cursors.

you need to do in this order DECLARE, OPEN, FETCH, CLOSE.