EXEC SQL SELECT

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

Question Posted / sivakumar sekharannair

2 Answers
10091 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

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2248

Is db2 a mainframe?

1045

What is the maximum length of sqlca?

1530

Is the primary key a clustered index?

1149

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?

9216

What is data manager?

1052

When do you specify the isolation level?

1034

What is the maximum No of rows per page?

1070

Explain what are the various isolation levels possible?

1044

What is the clustering index in the db2 database?

1002

What is page size in db2?

978

What is catalog database in db2?

1166

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

2255

What does reorg do in db2?

1030

What is plan in cobol db2?

1140