All categories
Add new FAQ
Add question
Open questions
Login
Sign up
Login
Advanced search
Advanced search
76 search results
Page 2 out of 8 Pages
2006
:
When execute an update command that the new data is large than the previous data,
Answer:
If the rest page space can contain new data, DBMaker will delete old data first then put new data in the same page position, if ...
2006
:
Why does the error occur sometimes when using cursor update in the ESQL application?
Answer:
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 ...
2006
:
In Oracle, user can write the following statement to implement the conversion from date type
Answer:
There also have conversion functions todate and datetostr in DBMaker which located in \DBMaker\x.x\shared\udf. It need user to create UDF first. Alternatively, you can implement it ...
2006
:
How to investigate the reason if face deadlock problem? (From DBMR1703, version: DBMaker 4.1.2, OS:
Answer:
To investigate the reason, you should monitor lock first, for example, as the following: dmSQL> select USER_NAME, TABLE_NAME, SYSLOCK.LK_OBJECT_ID, SYSLOCK.LK_GRAN, SYSLOCK.HOLD_LK_CONNECTION, SYSLOCK.LK_CURRENT_MODE from SYSLOCK, SYSTEM.SYSTABLE, SYSUSER where HOLD_LK_CONNECTION ...
2006
:
How to insert data that contain single quotes into NCLOB column?(From DBMR1711)
Answer:
The NCLOB data type is a variable length data type that can contain any Unicode character.When entering NCLOB data, it needs to enclose the Unicode ...
2007
:
Why the memory occupation reduced when minimized the dmserver window in Windows Platform? (From 1748)
Answer:
It should be windows’ behavior. Not only the dmserver can show the phenomenon, other applications such as Outlook or IE can also show the phenomenon. ...
2007
:
What are the general steps about installing DBMaker Client and DSN on Windows platform manually?
Answer:
Generally, there are 4 steps to install DBMaker client and DSN; they are as following (take DBMaker 4.16 for example) Step1: Copy Files,insure the following files ...
2007
:
What are the general steps about installing DBMaker Driver and DSN on Windows platform manually?
Answer:
Generally, there are 4 steps to install DBMaker Driver and DSN; they are as following (take DBMaker 4.16 for example) Step1:Copy Files, insure the following files ...
2007
:
How is the ALTER TABLE statement treated by DBMaker internally? (From DBMR1740)
Answer:
1. Before DBMaker 4.1x (include 4.1x) series, 'ALTER TABLE' statement should copy another internal table (select into), so it occupies double disk space and writes into journal ...
2007
:
Can the Shift-JIS and EUC-JP data be stored in the same DB or same table?
Answer:
At present, it is impossible in DBMaker 4.x and it may be come true in DBMaker 5.0. And now, the Shift-JIS and EUC-JP data can ...
⇤
←
1
2
3
4
5
6
7
8
→
⇥
Search in ...
... all categories
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
Search
search in all languages
The most popular searches are:
cannot+extend+a+file:+disk+full+or+disk+failure
25247x
show+table
14651x
connect+linux+from+windows
12953x
"journal full"
3009x
JOURNAL FULL
1943x
ERROR+1704
1472x
dci
162x
配置
145x
connect+windows+linux
70x
数据库
66x