which SQL comment successfully removes uncommitted changes
from a DB2 database
A) rollback
B) delete
C) drop
D) decommit
- 2 Answers
- 13009 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What technique is used to retrieve data from more than one table in a single SQL statement?
how can we find nth max salary from A table
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 collection?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What is a NULL value? What are the pros and cons of using NULLS?
How do you stop a db2 database in linux?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
What is a trigger in the db2 database?
how do u update the faltfile into db2 table ?
Is it possible using max on a char column?
COBOL 
