Answer / s

Select * from emp
where SUBSTR(empname,4,2) = 'EN'

4 is the starting position and returns 2 characters after
that.

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---

what is db2 restart?

0 Answers  

---

---

Explain about mirror activator disk mirroring?

0 Answers  

---

Is ibm db2 open source?

0 Answers  

---

Explain about rct.

0 Answers  

---

what is consistency token

3 Answers  

---

What is meant by explain?

0 Answers  

---

Define check constraint.

0 Answers  

---

What is sqlcode -922 ?

2 Answers  

---