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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / guest

EXEC SQL
SELECT STATEMENT : HOST VARIABLE NAME
END-EXEC.

Is This Answer Correct ?    3 Yes 6 No

Post New Answer

More DB2 Interview Questions

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  


On the create tablespace, what does the CLOSE parameter do?

1 Answers  


if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  


What is a dbrm in db2?

0 Answers  






I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  


What is package in cobol db2?

0 Answers  


What is the physical storage length of time data type?

0 Answers  


how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,


Explain about mirror activator disk mirroring?

0 Answers  


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,


How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,


Categories