Series: Subject: Topic:
Question: 83 of 207

Difference between Embedded SQL and Dynamic SQL?

Asked by: Interview Candidate | Asked on: Jun 24th, 2006
Showing Answers 1 - 3 of 3 Answers

Answered On : 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

Yes  2 Users have rated as useful.
Login to rate this answer.

Answered On : Feb 1st, 2010

View all answers by kalone

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.

Yes  1 User has rated as useful.
Login to rate this answer.

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.

Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.