Previous Topic: Coding ConsiderationsNext Topic: Adding and Replacing Data on SQL Tables


JCL Considerations

SQL updates take place in CV mode, which automatically provides full database recovery. Local mode updates are possible if the central version is down and the areas are unlocked. Consult your database administrator to establish local mode backup and recovery procedures before attempting local mode SQL updates.

Either one-step or five-step CA Culprit JCL can be used. If running five-step, then SYSCTL and SYSIDMS statements are required for PGM=CULL and PGM=CULE.