Re: Using ISQL with vi editor?

> > I use ISQL interactively by ' isql <database_name> - '. While in the > isql interactive prompt I can invoke vi editor by ' > !vi '. I was wondering > if you can create something in vi (while in isql) and when you exit vi, send > whats in the vi buffer to isql to run? Also, is there a way you can edit a > SQL command you just sent to isql back into vi? I use to do this in Sybase > ISQL and would like to it in Informix. Thanks! Lenny.. > email: ldeckard@databank.com > Set your environmental variable DBEDIT to vi. Then when you run ISQL, choose option Q)uery-Language and then U)se-Editor. You'll get vi. When you ZZ out of your vi file, you can R)un it. When you're done running it (whether it finished or failed), U)se-Editor will recall the same file (with *sometimes helpful* error messages). -- Dan Madvig e-mail: d-madvig@bethel.edu Bethel College & Seminary phone: (612) 638-6414 3900 Bethel Drive fax: (612) 638-6001 St. Paul, MN 55112 " , ." - Marcel Marceau