版次注意事項


|10.13 BIND

|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: | |


[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]