Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is static sql? what is dynamic sql? Give me details

Answer Posted / yuvaevergreen

>>static sql is hard coded in the cobol program. The static
sql is syntax checked,separately processed and executable
format of the sql is made ready by the precompiler even the
before the cobol program is compiled.
>>dynamic sql,though precompiled like static sql but they
are prepared and executed at run time. sql is of string
format and executed by SQL PREPARE or EXECUTE IMMEDIATE
statement.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the bind parameters ibm db2?

1053


What is cursor stability in db2?

1356


What is cursor with hold option in db2?

1072


Explain about mirror activator disk mirroring?

1009


How to check table size in db2 sap?

1039


Mention the different locking levels that are available in db2.

1134


How do I add a column to a table in db2?

1104


What is database reorganization?

1125


What is deadlock in db2?

1069


What are the various data types available in db2?

1094


What is the syntax for creating a table in the db2 database?

1105


What is runstats utility in db2?

1019


What does db2 stand for?

1025


What does sqlcabc has?

1054


Mention data types used in db2 ?

1156