Answer / s

Dynamic SQL are built at execution time. Dynamic SQL does
not go through the program preparation process like static
SQL and can execute different SQL statements in one
program.

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

What are the various locks available?

5 Answers   CTS,

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

---

How to create db2 table in mainframe?

0 Answers  

---

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

---

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

4 Answers   Accenture,

---