Answer / s

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

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

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

What is the size of a data page?

2 Answers   IBM,

---

What is null indicator in db2?

0 Answers  

---

What is the physical storage length of timestamp data type?

0 Answers  

---

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---

What is a result table?

1 Answers  

---

When reorg is used?

0 Answers  

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

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 copy pending status in db2?

0 Answers  

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---