2005: Would you please give me some notes for DB design? Answer: System Structure:
This requirement is configured almost same as others. You need to consider:
(1) Using 3-tier or Server/Client to reduce the loading of Database Server,
(2) Using ...
2005: How to rebuild DATABASE by shell script? Could you give me some sample scripts Answer: 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 INTO SYSADM.Card VALUES (?,?,?,?,?) ;1, ...
2005: How to decide the value of the FILLFACTOR? Answer: Deciding appropriate FILLFACTOR is very case-dependent. Here are some rules of thumb.
If a table fits one of the following criteria,
set a larger FILLFACTOR for ...
2005: How to change the file extension of SFO in PHP program? Answer: 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,
"insert into php_fotest values(?,?)");
odbc_exec($conn, ...