What is the syntax of SELECT statement when embedded in a
COBOL program?

Answers were Sorted based on User's Feedback



What is the syntax of SELECT statement when embedded in a COBOL program?..

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

What is the syntax of SELECT statement when embedded in a COBOL program?..

Answer / guest

EXEC SQL
SELECT STATEMENT : HOST VARIABLE NAME
END-EXEC.

Is This Answer Correct ?    3 Yes 6 No

Post New Answer

More DB2 Interview Questions

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

5 Answers   EDS,


What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers  


What is meant by union and union all?

0 Answers  


The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,


What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,






What is null in db2?

0 Answers  


max number of columns in a db2 table?

6 Answers  


What is the purpose of the DSNC transaction ?

1 Answers  


What is an asychronous write?

1 Answers  


Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,


select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,


Categories