Description:
When using the VERIFY function for a database occurrence either via CA Datacom Datadictionary Online (DDOL) or by using the batch utility DDUPDATE with a
1000 VERIFY, the following error set may result:
DDVTBL0046 TABLE LENGTH INVALID FOR ENCRYPTION
ENTITY=my-table-name
DDWTBL0029 TBL SQL ACCESSIBLE, VERIFY FAILED
ENTITY=my-table-name
Solution:
This problem may occur when the table has a record length less than 16.
TABLE LENGTH INVALID FOR ENCRYPTION
Reason:
The ENCRYPTION-TYPE attribute-value is B, E, or M but the LENGTH attribute value of the TABLE occurrence is less than the minimum of 16.
Action:
Either increase the length of the table or set the ENCRYPTION-TYPE attribute value to blank.
If you do not wish to increase the length of the table, batch DDUPDATE can be run to update the ENCRYPTION-TYPE attribute with the following:
-UPD DATACOM-INSTALL,NEWUSER
-UPG TABLE,my-table-name(TEST)
1500 ENCRYPTION-TYPE,&
1500 ENCRYPTION-METHOD,&
-END
-UPG TABLE,my-table-name(PROD)
1500 ENCRYPTION-TYPE,&
1500 ENCRYPTION-METHOD,&
-END