Interested to Buy Any Domain ? << Click Here >> for more details...
What is the syntax of SELECT statement when embedded in a
COBOL program?
- 2 Answers
- 10176 Views
- I also Faced
- E-Mail Answers
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 |
Give the name of some fields form sqlca.
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
Name the lockable units in DB2?
How is the SUBSTR keyword used in sql?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What does db2 stand for?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Can you define an Index if the table size less than 10 PAGES?
How does coalesce work?
What is load utility in db2?
How would one remove old reorg information from the DB2 catalog?
COBOL 
