Sample IDMS dynamic SQL program for update statements

Products

• IDMS

Issue/Introduction

This article contains a sample IDMS batch program which shows how to use dynamic parameter substitution to issue dynamic SQL when the statement is not a SELECT. This means the statement will only need to be PREPAREd (compiled) once and can be EXECUTEd multiple times, so that it can take advantage of SQL caching.

Environment

Release: All supported releases.

Resolution

Download the attached file.

Additional Information

PTF SO08292 is required for SQL caching to support INSERT statements.