Sample ADS dialog using static SQL
Document ID :
Last Modified Date :
Show Technical Document Details
CA IDMS SQL:SQLOPT
This Knowledge Document contains source for a sample ADS dialog issuing static SQL.
SQL statements in an IDMS program can be static or dynamic.
Static SQL is compiled once when the access module is created (typically at dialog compile time).
Dynamic SQL is compiled every time the statement is executed which, the benefits of
Dynamic SQL Caching
notwithstanding, can be more expensive.
CA IDMS, all supported releases.
Download the source in the attached file and follow the instructions in readme.txt.
IDD DDDL Reference
CREATE ACCESS MODULE
Was this information helpful?