DB2 10.5 for Linux, UNIX, and Windows

SET PASSTHRU statement

The SET PASSTHRU statement opens and closes a session for submitting a data source's native SQL directly to that data source.

The statement is not under transaction control.

Invocation

This statement can be issued interactively. It is an executable statement that can be dynamically prepared.

Authorization

The privileges held by the authorization ID of the statement must provide authorization to:
  • Pass through to the data source
  • Satisfy security measures at the data source

Syntax

Read syntax diagramSkip visual syntax diagram
>>-SET PASSTHRU--+-server-name-+-------------------------------><
                 '-RESET-------'   

Description

server-name
Names the data source for which a pass-through session is to be opened. server-name must identify a data source that is described in the catalog.
RESET
Closes a pass-through session.

Notes

Examples