db2 中Literal Replacement怎么理解，一直不明白，能否舉例說明。

fuxc_666

關(guān)于Literal Replacement功能不知道怎么實(shí)現(xiàn)，我的理解是：常量替換，允許只有常量不同，但其他都相同的SQL語句共享一個(gè)公共section. 從而降低編譯成本。但不知道怎么才能實(shí)現(xiàn)，看到效果，請(qǐng)高手不吝指教！有相關(guān)的資料也可以！多謝！

ziggler

NCHAR String Literal Replacement

This section provides information on how to avoid data loss when performing NCHAR string literal replacement.
http://download.oracle.com/docs/ ... ch7progrunicode.htm

ziggler

NCHAR String Literal Replacement

This section provides information on how to avoid data loss when performing NCHAR string literal replacement.

Being part of a SQL or PL/SQL statement, the text of any literal, with or without the prefix N, is encoded in the same character set as the rest of the statement. On the client side, the statement is in the client character set, which is determined by the client character set defined in NLS_LANG, or specified in the OCIEnvNlsCreate() call, or predefined as UTF-16 in JDBC. On the server side the statement is in the database character set.

    *

      When the SQL or PL/SQL statement is transferred from client to the database server, its character set is converted accordingly. It is important to note that if the database character set does not contain all characters used in the text literals, then the data is lost in this conversion. This problem affects NCHAR string literals more than the CHAR text literals. This is because the N' literals are designed to be independent of the database charactser set, and should be able to provide any data that the client character set supports.

      To avoid data loss in conversion to an incompatible

fuxc_666

我剛看到回復(fù)的信息，我還是不太明白，鏈接中所說的，能否有個(gè)例子說明一下，多謝！