版次注意事項
|The command syntax for DB2 should be modified to show the federated parameter
|as follows:
|FEDERATED--+--NO--+--
| '-YES--'
|
|
- |FEDERATED
- |Specifies whether a static SQL statement in a package references a nickname
|or a federated view. If this option is not specified and a static SQL statement
|in the package references a nickname or a federated view, a warning is returned
|and the package is created.
|
- |NO
- |A nickname or federated view is not referenced in the static SQL statements
|of the package. If a nickname or federated view is encountered in a static
|SQL statement during the prepare or bind of this package, an error is returned
|and the package is not created.
|
|
- |YES
- |A nickname or federated view can be referenced in the static SQL statements
|of the package. If no nicknames or federated views are encountered in static
|SQL statements during the prepare or bind of the package, no errors or warnings
|are returned and the package is created.
|
|
- |Note:
- In Version 7 FixPak 2, an SQL1179W warning message is generated
|by the server when precompiling a source file or binding a bind file without
|specifying a value for the FEDERATED option. The same message is generated
|when the source file or bind file includes static SQL references to a nickname.
|There are two exceptions:
|
- |For clients that are at an earlier FixPak than Version 7 FixPak 2 or for
|downlevel clients, the sqlaprep() API does not report this SQL1179W warning
|in the message file. The Command Line Processor PRECOMPILE command also does
|not output the warning in this case.
- |For clients that are at an earlier FixPak than Version 7 FixPak 2 or for
|downlevel clients, the sqlabndx API does report this SQL1179W warning in the
|message file. However, the message file also incorrectly includes an SQL0092N
|message indicating that no package was created. This is not correct as the
|package is indeed created. The Command Line Processor BIND command returns
|the same erroneous warning.
|
|
[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]