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
|