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

IEBPTPCH :: Merge PDS Members in a PS File.


IBM provides a utility, IEBPTPCH, to merge members of PDS (Partitioned Dataset) into a PS (Physical Sequential) file. However the sole purpose of this utility is to Print or Punch all or part of datasets (PS or PDS). So we will be needing at least one statement i.e. either PRINT or PUNCH in the sysin card. Since we are merging PDS members we will be specifying TYPORG=PO along with PRINT or PUNCH statements. TYPORG=PO indicates that the input dataset is ...