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 ...
2019: How to export and import data to JSON format? Answer: Enter below code to create store procedure “EXPORTJSON”. This stored procedure can export table to JSON format.
dmSQL> set block delimiter @@;
dmSQL> @@
CREATE OR REPLACE PROCEDURE ...
2019: How to fix invalid view? (DBMR3289) Answer: If you dropped the table, then recreated the table, the view which was based on the table became invalid view. When you select the invalid ...