Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
1 4318If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
6 6696My JCL have five steps & I created new versions of GDG in first step through fourth step & fifth step I was refered Step one GDG version. My JCL got abend at 4th step and how I can restart my JCL Please let me know the answers. //STEP1 EXEC GDG1(+1) DISP=(NEW) //STEP2 EXEC GDG1(+2) DISP=(NEW) //STEP3 EXEC GDG1(+3) DISP=(NEW) //STEP4 EXEC GDG1(+4) DISP=(NEW) //STEP5 EXEC GDG1(+1) DISP=(OLD)
11 51796How many types of parameters are used in JCL and what are mandatory parameters of JOB statement.
IBM,
13 23789why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
3 7551Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
2 5114In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
8 16207Can 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 20264
What is the use of qsam?
What do you understand by jcl?
if we have " ibm mainframe ",in that how to remove first and last leading space eg:"ibm mainframe" like that the answer we need
Explain the significance of dbid used in adabs?
how do you code a null statement?
Name and explain the location modes?
Differentiate cobol and cobol-ii. (Most of our programs are written in cobolii, so, it is good to know, how, this is different from cobol)?
Is the primary key a clustered index?
What is the use of mdt (modified data tag)?
2 input fles: 2 flat files, with different number of records. both are having unique key for each record and already sorted in ascending order . match these files using unique key and in output only matching key value has to be written. please procide cobol logic
What is page size in db2?
Define the necessity of run stats among the environment test?
Explain how can values be passed from the job stream to an executable program?
How an empty file to be checked?
What is the difference between local and central version operating modes?