What is the syntax of SELECT statement when embedded in a
COBOL program?
Answers were Sorted based on User's Feedback
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 |
Answer / guest
EXEC SQL
SELECT STATEMENT : HOST VARIABLE NAME
END-EXEC.
Is This Answer Correct ? | 3 Yes | 6 No |
What is a cursor?
How to define the a field which accepts value till 99999.99 in db2
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
how to identify the pseudo conversation by seeing the program
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What are the three lock types?
What is a bind in db2?
What is access path in db2?
What is the result of open cursor statement?
What is the reason behind not using select * in embedded sql programs?
Where can you declare a cursor in a cobol-db2 program?
What is JOIN and different types of JOIN.