What is EDITPROC parameter/Clause?

From IBM redbooks, the following information is written.

Specifying the edit routine routine To name an edit routine for a table, use the EDITPROC clause of the CREATE TABLE statement, followed by the name of the routine. If you plan to use an edit routine, specify it when you create the table. In operation, the routine is loaded on demand. You cannot add an edit routine to a table that already exists: you must drop the table and re-create it. Also, you cannot alter a table with an edit routine to add a column. Again, you must drop the table and re-create it, and presumably also alter the edit routine in some way to account for the new column.

A LOB, DECFLOAT, or XML column cannot be defined in a table that has an EDITPROC.

v A ROWID column cannot be a column in a table with an EDITPROC.

EDITPROC If the table requires an EDITPROC (Edit procedure) it can be
specified here. The default is not to use an EDITPROC. An
EDITPROC translates the data within DB2 at the row level, prior to
presentation to the user.

The CREATE TABLE statement cannot specify an
EDITPROC for a table that has an identity column.

The IBM Data Encryption Tool for IMS and DB2 Databases supports all versions of DB2 but
only encrypts the whole row. No application changes are required, however the DDL must be
modified to include the EDITPROC. The applications do not need to be aware of encryption
keys.

In DB2, the IBM Data Encryption tool implements encryption through the standard
EDITPROC exit.

EDITPROC は多くの場合データ圧縮のために用いられるが、データ圧縮
目的のためにはDB2 V4 以降表スペース定義上でのCOMPRESS オプション
がサポートされている。こちらはユーザー側でルーチンを用意する必要がな
く、ハードウェア環境に寄っては非常に高速なハードウェアによる圧縮・解
凍が使用される。
よって基本的に圧縮目的でのEDITPROC は使用禁止とし、COMPRESS
オプションを使用するものとする。
なお、圧縮以外の目的でEDITPROC を使用せねばならない場合は、ADM
技術DB2 担当者へ連絡の上協議が必要とする。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21018850/viewspace-1020197/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21018850/viewspace-1020197/