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.

What is a root page?

1 Answers  

---

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  

---

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

what is the Foreign key? explain?

2 Answers  

---

What is a DB2 access path?

1 Answers  

---

List some fields from sqlca?

0 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

What is explain plan in db2?

0 Answers  

---

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---