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

Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,

---

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,

---

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---

Can we delete records from view?

0 Answers  

---

What is a cursor and what is its function?

2 Answers  

---

What is the use of commit in db2?

0 Answers  

---

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

---

What is an alias?

3 Answers  

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  

---