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)

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2940

---

Can you tell me how can you find out the # of rows updated after an update statement?

1101

---

What is db2? Explain.

1043

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

---

How can you classify the locks in db2?

1089

---

How does cobol compile db2 program?

1059

---

How do you eliminate duplicate values in db2?

1192

---

What is a db2 collection?

1045

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1107

---

What is the maximum length of sqlca?

1529

---

What is check constraint in db2?

1090

---

What is table space in db2?

1019

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2070

---

How is the value function used?

1154

---

How does a cursor work?

988

---