what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?2 2948
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 3112
Generally 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 5000
Can SQL statements/queries be included in a copybook?2 5840
If 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?
If 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 9020
What is the SQL query to select, delete and get count of duplicate rows in DB2?2 6980
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 3517
If 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 5063
What is the difference between Primary key and unique index?6 6825
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db23 6480
What is package versioning? Please give an example.1 3435
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)2 4227
In 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 14100
How do I change the column size in db2?
What is reorg and runstats in db2?
Can one database have multiple instances?
What is the purpose of rollback and commit?
What are foreign keys in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is isolation level in db2?
What is explain in db2?
Who uses db2?
What is temporal table in db2?
What is buffer pool and list some of them?
Discuss about db2 bind?
What is load replace in db2?
What is dbrm? What it contains?
How many databases are there?