Re: Copy Table in SPL
Posted in 1998
You can, if you are on UNIX
You need to launch a schell script containing call to dbaccess to run sql
script via the 'system' command
The script contains INSERT INTO ...
LOAD FROM...
:( Unfortunately in NT ( up to version 7.24 ) the system command wasn't
work. I've heard it is fixed in 7.3
If you need more detail , write an e-mail.
Volker Fraenkle <VFraenkle@cs-controlling.de> wrote in message
35C6CC29.8494DD16@cs-controlling.de...
>Hello to everyone!
>
>I am looking for a solution to copy a database table within a stored
>procedure. Any suggestions for that?
>
>Thanks, Volker
>
>--
>Volker Fraenkle CS Controlling
>Technical Consultant Software Systeme GmbH
>
>E-Mail: VFraenkle@cs-controlling.de
>Phone: +49 7144 8144-0 Riedbachstrasse 5
>Fax: +49 7144 8144-10 D-74385 Pleidelsheim