What will happen, while trying to close the closed cursor.
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What are the two types of logging in the db2 database? Explain them.
How to see the structure of db2 table??
What is DCLGEN ?
When will you chose to run RUNSTATS?
What is iseries database?
what is parm utility
How would one remove old reorg information from the DB2 catalog?
What do you mean by NOT NULL? When will you use it?
What are the advantages of using a PACKAGE?
How can you count the number of rows from a table tab?
Explain correlated sub-queries.