Re: Help!, Large SQL COMMANDS RUNNING FROM DBACCESS

"Hans Nieuwenburg" <Hans.Nieuwenburg@cmg.nl> wrote: :Hans Nieuwenburg <Hans.Nieuwenburg@cmg.nl> wrote in article :<01bbc0f2$b90ee3c0$69ab4fc1@Hans.Nieuwenburg.CMG.NL>... :> Help!, :> :> I Cannot run large SQL commands from within DbAccess :> does anyone know an alternative for this. :> Thanks! :Added:: :We use the SQL Command for conversion purposes and want to load the sql :command into the edit buffer within SQL COMMANDS of dbaccess dbaccess comes :with the error "edit buffer is full" I just tested with a command that was 3121 lines, 65481 characters (a big union) without any problems in dbaccess 7.10.UC1 on SCO Unix 3.2.4.2 The engine has stoped responding right now, but that's another issue. You might just edit the sql with your editor and then may be you can execute it via 4GL or an ESQL/C program. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org