EXEC SQL SELECT

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

Question Posted / sivakumar sekharannair

2 Answers
9912 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to resolve deadlock issue

19861

Can we update view in db2?

944

B37 abend during spufi?

1405

What is cascading rollback?

1133

What is declare cursor?

1042

define clustering index.

977

What is drop table?

958

How do I delete a table in database?

974

What are the benefits of using the db2 database?

1153

How can you find out the # of rows updated after an update statement?

1050

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?

8991

How do I add a column in db2?

997

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1053

What is host variable?

1011

What are the rules for db2 programming?

1040