Content in 2007

Page 2 out of 4 Pages

• 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] $
  31 views
• How to check the status after starting DB with NT Service，and how to do when the service is on but the connect fail sometimes? (From DBMR1832)

  After starting DB with NT service, the DB is in the middle of starting with creating Journal, at present, only
  15 views
• What is the meaning of Low Value and High Value for column statistics? (From DBMR1813)

  You can see column statistics in JDBA Tool. For example: dmSQL> create table test(a serial); dmSQL> insert into test values(); 1 rows inserted dmSQL> insert
  22 views
• Why does the error 8349 occur? But the length of the data does not over the 1024 byte, although the index including a Varchar (2000) type column? And how to avoid this occur? (From DBMR1811)

  (1). First, when creating an index which including varchar type column, DBMaker does not check the length of this index. For
  29 views
• 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
  26 views
• Can DBMaker insert text file of UTF16 format into NCLOB column?

  Before inserting it into NCLOB, DBMaker converts the text file to Unicode first, so if the file is saved as
  19 views
• What the possible reasons that can cause the Client disconnect?

  The possible reasons may be: 1. Idle time out. 2. Server restarts. 3. Network issue. 4. Bug; if it is bug, the error should
  18 views
• 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
  27 views
• If wants to change the character set, should it need to reinstall DBMaker and recreate DB? And is there encoding method like NLS_LANG of Oracle, so that user can not have to recreate DB? (From DBMR 1805)

  If wants to change the character set, user only needs to recreate DB with new DB_LCODE. NLS_LANGE in Oracle is a
  20 views
• We can choose the character set when installing DBMaker, does it means we also choose the message file character set? (From DBMR 1805)

  There are two steps to choose language and character set during installing DBMaker. The character set only decides data stored format,
  21 views

• ⇤
  
• ←
  
• 1
  
• 2
  
• 3
  
• 4
  
• →
  
• ⇥

one category up