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 4129If 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 10190For 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 8443
What is lock escalation in db2?
What's The Percentage Free Space ?
What are the uses of db2 optimizer?
Can we update view in db2?
What is cursor with hold option in db2?
How to find the maximum value in a column in the db2 database?
How does a cursor work?
What is the default page size of buffer pools?
What is phantom read in db2?
How to get the ddl of a table in db2?
Give the name of some fields form sqlca.
What is schema in db2?
What language is db2 written in?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What do you mean by between and in? Is between inclusive of specified range values?