Tuesday, December 8, 2009

Interview Q?

Dynamic sql:
Dynamic SQL is generally used for sending SQL statements to the database
manager from interactive query building graphical user interfaces and
SQL command line processors as well as from applications where the complete
structure of queries is not known at application compilation time and
the programming API supports dynamic SQL.

ynamic SQL can be used from the following interfaces:
Applications and external routines that employ APIs that support dynamic SQL including: Embedded SQL, JDBC, CLI, ADO.NET
Interactive DB2 GUI interfaces including: DB2 Command Editor in the DB2 Control Center
DB2 Command Line Processor
DB2 Command Windows


Commit inside trigger:

Yes, We can used commit inside trigger.
For that required to use set pragma_ananomous on;