oza017.myorg.emp has 100 records ,oza018.myorg.staff has 200 records but 50 are the common records in both files copy all the common records into oza017.myorg.xyz dataset

3 Answers   Cognizant,

---

Describe the DD statement, its meaning, syntax and keywords?

2 Answers  

---

I have Job A and Job B. I want to trigger Job B from Job A. Please advise.

2 Answers   Wipro,

---

delete rules in db2

1 Answers   Keane India Ltd,

---

What is the purpose of include statement in a JCL?

2 Answers  

---

What are SD37, SB37, SE37 abends?

4 Answers  

---

what is the difference between static call and dynamic call?

1 Answers  

---

I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?

0 Answers  

---

i have 10,000 records in one input file.i want to sort 1 to 5000 records in one outputfile and remaining records sort in another output file write the syntax for this?

4 Answers   DELL,

---

What are three major types of JCL statements? What are their functions?

1 Answers  

---

How to override a dsn that is contained in a proc called by another proc? I need to do the override in the calling jcl?

0 Answers  

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above. 1 What is the maximum number of tables that can be stored on a Partitioned Table Space ? 1 what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names Accenture 5 Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code? 6 When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing? 2 how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE IBM 7 max number of columns in a db2 table? 6 What is package versioning? Please give an example. 1 What is the picture clause of the null indicator variable? 6 How do you filter out the rows retrieved from a Db2 table ? 1 What is DB2 (IBM Database 2)? 3 Can any one tell me about Restart logic in DB2.

2 Answers   Cap Gemini,

---