Advantages of dynamic SQL

Dynamic SQL permits a client application to act interactively, passing different information at different times to the Open Server application, from the user. The Open Server application can then fill in the missing pieces in the SQL query with the data the user provides.

For more information on how client applications use dynamic SQL, see the Embedded SQL/C Programmer’s Manual.