Difference bw dynamic sql and static sql

sridevi_taurus · New User Joined: 25 Jun 2006 Posts: 5 Location: hyderabad

Hi,
Can any one tell me whats the difference between dynamic sql and static sql. If any body could help me out that would be gr8.
Thanks in advance.
Regards,
Sridevi

priyesh.agrawal · Posted: Wed Jun 28, 2006 8:04 am

We are listening from our childhood that static means compile time and dynamic means Run time. Same is applied here too.
STATIC SQL statements are known at compile time, other hand DYNAMIC at Runtime.

STATIC SQL is hardcoded into the program, where you know what attributes are going to be used every time.
but in case of Dynamic SQL query may get mofified at the run time based on the values.

sridevi_taurus · New User Joined: 25 Jun 2006 Posts: 5 Location: hyderabad

hi,
So is it that SPUFI and QMF are dynamic and EXEC SQL- END EXEC statements embedded in the program are static? If so thanks for your response.
Regards
Sridevi.

priyesh.agrawal · Posted: Thu Jun 29, 2006 2:43 am

Now you've got it.

Yeah, SPUFI and QMF are a kind of dynamic SQL statements.

priyesh.agrawal · Posted: Thu Jun 29, 2006 3:21 am

Hi Sridevi...

You may like to go thru this link for a complete reference on this...

sridevi_taurus · New User Joined: 25 Jun 2006 Posts: 5 Location: hyderabad

Hi Priyesh,

Thanks! I have gone through the stuff.Its really good. Actually I was busy with my MCA sem exams, so could not respond immediately.
Neways, thanks.
Regards,
Sridevi

ajeet799 · New User Joined: 16 Jul 2006 Posts: 1 Location: India

statics is fast than dyanmic.

dyanmic is more flexible than static.

in statics after execution of program cursor never comes to initial postion.

but in dynamic cursor comes to the initial positon.

static is embedded .dynamic is non-embedded

i hope this is sufficient information 4 u..

ok by by..........................