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 |
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?
How to find primary key of a table in db2?
Explain the function of data manager.
Which one allows duplicate values Union or Union All ?
What are leaf pages?
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'
How to create db2 table in mainframe?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
difference between group clause and order clause
What is DCLGEN ?
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
How to resolve -407 sql code in DB2?