MaxDB: how to make it read and execute external SQL Script files ???

Thread view:

emeka103@yahoo.com - 30 Jun 2004 08:59 GMT

Anyone had any luck in getting MaxDB7.5 database to read and execute a
sql script file (for batch creation/deletion of tables etc.)?

Thnx in advance!

Reply to this Message

John - 30 Jun 2004 09:29 GMT

> Anyone had any luck in getting MaxDB7.5 database to read and execute a
> sql script file (for batch creation/deletion of tables etc.)?
>
> Thnx in advance!

I just use SQL Studio to open the file. ( I got very bored trying to get
the command line thing working). If you have any joy please post your
solution.

John

Reply to this Message

Burkhard Diesing - 30 Jun 2004 15:05 GMT

> Anyone had any luck in getting MaxDB7.5 database to read and execute a
> sql script file (for batch creation/deletion of tables etc.)?

Hi,
you can use sqlcli as command line interface. sqlcli reads from stdin or
from a file
with the -i option. See sqlcli -h for more about the command line interface.

Burkhard

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...