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 5604oza017.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 8824How 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 13677How 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 13154How do define Dymanic array in cobol how do u define single demensional arry and multidymensional arry in ur cobol.
4 10481
if we want to use a gdg which is already created by some job, then how to use the reference of the last generation in a jcl?
When are scope terminators compulsory?
how you get the relative record in a subfile in which cursor is located?
What is an in line perform? When would you use it? Anything else you wish to say about it.
What is db2 plan table?
can we use ASCII ,CDUP,SENDPASV commands in SFTP?
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
What is the eib?
Can you please let me know the centre name of INS certification in Kolkata.
Explain referential integrity?
Can records be accessed randomly in esds?
What are steplib and joblib? What for they are used?
What are some jcl statements that are not allowed in procedures?
Is it possible using max on a char column?
What is the use of jdftval in as400?