Answer / guest

Declare a DS with same data types in PGM and move the
record into DS and write the structured file using the DS

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

What is the maximum No of rows per page?

0 Answers   IBM,

---

Which one allows duplicate values Union or Union All ?

3 Answers  

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---