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 4198If 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 10353For 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 8530
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is check constraint. Explain with example.
What is meant by union and union all?
What is the use of with ur in db2?
How to take backup of table in db2?
What is a plan and package in db2?
Which component is responsible for db2 startup and shutdown?
How do you pull up a query which was previously saved in qmf?
What parameters are used to control the free space in DB2?
What is the difference between cursor and select statement?
What is release/acquire in bind?
How can deadlocks be resolved?
What are union and union all?
What are the contents of a dclmgen?
What is host variable?