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 13965If 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 8700why 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 6353In 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 18988
Why db2 is called db2?
When the like statement is used?
How to find the number of rows in a db2 table?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Where can you declare a cursor in a cobol-db2 program?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How do I add a column to a table in db2?
How can you classify the locks in db2?
What is ibm db2 connect?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is copy pending status in db2?
What is runstats utility in db2?
Which components manage deadlocks in db2?
What is difference between rollback and commit?
Who uses db2?
