Content in 2006

Page 2 out of 3 Pages

• How to investigate the reason if face deadlock problem? (From DBMR1703, version: DBMaker 4.1.2, OS: Windows XP Embedded SP1)

  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
  17 views
• In Oracle, user can write the following statement to implement the conversion from date type to char type, how can I do that in DBMaker? select * from QMDVFCMDBS where sts_tkystr = to_char(sysdate,'yyyymmdd')

  There also have conversion functions todate and datetostr in DBMaker which located in \DBMaker\x.x\shared\udf. It need user to create UDF
  18 views
• The SQL manual says: Use two consecutive single-quotes to include a single-quote character in a quoted string. It means that if we want to insert a data included single quote, we should use another quote as the escape character, but in the following statement which is in a my ESQL program, why do not I need single quote as escape sequence but I can still execute the program successfully? (From DBMR1702, version: DBMaker 4.1.6) sprintf(sChnkbn, "'A");

  If you use the following statement in ESQL, the single quote is seeing as escape sequence EXEC SQL insert into 1702(a,b)
  19 views
• 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 
  38 views
• 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
  13 views
• When execute an update command that the new data is large than the previous data, how does the DBMaker do?

  If the rest page space can contain new data, DBMaker will delete old data first then put new data in
  17 views
• 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
  29 views
• 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(?, ?, ?);");   
  28 views
• What is the limitation to the number of the command handles when using JDBC data source to connect to DBMaker?

  At present (DBMaster 4.16/4.20), DBMaker allows the maximum of the command handles is 257.  But after 4.21, 4.22, 4.3 and
  22 views
• How to confirm deamon of auto update statistics working(is there anything shown on process)?What is the trigger to let update statistics work(like how many records insert into table)?

  The statistics daemon launch at 3:00 am automatically if the DB_SVRST = 1 is set on dmconfig.ini when database start
  25 views

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

one category up