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 bind and rebind in db2?

0 Answers  


how to identify the pseudo conversation by seeing the program

2 Answers   DELL,


What is the use of runstats in db2?

0 Answers  


What is null indicator in db2?

0 Answers  


How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  


What is Call attach facility? How does it work?

1 Answers   Syntel,


i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  


What is the physical storage length of timestamp data type?

0 Answers  


What is a storage group (stogroup)?

0 Answers  


what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,


How do I delete a column in db2?

0 Answers  


Categories