2016: How to use LoadExternalDB to load DB/table/data online? Answer: You can use LoadExternalDB to load external DB into local DB directly via DSN.
If set unload external 'connection string', dmSQL will print "set external db ...
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 ...
2019: How to get all index columns via query? (DBMR3196) Answer: From DBMaker 5.4.3, we add a stored procedure command “showindex”. Enter below command, you can get the index column.
dmSQL> call showindex(owner_name, table_name);
Here is an example. ...
2019: How to get table schema via query? (DBMR3207) Answer: From DBMaker 5.4.3, you can get table schema via dmSQL or JDBA tool.
1. There is a table t1 in the database. Enter below command, you ...