How to find the number of rows in a db2 table?
Answer / Yudhishthir Singh
To find the number of rows in a table in DB2, you can use the SQL SELECT COUNT*(*) command. For example: `SELECT COUNT*(*) FROM TABLE_NAME;`
| Is This Answer Correct ? | 0 Yes | 0 No |
How to create a table using embedded sql?
Name the various locking levels available?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Explain packages.
pls explain the precompilation process of cobol-db2 pgm
What is a collection in db2?
What are the disadvantages of using VARCHAR?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
what is Static and dynamic linking
What will happen, while trying to close the closed cursor.
What is the FREE command?
What are the various locks available?