The RDB package consistency token verifies that the requester's application and the relational database package are synchronized. The owner must have the privileges required to execute the SQL statements in the package. Specify NOPRE if creating an executable or shared object file; otherwise, you may have link problems.
This ensures problems caused by qualification where two or more host variables have identical names when not qualified are avoided but has the side-effect that DB2 error messages sometimes display the names of host variables with the three additional characters appended to them. The default is the owner's authorization ID. The default value is 5. REOPT Specifies whether or not to have DB2 optimize an access path using values for host variables, parameter markers, global variables, and special registers.
The version identifier specifies which version of the package is to be replaced. Maximum length is characters. TEXT The description of a package. The default value is blanks. This is a SQL identifier up to 18 characters in length.
The package owner authorization ID is used for validity checking. Parent topic: DB2. Related concepts DB2 Compiler Directive. Online Tutorials. First, it checks the SQL in the program for errors.
Second, it adds working storage areas and source code compatible statements that are used to invoke DB2. One of the working storage areas contains a literal "timestamp" called a consistency token.
The code is checked for errors, and a compiled version of the code is created. Imbedded in this module is the same consistency token that was generated in the precompile.
0コメント