Answer Posted / madhu t

select Y from <table> where substr(y,1,3) = 'abc'

we can achieve this by using substring function in sql.
SUBSTR(column-name,starting-position,length)

What is db2 connect?

599

---

What is reorg and runstats in db2?

686

---

Is db2 a mainframe?

581

---

What is db2?

739

---

what is the sqlcode -501

11277

---

---

Define check constraint.

642

---

What is database reorganization?

587

---

Discuss about db2 bind?

664

---

What is the role of the data page in the db2 database?

583

---

What is the difference between dbm cfg and db cfg file in db2 ?

999

---

Why select is not preferred in embedded sql programs?

707

---

What does reorg do in db2?

573

---

What is clone table?

590

---

What are the bind parameters ibm db2?

622

---

What is null value in db2?

557

---