Sitemap
How to rebuild DATABASE by shell script? Could you give me some sample scripts for it?
Please refer the ${dbmaker_home}\samples\DATABASE\init.sql.CREATE DB DBSAMPLE4;CREATE TABLE SYSADM.Card ( NumSERIAL(1) PRIMARY KEY,FirstName VARCHAR(30), LastName VARCHAR(30),TitleVARCHAR(30), BMp LONG VARBINARY) IN DEFTABLESPACE;INSERT INTO SYSADM.Card VALUES (?,?,?,?,?) ;1, ...
Is there any bug about this kind of SQL, and what kind of result shall we get from the following SQL statement?
select * from (select * from t1 where a=1) a1 left join t2 b1 on (a1.a=b1.a)
Is the following SQL different meaning from the above SQL?
select * from t1 left join t2 on (t1.a=1 and t1.a=t2.a)
The SQL statement 'select * from (select * from t1 where a=1) a1 left join t2 b1 on (a1.a=b1.a)' and 'select * from t1 left ...
After dropping table and loading table, using update statistics table and update statistics separately; why the execute time of the latter is shorter than the former’s? Are the disposal methods in the DBMaker different between the two? And besides the data of the systablespace, what other systamcatalog will be updated when executing update statistics?
The disposal methods between the update statistics and update statistics table are different. Because that the update statistics will update all the table’s column, index ...
What can I do if the number of the command handles in my application over the limitation?
User should modify their application to prepare once and execute n times.
For example:
ps2 = this.conn.prepareStatement("insert into TESTDB values(?, ?, ?);");
for(int i=0; i<list.size();i++)
{
tData ...
How does the DBMaker find free page if the present page is full when an insert command is executed?
DBMaker will keep previous inserted page id (hint page) internally, when next insertSQL executes, DBMaker will find out this page to insert first, if the ...
Why does the error occur sometimes when using cursor update in the ESQL application?
For example:
We have a table with schema:
dmSQL> def table card1;
create table SYSADM.CARD1 (
NUM SERIAL(1),
DD INTEGER not null,
EE CHAR(1) not null,
FIRSTNAME VARCHAR(30) not null,
LASTNAME VARCHAR(30) not ...
In DBMaker Stored procedure, If use the temporary table to save the result set, how to deal the temporary table, (when to drop it)? (From DBMR 1800)
The temporary table just exists in current session; DBMaker will automatically drop the temporary table when exiting current session. So if use the temporary table ...
Is there some method to make the serial number be reset automatically when it over the maximum value? (From DBMR1836)
By Stored Procedure and trigger can achieve that.
For example: suppose there is a table named t1: t1 (c1 serial)
[Stored Procedure]
$ create procedure sp1(char(32) tbname, int ...
What kind of action use memory space other than DCCA? (From DBMR 1839)
Each connection will be allocated one private memory not in DCCA but on DB Server side to save private data, such as sort data.
ITT is ...
Does the order of the lib files matter when you build the wrun32.dll?
In AcuGT5.x, if adding the DCI libraries in the following order: dmapi50.lib dmacu52.lib and dmdcic.lib (make sure the dmapi50.lib is the first one of those ...
Can you explain about setting parameter and saving setting in dmSQL? (From DBMR 1887)
After launching dmSQL, there are some default settings, such as AUTOCOMMIT, LOCK TIMEOUT, and LINEWIDTH and so on. Some of these settings are saved in ...
How to output query result with CSV format? (DBMR: 1893, version: DBMaker 4.3.2 bundle)
Export command only provides syntax with basic table,
EXPORT [INTO data-file]
TABLE table-name
[DESCRIPTION description-file]
[LOG log-file]
[STOP_ON_ERROR],
and does not support export query result.
Considering performance, they ...
Is it possible to zip/unzip for backup and recovery?
Because zip backup file feature should depend on backup server or JServer Manager Tool if setting DB_BKZIP on, so rollover (command line utility) does not ...
Will these DBMaker routine transactions including online full/incremental backup and update statistics compete against each other?
All the DBMaker transactions depend on Journal system, and so do update statistics, online full /incremental backup also follow journal (undo/redo) to backup files, soit's no problem ...
When compiling PHP with DBMaker, the error “undefined reference to ´__ctype_b'” happens, what is the reason and how to do? (DBMR 1946, Version; DBMaker 4.2)
This error is not DBMaker's problem; it is from Linux glibc version issue. DBMaker use glibc-2.1 to make our static library, but glibc-2.3 removes some ...
What’s parameters setting and reference sequence for application program access DBMaker? (DBMR2057)
Connection String not only include the essential information for connect to Database but also include some correlative connection option for Database setting, such as LCODE ...
How to upgrade License for DBMaker?
Upgrade license can increase the number of concurrent users when you purchased DBMaker.You can upgrade license after you received your upgrade license serial number. Follow ...
How to backup file objects? Can users restore a database without backing up file objects? (DBMR2241)
Users can specify the file object (FO) backup mode by setting the keyword DB_BkFom for a full backup.
DB_BkFoM = 0: Don’t back up file ...
How to solve “ERROR (1110): Requested DCCA memory exceeds system maximum” in Linux?
This error occurs in Unix when the DCCA memory requested by the database exceeds the maximum amount of shared memory allocated by the operating system.
To ...
With MF Visual Studio, how to use the WHERE condition in DCI both for main program and sub program (DBMR2608)
Fill in “nofcd3 createxfd callfh "DBMAKERINTF.dll"” in the “Additional directives” field in the property page of the program, and put DBMAKERINTF.dll in the folder where ...
Why and How to rebuild Primary Key?
When face such as below questions we can also consider to rebuild primary key.
For example:
Too much index expansion to cause the performance down (IO and ...