Answer / 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)

Answer / ekalavya

SELECT Y
FROM TABLEA
WHERE Y LIKE 'abc%';

Explain packages.

0 Answers  

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

What are some SQL aggregates and other built-in functions?

2 Answers  

---

What is the physical storage length of timestamp data type?

0 Answers  

---

What is a DB2 plan?

8 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

What is meant by explain?

0 Answers  

---

how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,

---

Explain various types of locks in db2?

0 Answers  

---

How do I import a csv file into db2?

0 Answers  

---