IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31) 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 5472oza017.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 8678How can I override a dsn that is contained in a proc called by another proc? I need to do the override in the calling JCL.
3 13520How To get the last record in VSAM file in cluster? and How can u get the ksds file records into ur cobol program ? Pls tell me about these two questions.
1 13033How do define Dymanic array in cobol how do u define single demensional arry and multidymensional arry in ur cobol.
4 10346
Can you tell me how can you find out the # of rows updated after an update statement?
Explain the difference between a schema and a subschema in idms?
What is a run unit in idms?
Mention the guidelines to write a structured cobol program?
Explain ceci transaction commands?
Explain psbgen process?
Difference Between Call & Sbmjob?
How do you check object lock
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How do you round the addition or subtraction of two numbers in assembler?
What is the advantage of defragmentation?
What is a db2 cursor?
Which is the difference between delimited by size and delimited by space?
Explain storage architecture of idms.
Using alternate indexes in cics program?