Static & Dynamic SQL in COBOL :: A Walk-Through


COBOL allows SQL queries to be executed both Statically and dynamically. However it’s often confusing that when Static SQL is to be used and when ¬†Dynamic SQL. This will be quite clear once you know the exact difference between the two. Difference Between Static & Dynamic SQL: Static SQL SQL is static when we know the SQL Statements in advance i.e. we know what query to perform on which table under what conditions.¬†For e.g. consider a table name “STUDENT” which ...