Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Difference bw dynamic sql and static sql

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
sridevi_taurus

New User


Joined: 25 Jun 2006
Posts: 5
Location: hyderabad

PostPosted: Mon Jun 26, 2006 10:37 pm    Post subject: Difference bw dynamic sql and static sql
Reply with quote

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
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Wed Jun 28, 2006 8:04 am    Post subject: Re: dynamic sql and static sql
Reply with quote

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.
Back to top
View user's profile Send private message
sridevi_taurus

New User


Joined: 25 Jun 2006
Posts: 5
Location: hyderabad

PostPosted: Wed Jun 28, 2006 8:43 pm    Post subject: Re: dynamic sql and static sql
Reply with quote

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.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Thu Jun 29, 2006 2:43 am    Post subject: Re: Difference bw dynamic sql and static sql
Reply with quote

Now you've got it.

Yeah, SPUFI and QMF are a kind of dynamic SQL statements.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Thu Jun 29, 2006 3:21 am    Post subject: Re: Difference bw dynamic sql and static sql
Reply with quote

Hi Sridevi...

You may like to go thru this link for a complete reference on this...
Back to top
View user's profile Send private message
sridevi_taurus

New User


Joined: 25 Jun 2006
Posts: 5
Location: hyderabad

PostPosted: Sun Jul 16, 2006 1:45 pm    Post subject: Re: Difference bw dynamic sql and static sql
Reply with quote

Hi Priyesh,
icon_smile.gif 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
Back to top
View user's profile Send private message
ajeet799
Warnings : 1

New User


Joined: 16 Jul 2006
Posts: 1
Location: India

PostPosted: Sun Jul 16, 2006 5:22 pm    Post subject: Re: Difference bw dynamic sql and static sql
Reply with quote

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.......................... icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts REXX - Dynamic file Creation d_sarlie CLIST & REXX 7 Tue Jun 27, 2017 7:30 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm
No new posts Dynamic array request/response contai... Suja.Sai CICS 2 Tue Jan 24, 2017 11:37 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us