Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
1 3259If 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
ADP,
4 8483For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
2 7186
List down the types of triggers in the db2 database?
What are the rules for db2 programming?
What is meant by explain?
How to execute stored procedures?
Who uses db2?
What is the use of with ur in db2?
What is the difference between spufi and qmf?
What parameters are used to control the free space in DB2?
What is runstats and reorg in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Highlight all the advantages that are attached to a package.
What is explain in db2?
How to resolve deadlock issue
Explain how can you do the explain of a dynamic sql statement?
What is the maximum No of rows per page?