what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
2 3684When 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 3938Generally 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 6285If 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 12960If 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 11104Consider 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 4283If 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 6629why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
3 7509Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
2 5086In 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 16112
What are the full forms of spufi and dclgen and why are they used?
How would the varchar column remarks defined?
Explain about dbrm.
Define sqlca.
How do I connect my db2 database to ibm?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is netezza database?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Why db2 is called db2?
List out the three types of page locks that can be held.
When the like statement is used?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the use of db2 optimizer?
How does cobol compile db2 program?
What is the use of predicate?
