2016: How to encrypt table records for only some columns? Answer: Can encrypt some columns with encryption UDF as following.
A. create function LIBCRYPT.AES_ENCRYPT(string,string) returns string;
create function LIBCRYPT.AES_DECRYPT(string,string) returns string;
B. insert into tableXX(columnXX) values(AES_ENCRYPT(‘XXXXXX’, 'user_defined_key'));
Or update ...
2017: How to make a batch script for rebuilding all indexes? (DBMR2924) Answer:
Enter follow SQL commands to check and rebuild all indexes. For example, there is a database including five indexes.
Check “CREATE_TIME” of original indexes.
dmSQL> SELECT CREATE_TIME, ...
2017: Why load external DB returned Segmentation fault at powerpc? Answer: The unixODBC installing package for powerpc didn't include libodbc.so. You need to create the symbolic link manually. Enter below commands:
$ cd /usr/lib/powerpc64le-linux-gnu
$ ln -s libodbc.so.1.0.0 ...
2017: Is DCI compatible with Acucobol v10? (DBMR2939) Answer:
DBMaker 5.4.2 or later version supports ACUCOBOL-GT 10. User can link dmacu90 library in Linux. Please refer the setup steps from DCI_README.TXT.
Notice: Please do NOT ...