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 |
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
On the create tablespace, what does the CLOSE parameter do?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
I use CS and update a page. Will the lock be released after I am done with that page?
What is a dbrm in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is package in cobol db2?
What is the physical storage length of time data type?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
Explain about mirror activator disk mirroring?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How to insert more than one record using insert?