Content in 2005

Page 1 out of 3 Pages

• If there are several journal files and switch current journal file to next one, does the checkpoint occur?

  Yes, when writing journal buffer into journal file (check point) and find the journal file does not have enough space,
  18 views
• If the db shutdown abnormally, does DBMaker do instance recovery?

  If DB is abnormal shutdown, maybe the page buffer data will not write into data file. After the DB started,the
  27 views
• Can DBLINK connect 4.14 and 4.16; is there any difference between DBLINK connecting same versions and DBLINK connecting different versions?

  Yes, DBLINK can connect 4.14 and 4.16, i.e. there is no difference for DBLINK connecting whether the same versions or
  16 views
• Can 4.1.4 and 4.1.6 coexist on one OS?

  No, they can not coexist on the same OS. Otherwise, the ODBC driver ofthe previous installed version will be rewritten
  15 views
• 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
  17 views
• 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,                                     
  13 views
• 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,
  19 views
• What is the function of the FillFACTOR parameter when create table?

  The FILLFACTOR feature optimizes the utilization of space for data pages byreserving space for the expansion of existing records. When
  16 views
• How to deal the error handling in VB program when there appear SQL_ERROR or SQL_SUCCESS_WITH_INFO?

  It uses adodb.sqlerror object instead of err object to get the native errors from the          DBMaker for that err object
  15 views
• How to deal the error handling in VC program when there appear SQL_ERROR or SQL_SUCCESS_WITH_INFO?

  It needs the program to do the estimation. If the SQLCODE=-1. It should write thecode to deal with the error handling.
  17 views

• 1
  
• 2
  
• 3
  
• →
  
• ⇥

one category up