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%';

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---

Can you Average the Characters ?

3 Answers  

---

What is load replace in db2?

0 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

What is package in cobol db2?

0 Answers  

---

Explain various types of locks in db2?

0 Answers  

---

What will happen, while trying to close the closed cursor.

1 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

What is QUIESCE?

2 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---