CURRENT PACKAGESET special register

CURRENT PACKAGESET specifies an empty string, a string of blanks, or the collection ID of the package that will be used to execute SQL statements.

The data type is VARCHAR(128).

The initial value of CURRENT PACKAGESET is an empty string. The value is a collection ID only if the application process has explicitly specified a collection ID by means of the SET CURRENT PACKAGESET statement.

The initial value of CURRENT PACKAGESET in a user-defined function or stored procedure is inherited according to the rules in Table 1.

Example: Before passing control to another program, identify the collection ID for its package as ALPHA.

  EXEC SQL SET CURRENT PACKAGESET = 'ALPHA';