Answer Posted / tej

1. Declare the table structure you wanted to access in
working storage section or linkage section.(Can use DCLGEN
here).
2.Declare host variables in Working storage section.(if
DCLGEN used no need of declaring these host variables
separately).
3.Include SQLCA.
3.Now you can add the embedded SQL statements to your program.

Please add if i missed any other info..

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

7576

---

What is a buffer in memory?

1060

---

How do we specify index to include or not during bind process.

2128

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11676

---

When the like statement is used?

1223

---

How to retrieve rows from a db2 table in embedded sql?

1394

---

How do I add a column to a table in db2?

1104

---

What is ibm db2 used for?

1082

---

What is cobol db2?

1003

---

How to execute stored procedure in db2 command editor?

1050

---

How do I import a csv file into db2?

992

---

Explain the function of data manager.

1047

---

Mention some fields that are a part of sqlca.

1034

---

Is db2 a mainframe database?

1003

---

Are views updateable?

1163

---