What is the difference between static and dynamic SQL?

devquora
devquora

Posted On: Jun 19, 2021

 

Static SQL is also known as Embedded SQL is a database access procedure that is predetermined in the statement such that these SQL statements in an application do not change at runtime and can be hard-coded into the application. Whereas Dynamic SQL is SQL statements that are constructed at runtime and are less efficient such that the application may allow users to enter their own queries.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mainframe Interview Questions

    What is the difference between LINK and XCTL?

    Link is used to go from one module to another and then return to the first module such that the link to a module is used to provide the first some data. Whereas XCTL is used to go from one module with...

    Mainframe Interview Questions

    What is the difference between the MRO & ISC?

    MRO or Multiregion operation is influenced by the intercommunication facilities that you use with the connection and by your management of the connection. Whereas ISC or intersystem communication s sh...

    Mainframe Interview Questions

    What happens when a CICS command contains the NOHANDLE option?

    In CICS the NOHANDLE option is used to suspends the error handling that was specified in previous EXEC CICS HANDLE CONDITION commands but only for the command on which you put the NOHANDLE....