Re: [Squirrel-sql-users] Informix unload/load command

[Jacobo B. <un_...@ya...>]

Because to use dbaccess you must connect to each machine where the database is. And you must have a profile in unix that takes you to the prompt.
In most servers we have user (needed to use informix) but your user can log in properly to use the dbaccess.
That's why we are using sqleditor now. But that won't do when we pass to windows 7 :(

--- El vie, 8/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: viernes, 8 de marzo, 2013 19:31


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