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

What is a cursor?

2 Answers  


How to define the a field which accepts value till 99999.99 in db2

3 Answers  


What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers  


how to identify the pseudo conversation by seeing the program

2 Answers   DELL,


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  


What are the three lock types?

2 Answers  


What is a bind in db2?

0 Answers  


What is access path in db2?

0 Answers  


What is the result of open cursor statement?

0 Answers  


What is the reason behind not using select * in embedded sql programs?

0 Answers  


Where can you declare a cursor in a cobol-db2 program?

0 Answers  


What is JOIN and different types of JOIN.

2 Answers   IBM,


Categories