Interested to Buy Any Domain ? << Click Here >> for more details...
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 5103If 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 8730My 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 57590How many types of parameters are used in JCL and what are mandatory parameters of JOB statement.
IBM,
13 27674why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
3 9053Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
2 6367In 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 19027Can 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 22476
when does a dataset go uncataloged?
What is Pic 9v99 Indicates in COBOL?
Can I redefine an x(100) field with a field of x(200)?
What is cursor stability in db2?
Name the command used for terminating a browse operation?
How does db2 sample database connect?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is an OOK-Rec?
Explain about run unit currency?
How to execute stored procedure in db2 command editor?
What is downtime and what might be the reason?
When are scope terminators compulsory?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
