How can I access DBMaker if I didn’t register the DSN?
If you didn’t register the DSN ,you should use indiscriminately the following connection string when you use ADO：
strConn="Driver=DBMaker4.1Driver;DATABASE=Dbsample4;SvAdr=192.168.0.164;PtNum=8888;UID=sysadm;Pwd=;ATCMT=1;"
You ...
How to decide the value of the FILLFACTOR?
Deciding appropriate FILLFACTOR is very case-dependent. Here are some rules of thumb.
If a table fits one of the following criteria,
set a larger FILLFACTOR for ...
How to change the file extension of SFO in PHP program?
Following is the sample:
$conn=odbc_connect("nba","SYSADM","");
if($conn)
{
error_reporting(0);
odbc_do($conn,"drop table php_fotest");
error_reporting(7);
$res1=odbc_do($conn,
"create table php_fotest(c1 int,c2 file)");
if($res1){
$res=odbc_prepare($conn,
"insert into php_fotest values(?,?)");
odbc_exec($conn, ...
How to migrate the database from 3.x to 4.x?
You can use the Unload/load commend to implement the migration, i.e. first unload the database from 3.x, and then load it to the 4.x. following ...
How does DBMaker deal with the delete command?
In DBMaker, every record has a structure, DBMaker just mark one of them to ''delete'’ flag, the data still exist in page (customer cannot see ...
How to disconnect the useless sessions? (From MR1809)
To disconnect the connection automatically, DBMaker supports two keywords DB_ITimO and DB_DtClt.
The keyword DB_ITimO is used in Server side. DB_ITimO specifies the idle timeout interval, ...
How to use Java stored procedure in 4.3.3 bundle version? (DBMR 1912)
Suppose the HOME directory is: C:\dbmaker\43bundle.
Workaround for building Java sp with 4.3.3 bundle as follows:
(1) Copy jre folder from normal to bundle (C:\dbmaker\43bundle\jre)
(2) Copy dmclassloader.jar ...
How to hide the dmsql tool window to final user?
To hide the dmsql window, developer can add the following command to script file.
d:\dbmaker\5.0\bin\dmSQL32.exe /b
The parameter /b can help to hide console, then remember to add ...
How to avoid the use of high-frequency characters 3?
First, user should backup the file tw.tab which located in c:\dbmaker\4.3\shared\stopword\ tw.tab, then open tw.tab and delete following contents.
0
1
2
3
4
5
6
7
8
9
10
After that, rename tw.tab to stopword.tab.(xx.tab user ...
How to use the date in the format of "dd/mm/yyyy" or "dd-mm-yyyy" in DBMaker? (DBMR2773)
Users set DB_DaoFm in dmconfig.ini to control the date output format. Now DBMaker supports the following date formats.
mm/dd/yy
mm-dd-yy
dd/mon/yy
dd-mon-yy
mm/dd/yyyy
mm-dd-yyyy
yyyy/mm/dd
yyy-mm-dd
dd/mon/yyyy
dd-mon-yyyy
dd.mm.yyyy
DBMaker doesn't support "dd/mm/yyyy" or "dd-mm-yyyy", but users ...
How to avoid crash errors for executing a DCI case with isCOBOL2016R1? (DBMR2783)
When users execute DCI case in command lines, an error happens as following:
>java.exe ISMIGRATE
Exception in thread "main" java.lang.UnsatisfiedLinkError: com.iscobol.dci.Dci.dci__getenv(I[B[B)I
at com.iscobol.dci.Dci.dci__getenv(Native Method)
at com.iscobol.lib.DCI_GETENV.call(DCI_GETENV.java:43)
at com.iscobol.lib.DCI_GETENV.call(DCI_GETENV.java:24)
at com.iscobol.rts.Factory.call(Factory.java:3780)
at com.iscobol.rts.Factory.call(Factory.java:3689)
at ...
How to use sleep function in SQL statements?
We support an UDF function sleep () for sleeping a while.
For example:
dmSQL> create function to_date.sleep(int) returns int;
dmSQL> select sleep(5);//sleep 5 seconds
Version: 5.3.x, 5.4.x
Product: Normal/Bundle
Platform: Windows/Linux ...
How to encrypt table records for only some columns?
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 ...
How to make the uncommitted records rollback in slave DB?
If master database terminated db before some transactions hadn’t been committed, theseuncommitted records had been existed in slave database and didn’t be rollback automatically. You ...
How to install JDBC type3 as Windows Service? (DBMR3162)
1. Unzip attached JettyService.zip (3 files) in dbmaker\5.4\jetty
a. install-service.bat
b. JettyService.exe
c. bin\JettyService.exe
2. Run cmd as Administrator
> cd dbmaker\5.4\jetty
> install-service.bat
Note: you ...
How to get all index columns via query? (DBMR3196)
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. ...
How to get table schema via query? (DBMR3207)
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 ...
How to export and import data to JSON format?
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 ...
How to fix invalid view? (DBMR3289)
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 ...