*** FrankW has quit IRC | 00:21 | |
*** ChanServ changes topic to "Ingres Chat | Community - http://community.ingres.com | Channel Archives http://irc.planetingres.org" | 00:47 | |
*** grantc has quit IRC | 00:56 | |
*** Gerhard has joined #ingres | 01:07 | |
Gerhard | Hi all | 01:07 |
---|---|---|
*** toumi01 has joined #ingres | 01:32 | |
*** withdefault has joined #ingres | 02:34 | |
*** ChanServ sets mode: +o withdefault | 02:34 | |
*** grantc has joined #ingres | 03:39 | |
*** ChanServ sets mode: +o grantc | 03:39 | |
*** cthibert has joined #ingres | 04:43 | |
*** atrofast has joined #ingres | 04:52 | |
*** Dejan has joined #ingres | 05:09 | |
Dejan | hi guys | 05:09 |
*** toumi01 has quit IRC | 05:13 | |
*** toumi01 has joined #ingres | 05:14 | |
grantc | morning | 05:16 |
*** toumi01 has left #ingres | 05:18 | |
Gerhard | Hi all, is there a command line switch for isql to directy load an sql file? | 05:28 |
Gerhard | Like "isql dbname myscript.sql" | 05:28 |
Alex| | < | 05:33 |
Alex| | isql dbname < file ? | 05:33 |
*** mull has joined #ingres | 05:41 | |
*** Gerhard has left #ingres | 05:45 | |
*** Gerhard has joined #ingres | 05:45 | |
Gerhard | will try < | 05:45 |
Gerhard | Unfortunately, < does not work for isql as it does for sql | 05:47 |
Dejan | new ingres has script statement | 05:49 |
Dejan | or something like that | 05:49 |
Dejan | i have forgotten ... | 05:49 |
Gerhard | Dejan, which release precisely? | 05:59 |
Dejan | Gerhard: 10 i think | 05:59 |
*** toumi01 has joined #ingres | 06:00 | |
Dejan | i hate when i forget those things... | 06:02 |
Dejan | it was on forum | 06:02 |
Dejan | a thread was about exporting csv file | 06:02 |
Dejan | directly from isql | 06:02 |
grantc | \script is for logging like "script" in Unix/Linux | 06:03 |
grantc | http://ingres.pastebin.com/d226ccd7a - that was taken from the current svn code | 06:03 |
Dejan | grantc: it is some command | 06:04 |
grantc | i guess you are looking for "\i" or "\include" | 06:04 |
Dejan | i cannot remember which one... | 06:04 |
Dejan | but \i would do i suppose | 06:04 |
Gerhard | I think that \i is for sql and not for isql, right? | 06:05 |
withdefault | Is the csv output this one? http://community.ingres.com/wiki/Terminal_Monitor_Silent_Mode | 06:06 |
Dejan | withdefault: THAT ONE! | 06:06 |
Dejan | tyyyyy | 06:06 |
*** rossand has joined #ingres | 06:06 | |
*** ChanServ sets mode: +o rossand | 06:06 | |
withdefault | that's for terminal monitor (sql) - I don't think it will work with isql | 06:07 |
Dejan | there was a thread about it | 06:07 |
withdefault | http://community.ingres.com/forum/questions-feedback-suggestions/11053-data-only-sql-terminal-monitor.html | 06:07 |
*** [1]Gerhard has joined #ingres | 06:11 | |
[1]Gerhard | Now back to the ISQL problem. I often do | 06:12 |
[1]Gerhard | isql dbname | 06:13 |
[1]Gerhard | then hit ESC key... | 06:13 |
[1]Gerhard | type "file" <ENTER> | 06:13 |
[1]Gerhard | hit <shift><f2> | 06:14 |
[1]Gerhard | type in complete path to sql file <ENTER> | 06:14 |
[1]Gerhard | so the question again: any easier way to do this? | 06:14 |
Dejan | sql ? | 06:21 |
Dejan | sql < path/filename | 06:21 |
[1]Gerhard | another question: in Ingres 9.2, there is a new funtion trunc / truncate. How can I truncate a float after the decimal in Ingres release prior to 9.2? | 06:22 |
[1]Gerhard | Dejan, yes I know "sql dbname < myfile.sql". But for most ad-hoc querying I prefer ISQL over SQL as you can scroll through the result set left / right and up / down. | 06:25 |
Dejan | true :( | 06:26 |
Dejan | i use squirrel-sql if i need something like that | 06:26 |
Dejan | isql is great, but i use many different terminals, and i got sick of setting them all over again | 06:26 |
*** Gerhard has quit IRC | 06:29 | |
*** [1]Gerhard is now known as Gerhard | 06:29 | |
Gerhard | Squirrel SQL = free? | 06:35 |
withdefault | it's open source http://squirrel-sql.sourceforge.net/ | 06:37 |
Dejan | yeah | 06:37 |
withdefault | anyone know if the Ingres plugin for SQuirreL SQL made it into the wild? | 06:41 |
Dejan | i do not have it | 06:43 |
Dejan | i just use iijdbc.jar | 06:43 |
withdefault | Dejan, I believe that there was an experimental plug-in that performs some dba functions in addition to the regular querying | 06:53 |
*** Alex| is now known as Alex|off | 06:54 | |
*** stephenb has joined #ingres | 07:13 | |
*** stephen2 has quit IRC | 07:16 | |
Dejan | oh noes, stephenb left | 07:25 |
Dejan | :( | 07:25 |
Dejan | ah he is still here :) | 07:25 |
Dejan | hiya stephenb | 07:25 |
grantc | i guess he is asleep | 07:26 |
*** FrankW has joined #ingres | 07:36 | |
*** Dejan has quit IRC | 08:00 | |
*** rossand has quit IRC | 08:08 | |
*** Gerhard has quit IRC | 08:10 | |
*** dyki has quit IRC | 08:14 | |
*** DerMeister has joined #ingres | 08:31 | |
*** DarylM has joined #ingres | 08:33 | |
*** DarylM has quit IRC | 08:36 | |
*** sdanaher has joined #ingres | 09:15 | |
*** sdanaher has quit IRC | 09:21 | |
*** DarylM has joined #ingres | 10:04 | |
*** grantc has quit IRC | 11:02 | |
*** Alex|off is now known as Alex| | 12:25 | |
*** rossand has joined #ingres | 12:33 | |
*** ChanServ sets mode: +o rossand | 12:33 | |
*** cthibert has left #ingres | 12:35 | |
DarylM | Three cheers for JayH. and Mac lovers everywhere :-) http://inspect.ingres.com/r/34/ | 12:44 |
*** zxiiro_ has joined #ingres | 12:59 | |
*** zxiiro has quit IRC | 12:59 | |
*** zxiiro_ is now known as zxiiro | 12:59 | |
*** ChanServ sets mode: +v zxiiro | 12:59 | |
*** rossand has quit IRC | 13:03 | |
*** Alex| is now known as Alex|off | 13:38 | |
*** rossand has joined #ingres | 14:00 | |
*** ChanServ sets mode: +o rossand | 14:00 | |
*** rossand has quit IRC | 14:10 | |
*** DerMeister has quit IRC | 14:23 | |
*** rossand has joined #ingres | 14:51 | |
*** ChanServ sets mode: +o rossand | 14:51 | |
*** mull has quit IRC | 15:32 | |
stephenb | dejan: It might look like I'm on all the time, but I just leave myself connected to see the chat (my machine remains on 24x7). In fact I'm only reliably here between 9:00 AM and 5:30 PM Australian eastern time (which is the middle of the nught for most people); so I never see any realtime chat (which is why I have not been connected for some time) | 15:39 |
stephenb | it's now 8:40 AM here | 15:40 |
stephenb | The only "realtime" chat I'll see is anything posted in the next 8 hourse (which is virtually always nothing at all) | 15:42 |
*** rossand has quit IRC | 15:58 | |
*** rossand has joined #ingres | 18:07 | |
*** ChanServ sets mode: +o rossand | 18:07 | |
*** zxiiro_ has joined #ingres | 20:08 | |
*** zxiiro has quit IRC | 20:08 | |
*** zxiiro_ is now known as zxiiro | 20:08 | |
*** ChanServ sets mode: +v zxiiro | 20:08 | |
*** toumi01 has quit IRC | 20:40 | |
*** FrankW has quit IRC | 22:04 | |
*** Alex|off is now known as Alex| | 22:34 | |
*** Alex| is now known as Alex|off | 23:11 | |
*** Alex|off is now known as Alex| | 23:26 | |
*** grantc has joined #ingres | 23:50 | |
*** ChanServ sets mode: +o grantc | 23:50 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!