What is the syntax of SELECT statement when embedded in a
COBOL program?

Answer Posted / sivakumar sekharannair

EXEC SQL
SELECT
EMPNAME
INTO : HS-EMPNAME(Host variable)
FROM EMPTABLE
WHERE
EMPID = :HS-EMPID(Host variable)
END-EXEC.

Is This Answer Correct ?    17 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scrollable cursor in db2?

583


What is the maximum length of sqlca?

869


Is db2 relational database?

572


What is the connection string to connect to the DB2 Database ?

612


Which component is responsible for db2 startup and shutdown?

626






What is bind package and plan in db2?

593


How connect db2 database to datastage?

761


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

743


List down the types of triggers in the db2 database?

589


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

642


How can the duplicate values be eliminated from db2 select?

623


What is the difference between bind and rebind in db2?

849


What is cursor with hold option in db2?

612


What is a db2 cursor?

622


Which isolation level provides maximum concurrency?

664