Answer Posted / yuvaevergreen

step1>>put all the sql statements in cobol program inside
exec sql and end-exec.Because precompiler identifies using
sql using these keywords.
step2>>all sql statements should be within 12th and 72th
column in program.
step3>>Include the dclgen if created or use the host
variable declaration name and sqlca.
step4>>precompile,compile,bind,linkedit and execute.

Is db2 a database?

578

---

Define sqlca.

657

---

What is the difference between plan and package in db2?

585

---

How do you eliminate duplicate values in db2?

696

---

What is the maximum size of a char data type in db2?

594

---

---

Explain dclgen.

733

---

what is utility for parm lib

1894

---

What is isolation level in db2?

588

---

What is bind and rebind in db2?

658

---

What is db2 bind?

646

---

What is package in db2 mainframe?

565

---

What is host variable?

605

---

How to view db2 table structure?

603

---

What parameters are used to control the free space in DB2?

651

---

Is it possible using max on a char column?

615

---