All categories
Add new FAQ
Add question
Open questions
Login
Sign up
Login
Search
Advanced search
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
2005
english version for 2005
Subcategories