|
From: Jacobo B. <un_...@ya...> - 2013-03-07 07:35:30
|
Thanks a lot for the answer. This is a start, I managed to download a plain fail separated by pipes | with this tool, I also saw the sql2ins to do the loads. Now, to make it viable in my work, I'd need a way to invoke this automaticaly in a big sql script where I only want to load/download some of the queries, and in diferent files. 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? Thanks a lot. --- El mié, 6/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: miércoles, 6 de marzo, 2013 21:49 On Wed, 6 Mar 2013, Jacobo Balbuena wrote: > My question: In dbaccess and other Informix command, I'm allowed to do the > unload to 'file' command. > > like > unload to 'c:\unloads\tmp.unl' select * from systables; > > This doesn't seem to work in squirrel, some knows if I need a special pluggin or something for this? I already have the Informix pluggin installed. Use the SQLScripts plugin. http://stackoverflow.com/questions/2314029/how-can-i-store-the-result-of-a-sql-query-in-a-csv-file-using-squirrel I haven't tried this, though, so I don't know whether the delimiter is under your control so you can get vertical-bar-delimited data like dbaccess provides. -- 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 ----------------------------------------------------------------------- 4 days until Daylight Saving Time begins in U.S. - Spring Forward |
