using IDS9.4 on linux

byusing ontape i could do back up of whole system and recover. if want to do it sql
prompt, i.e in dbaccess i want to write a sql command for backup, what is command ,can any one help me ..

Hi,

The closest one is unload. But:
- It won't save your system configuration
- It won't save your databases schemas
- It won't guarantee the integrity of the data (unless you lock the database in exclusive mode)
- You must perform it for each table.

I always recommend to backup the system using ontape. You can also use dbexport or onunload... and all of them are external commands.

Hope it helps.