kaviarasu

• Aug 14th, 2006

 

DIFFERENCE BETWEEN DYNAMIC(interactive) and STATIC(embedded) SQL :

The difference is the time at which the BIND occurs.

In static mode, the bind is done prior to the execution and is stored in a PLAN.

In dynamic mode, the BIND occurs at execution time.

This results in additional overhead which degrades performance.

This form of dynamic SQL will NOT be used in our environment

kalone

 Profile Answers by kalone 

• Feb 1st, 2010

 

STATIC sql(embedded) : It is hardcoded in the program itself and the changeable

                                       value is the value in the host variables.

DYNAMIC sql : It has the capability of changing the columns,tables during the

                          execution of prg.
                          It doesnt contain any host variables.

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar 

• Jul 27th, 2012

 

Embedded SQL -> Access Path is generated during BIND time. also table authorizations are checked during BIND (if VALIDATE(BIND) is used).

Dynamic SQL => Access path is generated during Run-time. Table authorizations can only be checked during run-time.