Dump and Load on Storage Areas.

[maday15]

Is there any way to do a dump and load specifying the storage area instead of each specific table? I am on Progress 10.0B database. A few of my storage areas have multiple tables and I don't want to forget any tables while doing a dump and load.

Thanks. Brian

 

[Casper]

To get a list of tables in an area you can do:

define variable iAreaNum as integer no-undo.
assign iAreaNum = 7.
FOR EACH _storageobject WHERE _storageobject._object-type = 1  and
                              _storageobject._area-number = iAreaNum no-lock,
    first _File WHERE _File._File-Number = _storageobject._Object-number,
      first _area WHERE _area._area-number = _storageobject._area-number:
    
    DISPLAY _File-name FORMAT "x(25)"_File-Number _area._area-name 
    FORMAT "X(25)".      
END.

You can use this to generate a dump script for a specific area.

HTH,

Casper