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 4026If 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 9989For 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 8305
How is the value function used?
How to check table size in db2 sap?
What is meant by union and union all?
What is the use of commit in db2?
What is db2 plan table?
Define db2.
How to find the maximum value in a column in the db2 database?
What is package in db2 mainframe?
Define declaration generator (dclgen).
What is a db2 package?
What is null value in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What do you mean by storage group (stogroup)?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How is a typical db2 batch pgm executed?