• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1185
  • Last Modified:

IBM solidDB -- dump of table schema

Hello,
  How do I get a dump of all the table  from a solidDB database?

The document say that you could use the describe command but I get an error

Thanks

ADMIN COMMMAND 'describe dept';

SOLID SQL Error 1: syntax error (line 1 near 'DESCRIBE')
0
SiemensSEN
Asked:
SiemensSEN
1 Solution
 
Tomas Helgi JohannssonCommented:
           Hi!

If you mean by dump to take a backup of all the database then you should issue the command
ADMIN COMMAND 'backup'  (see the following manual :)

http://publib.boulder.ibm.com/infocenter/soliddb/v6r3/index.jsp?topic=/com.ibm.swg.im.soliddb.sql.doc/doc/admin.command.html

However if you issue the
ADMIN COMMAND 'describe param'
command then it will return a description of all parameters or a parameter specified with param.

In your case you have written COMMMAND but it should be COMMAND. :)

Regards,
     Tomas Helgi
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now