Answer / Agrita Bisht

In JCL, STEPLIB (STEP Library) is a collection of predefined steps that can be used to perform common tasks like data transfer, sorting, and printing. Joblib (job library) is a collection of jobs that can be easily reused in multiple job streams or scheduled through the same JES (Job Entry Subsystem). Both STEPLIB and Joblib help reduce the amount of code required for creating and managing jobs.

Mention the types of job control statements?

1 Answers  

---

When The Define Jcl Is Not Available, How Can You Get Information About A Vsam File's Organisation ?

1 Answers   IBM,

---

Explain the function of dd disp parameter?

1 Answers  

---

Can I copy the FB (fixed Block) record length file to a VB (variable Block)record length file and Vise Versa? If Yes then how ? is that thru one of the JCL utility ?

3 Answers  

---

is step name is compulsory in jcl ?

2 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,

---

when we use sysprint and sysout statements

3 Answers  

---

A statement about PROCs is " In PROCs, Symbolic Parameters can be assigned on PROC and EXEC", BUT On which EXEC, (i) On the JCL's EXEC which is calling to PROC1. (Inside JCL, EXEC PROC1) (ii) or On the PROC's EXEC where it calls the PGM1. (Inside PROC, EXEC PGM=PGM1)

1 Answers   IBM,

---

In JCL I have 5 steps,I need to execute 1st,2nd and 5th steps only,can any one answer me please?

2 Answers   TCS,

---

Is it possible to take a PDS and write it to a GDG? If so, can you provide an example? Thanx

7 Answers  

---

How can the attributes of one sms dataset be copied to another dataset?

1 Answers  

---

How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.

1 Answers   CSC, SPIC,

---