What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

705

Why select is not preferred in embedded sql programs?

710

Define declaration generator (dclgen).

665

What is nvl in db2?

624

List out the three types of page locks that can be held.

685

What is difference between isnull and coalesce?

618

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7504

What is with ur in db2?

753

What is cursor with hold option in db2?

612

How would you find out the total number of rows in a db2 table?

574

is it compulsory commitment control in journal?

2007

What is bind and rebind in db2?

646

How to compare data between two tables in db2?

658

What is a bind card?

679

How to connect to db2 database from windows command line?

560