Resize (Shrink) Sybase Database

[agmorgan]

I am using Sybase ASE 15.0.2
I have loaded a clients database from a dump and it required a 15GB database.
However, when I look at the usage there is only ~350MB of data in there.

Sybase seems to create a file on disk the size of your database despite how much of it is used.
I cant really afford to spare 15GB on my disk.
Is there anyway to resize the database so that it is only 2GB in size?

[Hack]

I would check the SysBase documentation or their web site. If this is common for the product, there has to be some built in way to accomplish what you are after.

[agmorgan]

You'd think so wouldn't you?
Although, I can't find anything.
I think the next best thing would be to use the bcp command to export all the data out to flat files and create a new database and import them back in.

However, I don't know how to generate the DDL scripts in Sybase to recreate the tables and indexes for the data to go back into