Answer / s

You can use TSO to run a batch program using the TSO
Terminal Monitor Program IKJEFT01 which involes the DSN
command and runs the application program.

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

What is bind plan?

0 Answers  

---

what is the difference between where clause and having clause

2 Answers   IBM,

---

what is SPUFI ?

2 Answers  

---

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

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  

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

how to take the back up of the DB2 table.

7 Answers  

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---