Re: [Squirrel-sql-users] Informix unload/load command
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: John H. <jh...@im...> - 2013-03-08 18:31:56
|
On Fri, 8 Mar 2013, Jacobo Balbuena wrote: > No, dbaccess sucks bad, ... > dbaccess is like 'vi', it does things well if you dont cut your veins > using it. Again, what does this matter if you're only using it to run SQL scripts in batch mode? > Where I work we do LOTS of updates-deletes everyday, usually with > sqleditor we download as backup the rows we are changing in the same > script. Most of those scripts we must execute them in 14 or more > databases, and with the load and unload command, once I check the script > is ok, I dont need to pause the script to download what I want or be > asked the file name and accept. So develop the script on a test database in Squirrel, edit it to add the "UNLOAD TO" part in front of the backup SELECT statements, and run it in batch mode against your 14+ production databases using dbaccess (which is available under Windows, IIRC). > I'm liking squirrel a lot, and I know now what I miss but I bet one day you will do it: > > Those functions like sql2file need to be able to be called automatically from script like > sql2file(select * from blablabla, 'c:\unloads\kk.unl') > > Once your comunity manage to do this, you will get as customers about 150 people that work with me. > > Thanks a lot for your time, I'd like to have more spare time to help you building this great proyect :( > > --- El jue, 7/3/13, John Hardin <jh...@im...> escribió: > > > De: John Hardin <jh...@im...> > Asunto: Re: [Squirrel-sql-users] Informix unload/load command > Para: "Jacobo Balbuena" <un_...@ya...> > CC: squ...@li... > Fecha: jueves, 7 de marzo, 2013 23:17 > > > On Thu, 7 Mar 2013, Jacobo Balbuena wrote: > >> If the load/unload Informix command worked in squirrel, it would be easily done with the command using it in any part of the script where you want to download the result in a file. >> >> Someone knows if this is doable? > > No. "LOAD FROM" and "UNLOAD TO" are extensions to the basic SQL grammar that are provided internally by dbaccess. You have to be running your queries via dbaccess to use them. > > I don't know whether there is a similar scriptable delimited unload facility for Squirrel. > > Is there some reason you don't want to use dbaccess to run these queries? Squirrel is a wonderful cross-platform interactive query tool. In my opinion, trying to make it into a batch query tool is trying to force it into being something it was never intended to be. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Failure to plan ahead on someone else's part does not constitute an emergency on my part. -- David W. Barts in a.s.r ----------------------------------------------------------------------- 2 days until Daylight Saving Time begins in U.S. - Spring Forward |