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 |
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
how to check the table is empty or not?
What is a Cartesian product?
What is the SQL Communications Area and what are some of its key fields?
Explain about dbrm.
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
What is deadlock in db2?
what is the use of bind parameter, Replace?
Can we use select * statement in cobol program without giving field names ???
How do I import a csv file into db2?
How can you display the current date & current time ?
Can you use max on a char column?