Articles‎ > ‎ASE 15.7‎ > ‎

Test: Transfer Table ...

I Know: this is not new features in ASE 15.7, as it appears in ASE 15.5...

1> use TEST
2> go

1> select * into toto from sysobjects
2> go

1> transfer table toto to "/opt/sybase/data/toto.ase" for ase
2> go
(31 rows affected)

1> select * into titi from toto where 0=1
2> go

1> transfer table titi from  "/opt/sybase/data/toto.ase" for ase
2> go
(31 rows affected)

1> alter table toto set transfer table on
2> go
(31 rows affected)

1> transfer table toto to "/opt/sybase/data/toto.ase" for ase
2> go
(31 rows affected)
1> transfer table toto to "/opt/sybase/data/toto.ase" for ase
2> go
(0 rows affected)

1> update toto set name="test" where id=1
2> go
(1 row affected)
1> transfer table toto to "/opt/sybase/data/toto.ase" for ase
2> go
(1 row affected)

1> transfer table titi from  "/opt/sybase/data/toto.ase" for ase
2> go
(1 row affected)
1> select count(*) from titi
2> go

 -----------
          32

(1 row affected)

Comments