Answer / s

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

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

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

What is a bind card?

0 Answers  

---

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

What is reorg and runstats in db2?

0 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

What is lock escalation?

2 Answers  

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

How to fetch the last row from the table in SQL (db2)?

0 Answers  

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---