embedded SQL

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."

Copyright © 1981-2025 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.