Which command is used to remove all rows from a table?
No Answer is Posted For this Question
Be the First to Post Answer
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 a synonym? How is it used?
What is the use of db2?
What is the use of db2 optimizer?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
The only place of VSAM KSDS in DB2 is?
is it compulsory commitment control in journal?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is a cursor in programming?
What is clone table?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.