How to connect to db2 database from windows command line?
Where are plans stored?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What is a NULL value? What are the pros and cons of using NULLS?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
Which components manage deadlocks in db2?
What is db2 bind process?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
difference between group clause and order clause
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What are some SQL aggregates and other built-in functions?