A CDE Definition
Software that turns SQL commands written within a source program into the appropriate function calls for the database management system (DBMS) being used. After the SQL precompiler stage, the resulting program is translated into machine language by the COBOL compiler or the compiler of whatever language the program is written in. See embedded SQL.
SQL statements that are written into a high-level programming language such as C or Pascal. In a preprocessing stage, the SQL code is converted into function calls, which may be optimized to provide the fastest results. If the programmer knows exactly what the query is going to do, and the query does not change, it is called "static SQL." If the query requires user input at runtime, it is called "dynamic SQL." If the client program passes the SQL statements directly to the database server without any intermediate step, it is called "passthrough SQL."
Before/After Your Search Term
|SQL Lite||square pixel|
Terms By Topic
Click any of the following categories for a list of fundamental terms.