Interested to Buy Any Domain ? << Click Here >> for more details...
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
2 4827When 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 5046Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
5 7971If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
RBS,
1 13966If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
2 12357Consider 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 5094If 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 8703why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
3 9041Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
2 6355In 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 18989
What is runstats db2?
What is clone table?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is db2 look?
What is precompiler in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Where do you specify them?
Name the various locking levels available?
What does sqlcabc has?
Can there be more than one cursor open for any program?
How would you find out the total number of rows in a db2 table?
What is a Foreign Key?
What is the difference between using bind () and rebind () methods of naming class?
How many databases are there?
What is the use of db2 optimizer?
