Sybase 笔记

 

//启动数据库

C:/Program Files/Sybase/ASIQ-12_7/demo>start_asiq -n uti -x tcpip{port=2639)

 

//链接数据库

C:/Program Files/Sybase/ASIQ-12_7/demo>dbisql -c "uid=dba;pwd=sql;eng=uti_xw;dbn=utility_db"

 

//建立自己的数据库

CREATE DATABASE 'C:/Program Files/Sybase/IQ_data/iqdss.db'

TRANSACTION LOG ON

COLLATION '936ZHO'

PAGE SIZE 4096

JAVA ON

JCONNECT ON

CASE RESPECT

PASSWORD CASE RESPECT

IQ PATH 'C:/Program Files/Sybase/IQ_data/iqdss.iq'

IQ SIZE 1024

IQ PAGE SIZE 131072

TEMPORARY PATH 'C:/Program Files/Sybase/IQ_data/iqdss.iqtmp'

TEMPORARY SIZE 2048

 

//启动自己的数据库

C:/Program Files/Sybase/IQ_data>start_asiq iqdss.db -n xwdemo -x tcpip{port=2390}

 

dbisql -c "uid=DBA;pwd=SQL;eng= xwdemo"