IBM Books

Administration Guide

Compound SQL

Compound SQL allows you to group several SQL statements into a single executable block. The SQL statements contained within the block (sub-statements) could be executed individually; however, by creating and executing a block of statements, you reduce the database manager overhead. For remote clients, compound SQL also reduces the number of requests that have to be transmitted across the network.

There are two types of compound SQL:

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]