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

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  


How to find primary key of a table in db2?

0 Answers  


Explain the function of data manager.

0 Answers  


Which one allows duplicate values Union or Union All ?

3 Answers  


What are leaf pages?

3 Answers  






what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,


How to create db2 table in mainframe?

0 Answers  


How to solved 818 error

4 Answers   Keane India Ltd, Wipro,


difference between group clause and order clause

1 Answers  


What is DCLGEN ?

2 Answers  


i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  


How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,


Categories