For Sybase

For Sybase
1.Down Load Address ; http://www.sybase.com/detail?id=1051287&elq=00000000000000000000000000000000
ase157_winx64.zip

2.install and create Database/Table
C:\Sybase\ASE-15_0\install\startsrv.exe   use for start server
C:\Sybase\OCS-15_0\bin\isql.exe  ./isql –U user –S pass  server

creat space for data and log, default is master
1>disk init                                
2>name=userdev,
3>physname=”c\userdata\userdev.dat”,
4>size=”500M”
5>go

1>disk init
2>name=logdev,
3>physname=”c\userdata\logdev.dat”,
4>size=”100M”
5>go

1>sp_diskdefault    ‘master’,  ‘defaultoff’
2>go                                                         
1>sp_diskdefault    ‘userdev’,  ‘defaulton’
2> go
1>sp_diskdefault    ‘logdev’,  ‘defaulton’
2>go
1>sp_password  null  ,  newpass
2>go

create database mydatabase
on userdev="200M"
log on logdev="20M"
go

CREATE TABLE einfotable(
eid  int  IDENTITY NOT NULL PRIMARY KEY ,
edate  datetime not null,
ddate  datetime not null,
eprice money not null,
eprice2 money not null,
eprice3 money not null,
eprice4 money not null,
eprice5 money not null,
phoneNum  varchar(20)  not null,
ename  varchar(20)  not null,
mark   varchar(30)  not null
)
go

insert into einfotable values(getdate(),getdate(),rand()*(10000),rand()*(10000) ,rand()*(10000) ,rand()*(10000) ,rand()*(10000) ,'13523423456','a1fasfsdfsadfsda','c33999999999999fdfhsdkfsdfdsfdd')
go 300000

when generate data, the log space is full, so we delete it use follow

dump transaction mydatabase with no_log 
go