Questions in 2005

english version for 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?
  (77 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?
  (310 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?
  (32 views)
• How can I access DBMaker if I didn’t register the DSN?
  (30 views)
• Does DBMaker have simple method in command line that can output the data to text file of csv type?
  (332 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)
  (73 views)
• Does DBMaker kill any active session forcibly When DBMaker DB is shut down by terminate DB command?
  (30 views)
• How to rebuild DATABASE by shell script? Could you give me some sample scripts for it?
  (333 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?)
  (180 views)
• When and how does DBMaker use user order file (EBCDIC_stroke.ord)?
  (317 views)

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