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
How can you classify the locks in db2?
What is difference between alias and synonym in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What do you mean by cursor?
What are foreign keys in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How can the duplicate values be eliminated from db2 select?
What is consistency token in db2?
What is access path in db2?
What is buffer pool in the db2 database?
What is copy pending status in db2?
what is the responsibility of the construction superintendent
What is cursor with hold option in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?