Re: Help!, Large SQL COMMANDS RUNNING FROM DBACCESS
Posted in 1996
Hans,
Run your command from the unix command line using Dbaccess as follows.
dbaccess database_name command_file.sql
The editor of Dbaccess has limited space, so really large queries don't
work. Putting the commands in a file with a .sql extention and running
them as noted above, will eliminate this problem for you.
Hope this helps,
Tracy
>
> Help!,
>
> I Cannot run large SQL commands from within DbAccess
> does anyone know an alternative for this.
> Thanks!
>
>
>
>
--
=========================================================================
= Tracy W. Nedd =
= Banctec Inc. - DBA =
= Silver Spring, Md =
= tracyn@banctec.clark.net or tracyn@asd.banctec.com =
=========================================================================
= ALL RIGHTS RESERVED. =
= This posting is copyright and may be used only for the purposes =
= of professional study, or the professional exchange of information. =
= Use of this posting by any commercial organization for the purposes =
= of vilifying another is explicitly prohibited. =
=========================================================================