Content in 2005

Page 2 out of 3 Pages

• What should the program do when calling the ODBC functions and the returned SQL code is SQL_ERROR or SQL_SUSSESS_WITH_INFO? Does it need error handling?

  Yes, the program should do error handling. First, customer can use the SQLERROR() to      get the details about the
  20 views
• 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
  27 views
• How does the inside of the DBMaker deal with when insert BLOB data repeatedly? Does it share the BOLB data when the inserted BLOB data is same?

  DBMaker will store only a single LO and share it between the tuples, If the same LO data is contained
  13 views
• How can I access DBMaker if I didn’t register the DSN?

  If you didn’t register the DSN ,you should use indiscriminately the                                   following connection string when you
  24 views
• Does DBMaker have simple method in command line that can output the data to text file of csv type?

  Yes, you can use JDATATransfer tools to achieve this purpose, please refer the usage of JDATATransfer. DBMaker will add this
  13 views
• 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
  25 views
• Does DBMaker kill any active session forcibly When DBMaker DB is shut down by terminate DB command?

  Yes, it kills any active session forcibly when DB is shut down by terminate DB command.
  12 views
• 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
  27 views
• Are there two DBMaker.bin processes started by default when we start database? 1. And when the user connects to Database, does the child process start one by one? 2. If the users want to check whether Database is alive or not, can they use the number of alive processes by PS command in LINUX? (If the number of DBMaker.bin process is under 2, Does it means that Database is dead?)

  By default, when DBMaker is started, three processes started in Linux; one is the primary process by which we can
  25 views
• When and how does DBMaker use user order file (EBCDIC_stroke.ord)?

  To use the user defined Order, user should put the order file they defined into $DBMaker_Home/shared/codeorder. And then, use the
  16 views

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

one category up