How can you count the number of rows from a table tab?
No Answer is Posted For this Question
Be the First to Post Answer
What is a cursor in programming?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
What is rct?
If I have a view which is a join of two or more tables, can this view be updatable?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What's the maximum number of volumes that can be added to a STOGROUP?
How would the varchar column remarks defined?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)