Statement1 "We can not use UNCATLG in SMS managed VSAM
datasets"
Statement2 "We can not delete a SMS managed data set without
UNCATLG it" (P-353, Saba Zameer book)
Then how do we delete SMS managed VSAM datasets ?
what is the use of IEBGENER utility?
The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The DISP in the JCL is SHR and the program opens the file in EXTEND mode. What happens ?
what is “Cond= even” and “Cond=only”?
What do you do if you do not want to keep all the space allocated to a dataset?
What are steplib and joblib?
COND -> step1 . . step2, Step2, Executes if the CC of step1 is 0. But even if it is NOT 0 and if we dont give COND, will step2 be executed ?
How to find the number of duplicates in a file using Sort?
How many JOB statements a JCL can have ? If there are more than one JOB statements in a JCL, are they submitted in succession or in parallel ?
What are the parameter in the job card wihtout which job won't run........
once we submitted the job to the operating system, how can we cancel the job before execution?
How gdg are concatenated?
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.