topic About dbaccess in Operating System - HP-UX

About dbaccess

rip3000 — Wed, 25 Sep 2002 00:43:11 GMT

I paste a long script to dbaccess
and it reply " 801: SQL Edit buffer is full.".
How can I extend the buffer.

Re: About dbaccess

Tony Flaherty — Thu, 26 Sep 2002 07:09:26 GMT

Not sure what you mean by paste, if you are selecting Query - New and then using your terminal emulator or whatever to paste the SQL you may want to try creating the sql file beforehand using the editor of your choice, vi or whatever, and then selecting Query - Choose to load your file into dbaccess, or try running the file on the commandline;

dbaccess my_database my_sql_script

there are various ways of driving dbaccess fromthe command line, look at the informix answers online CD or web page for more info.

Tony.

Re: About dbaccess

Malcolm Weallans — Thu, 26 Sep 2002 07:18:19 GMT

I assume that you are using IDS on Windows NT. I have not had much success with cut and paste from Windows apps to dbaccess. I would suggest that if you are on Windows you should edit the sql script in Notepad. Save it with SQL extension, and then choose it within dbaccess. I know that works as I have done it from home. If you still get the problem with the EDIT buffer being full you could try splitting the SQL script and doing it that way.

Hope this helps
Malcolm