Sample ADS dialog using static SQL

book

Article ID: 125763

calendar_today

Updated On:

Products

CA IDMS CA IDMS - Database CA IDMS - ADS

Issue/Introduction

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.

Environment

CA IDMS, all supported releases.

Resolution

Download the source in the attached file and follow the instructions in readme.txt.

Additional Information

IDD DDDL Reference
Mapping Facility
CREATE SCHEMA
ADSOBCOM
CREATE ACCESS MODULE

Attachments

1558537064031kb000125763.zip get_app