Answer Posted / jujubi

when you start coding any DB2 pgms you should include SQLCA
and DCLGEN member in w-s section and perform activities of
coding which need to be processed in procedure division.
all statements should be scoped in EXEC SQL and END-EXEC
scope
only and you should precompile, create package and plan, you
should run this pgm by using plan. these are the steps we
follow these days.

How do I import a csv file into db2?

1039

---

How do you eliminate duplicate values in db2?

1262

---

Explain the benefits you can get from mainframe connect?

1015

---

Can we delete records from view?

1020

---

Explain correlated sub-queries.

1093

---

How to test SQL -911 error while developing COB-DB2 program

7665

---

How to take backup of table in db2?

1121

---

Explain in brief how does db2 determine what lock-size to use?

1087

---

If I have a view which is a join of two or more tables, can this view be updateable?

1184

---

Is db2 a database?

1027

---

How to check table size in db2 sap?

1095

---

How does a cursor work?

1038

---

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?

9355

---

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

1156

---

can all users have the privilage to use the sql statement select * (dml)?

1220

---