Answer / rajesh_m13

substr('string',1,3) which gives str. correct me if i am wrong

Answer / ignatius pradeep

A Sample Query:

SELECT SUBSTR(DESC_T,1,4)
FROM PRODUCT
WHERE PROD_I = 123456;

DESC_T is a column in the table PRODUCT

The first four characters of the DESC_T will be displayed.

Explain the use of the WHERE clause?

1 Answers  

---

cobol-db2 runjcl please?

2 Answers   DELL,

---

What is normalization and what are the five normal forms?

1 Answers  

---

How would you find out the total number of rows in a db2 table?

0 Answers  

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

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,

---

When is the skeleton cursor table created?

1 Answers  

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

How to execute stored procedures?

0 Answers  

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

What is db2 connect?

0 Answers  

---

What is table space in db2?

0 Answers  

---