Answer / s

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

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

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

How would the varchar column remarks defined?

0 Answers  

---

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

what is sql abend code -801,-802?

2 Answers  

---

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---

What are common abends

1 Answers   SPIC, Virtusa,

---

Which isolation level provides maximum concurrency?

0 Answers  

---

How to create backup table in db2?

0 Answers  

---

What are delete-connected tables?

1 Answers  

---

What is isolation level?

4 Answers  

---

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,

---