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 have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is meant by union and union all?
The only place of VSAM KSDS in DB2 is?
What r the comman abends in db2, jcl and cobol???????
What is null in db2?
max number of columns in a db2 table?
What is the purpose of the DSNC transaction ?
What is an asychronous write?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
how to resolve -805 . how to see dbrm and package not found
select distinct(empid),distinct(dept),name from EMP will the above query work?