Sybase 基本操作

 

--Sybase IQ创建数据库

create database 'd:\SysbaseIQ_data\iqdss.db'
transaction log on
collation '936zho'
page size 4096
java on
jconnect on
case respect
password case respect
iq path 'd:\SysbaseIQ_data\iqdss.iq'
iq size 1024
iq page size 131072
temporary path 'd:\SysbaseIQ_data\iqdss.iqtmp'
temporary size 2048
*******************************************************
--创建DBSPACE
create dbspace IQ_SYSTEM_MAIN1 as 'D:\SysbaseIQ_data\iqdss1.iq'
iq store size 512 reserve 128

sp_iqdbspace==>存储过程功能-->显示数据文件
*******************************************************
Sybase IQ 创建用户
Sybase有三种角色connect resource dba
grant connect to test_login1,test_login2 identified by aaaaaa,aaaaaa


*******************************************************
--删除DBSPACE
drop dbspace IQ_SYSTEM_MAIN1
*******************************************************
常用命令
select * from sysobjects--系统对象表 where type='P'

sp_iqstatus==>存储过程--现实系统信息~

select 11 from dummy-->伪表

执行存储过程打--> call 存储过程名
或者-->直接存储过程名
*******************************************************
---Sybase备份---
backup database full to'f:\sybasebackup.dmp'
backup database incremental since full to 'f:\sybasebackupsincefull.dmp'



D:\>start_asiq -n lzc -x tcpip{port=2639}

D:\>dbisql -c "uid=DBA;pwd=SQL;eng=lzc;dbn=utility_db"


restore database 'f:\SysbaseIQ_data1\lzc.db'
from 'f:\sybasebackupsincefull.dmp'
rename IQ_SYSTEM_MAIN to 'f:\SysbaseIQ_data1\lzc.iq'
rename IQ_SYSTEM_TEMP to 'f:\SysbaseIQ_data1\lzc.iqtmp'

原文：http://xuzhengjun.blog.ccidnet.com/blog-htm-itemid-209960-do-showone-type-blog-uid-15219.html