Answer Posted / sudhakar

No will get an Error -
-420
The value of a string argument was not acceptable to the function-name function

How do I optimize a query in db2?

625

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3797

---

Is ibm db2 free?

579

---

What does sqlcabc has?

633

---

What does reorg do in db2?

578

---

---

How can the duplicate values be eliminated from db2 select?

633

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

628

---

Name the various locking levels available?

638

---

Define declaration generator (dclgen).

669

---

What is the usage of open cursor command?

601

---

What is check constraint. Explain with example.

650

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

716

---

What is db2 stogroup?

681

---

Which isolation level provides maximum concurrency?

668

---

What is db2 optimizer?

773

---