CA Datacom DDUPDATE or DDOL VERIFY function failed with error DDVTBL0046 TABLE LENGTH INVALID FOR ENCRYPTION. Why?

Document ID : KB000017874
Last Modified Date : 14/02/2018
Show Technical Document Details

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