Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

About dbaccess

rip3000
Occasional Contributor

About dbaccess

I paste a long script to dbaccess
and it reply " 801: SQL Edit buffer is full.".
How can I extend the buffer.
2 REPLIES
Tony Flaherty
Frequent Advisor

Re: About dbaccess


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.
There are 10 types of people in the world, Those who understand Binary and those who don't.
Malcolm Weallans
Occasional Advisor

Re: About dbaccess

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
shouldn't every database be online?