squirrel-sql-users — A subscriber only discussion list for SQuirreL

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

[John H. <jh...@im...>]

On Mon, 11 Mar 2013, Jacobo Balbuena wrote:

> Because to use dbaccess you must connect to each machine where the database is.

That can easily be scripted to occur from a single account on a single 
box through setting environment variables.

   export INFORMIXDIR=/opt/informix
   export PATH=$PATH:$INFORMIXDIR/bin

   for SRV in $list_of_ifx_server_names
   do
     # $SRV must appear in $INFORMIXDIR/etc/sqlhosts
     export INFORMIXSERVER=$SRV
     dbaccess -e $SRV $sql_script_name >> $SRV.log 2>&1
   done

...but this is drifting further OT for Squirrel. Feel feee to contact me 
offlist if you wish to continue this discussion.

> 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
-----------------------------------------------------------------------
   Our government should bear in mind the fact that the American
   Revolution was touched off by the then-current government
   attempting to confiscate firearms from the people.
-----------------------------------------------------------------------
  3 days until Albert Einstein's 134th Birthday

Re: [Squirrel-sql-users] DB2: How to set up SQuirreL to be able to create (and run) multiline and multicommand stored procedure?

[Drav S. <hol...@re...>]

Stepan RYBAR wrote:
> Hello,
>
> is anybody successful with running SQL code to create stored procedure on DB2
> (let say 9.1 running on AIX, but I guess, it is not important) and the stored
> procedure is multiline and multicommand? Am I missing some SQuirreL setting or
>  configuration SQL command or JDBC driver property (like @ terminator)? I read
>  many articles about thin on Internet but no recommendation lead to success. I
>  am using "com.ibm.db2.jcc.DB2Driver" JDBC driver in SQuirreL in Win7 64bit
> (Java 64bit) and DB2 9.1 on AIX on server.
>
> Thank You in advance. Stepan

I wonder if this is similar to a question about oracle procedures not working:

You need the DB2 plugin for SQuirreL. Go to Help -> Software Update ->
Check(button) -> Ok(button)

Then find the artifact called db2.jar and click on the action
value of "NONE" and change it to install.

After its downloaded you will need to restart and agree to install the
update.

Regards

D.

>
> Because
>
> create procedure dropTestIfExists(in myIndex varchar(128)) language SQL
> begin
>   declare sqlCmd varchar(139);
>   if exists(select 1 from syscat.indexes where indschema = current_schema and
> indname = myIndex) then
>     set sqlCmd = 'drop index ' || myIndex;
>     execute immediate sqlCmd;
>   end if;
> end
>
> end with:
>
> Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,
> SQLERRMC=END-OF-STATEMENT;sqlCmd varchar(139);<psm_semicolon>, DRIVER=4.7.85
> SQLState:  42601
> ErrorCode: -104
> Error occured in:
> create procedure dropTestIfExists(in myIndex varchar(128)) language SQL
> begin
>   declare sqlCmd varchar(139)
>
> Using DB2 CLP on AIX is OK with following command on my environment:
>
> create procedure dropIndexIfExists(in myIndex varchar(128)) language SQL \
> begin \
>   declare sqlCmd varchar(139); \
>   if exists(select 1 from syscat.indexes where indschema = current_schema and
> indname = myIndex) then \
>     set sqlCmd = 'drop index ' || myIndex; \
>     execute immediate sqlCmd; \
>   end if; \
> end \
>
> ------------------------------------------------------------------------------
> Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
> Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
> endpoint security space. For insight on selecting the right partner to
> tackle endpoint security challenges, access the full report.
> http://p.sf.net/sfu/symantec-dev2dev
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Squirrel-sql-users] DB2: How to set up SQuirreL to be able to create (and run) multiline and multicommand stored procedure?

[Stepan R. <xr...@se...>]

Hello, 

is anybody successful with running SQL code to create stored procedure on DB2 
(let say 9.1 running on AIX, but I guess, it is not important) and the stored 
procedure is multiline and multicommand? Am I missing some SQuirreL setting or
 configuration SQL command or JDBC driver property (like @ terminator)? I read
 many articles about thin on Internet but no recommendation lead to success. I
 am using "com.ibm.db2.jcc.DB2Driver" JDBC driver in SQuirreL in Win7 64bit 
(Java 64bit) and DB2 9.1 on AIX on server. 

Thank You in advance. Stepan 

Because 

create procedure dropTestIfExists(in myIndex varchar(128)) language SQL 
begin 
  declare sqlCmd varchar(139); 
  if exists(select 1 from syscat.indexes where indschema = current_schema and 
indname = myIndex) then 
    set sqlCmd = 'drop index ' || myIndex; 
    execute immediate sqlCmd; 
  end if; 
end 

end with: 

Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, 
SQLERRMC=END-OF-STATEMENT;sqlCmd varchar(139);<psm_semicolon>, DRIVER=4.7.85
SQLState:  42601
ErrorCode: -104
Error occured in:
create procedure dropTestIfExists(in myIndex varchar(128)) language SQL 
begin 
  declare sqlCmd varchar(139) 

Using DB2 CLP on AIX is OK with following command on my environment: 

create procedure dropIndexIfExists(in myIndex varchar(128)) language SQL \
begin \
  declare sqlCmd varchar(139); \
  if exists(select 1 from syscat.indexes where indschema = current_schema and 
indname = myIndex) then \
    set sqlCmd = 'drop index ' || myIndex; \
    execute immediate sqlCmd; \
  end if; \
end \

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

[Squirrel-sql-users] 3.5 release candidate snapshot

[Gerd W. <ger...@t-...>]

Hi all,

its about time to think of releasing version 3.5. A "release candidate 
snapshot" can be found here:

http://sourceforge.net/projects/squirrel-sql/files/3-snapshots/Snapshot-20130307_2000/squirrel-sql-Snapshot-20130307_2000-install.jar/download


You are invited to check out the pre release.

Gerd

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

[John H. <jh...@im...>]

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

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

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

No, dbaccess sucks bad, I just used it as an example of where the 'load' and 'unload' works. Other IFX platforms are able to use the thoes ifx commands, like Sqleditor.
 
The thing is sqleditor is not longer supported by IBM, dbaccess is like 'vi', it does things well if you dont cut your veins using it.
 
We are migrating to Windows 7 and sqleditor will not work, so I'm looking for a new sql platform that may adapt to our needs.
 
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.
 
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
-----------------------------------------------------------------------
3 days until Daylight Saving Time begins in U.S. - Spring Forward

Re: [Squirrel-sql-users] Can't create Oracle Procedure in Squirrel

[John H. <jh...@im...>]

On Thu, 7 Mar 2013, Robert Manning wrote:

> To clarify, the work-around that John describes was the only way to correct
> the problem in the past.  However,  the Oracle plugin has a query tokenizer
> that now recognizes "/" as an "end-of-statement operator", much like
> SQL-Plus.

Thanks for the clarification. I plead blissful ignorance of the current 
state of the plugin through not having needed to talk to 'Orrible (via 
Squirrel or any other direct query tool) for the last 7-ish years.

-- 
  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
-----------------------------------------------------------------------
  3 days until Daylight Saving Time begins in U.S. - Spring Forward

Re: [Squirrel-sql-users] Can't create Oracle Procedure in Squirrel

[Robert M. <rob...@gm...>]

To clarify, the work-around that John describes was the only way to correct
the problem in the past.  However,  the Oracle plugin has a query tokenizer
that now recognizes "/" as an "end-of-statement operator", much like
SQL-Plus.  So after installing the Oracle plugin, and without changing the
statement separator, you should be able to execute SQL statements that have
embedded semi-colons when the whole statement ends with a "/" on its own
line.  My goal with these more recent changes to the plugin was to give
SQuirreL a way to mimic the behaviour of SQL-Plus as much as possible.

Rob

On Thu, Mar 7, 2013 at 5:29 PM, John Hardin <jh...@im...> wrote:

> On Thu, 7 Mar 2013, Drav Sloan wrote:
>
> > urbanmojo wrote:
> >> Hi:
> >>
> >> I am using Squirrel as the client tool using JDBC RAC driver against
> Oracle
> >> 11.1. I am trying to replace an existing Oracle procedure with:
> >>
> >> CREATE OR REPLACE PROCEDURE MY_PROC
> >> AS
> >> BEGIN
> >> DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) -
> 20;
> >> DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) -
> 20;
> >> DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) -
> 20;
> >> DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) -
> 20;
> >> END;
> >>
> >> It fails with the error:
> >> Query 1 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.047, SQL
> >> query: 0.047, Building output: 0
> >> 6,326 Row(s) Deleted
> >> Query 2 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.672, SQL
> >> query: 0.672, Building output: 0
> >> 12,097 Row(s) Deleted
> >> Query 3 of 5, Rows read: 0, Elapsed time (seconds) - Total: 1.25, SQL
> query:
> >> 1.25, Building output: 0
> >> 5,040 Row(s) Deleted
> >> Query 4 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.531, SQL
> >> query: 0.531, Building output: 0
> >> Error: ORA-00900: invalid SQL statement
> >>
> >> SQLState: 42000
> >> ErrorCode: 900
> >> Error occured in:
> >> END
> >> What am I doing wrong? I've tried different things but nothing seems to
> give
> >> me an executable procedure.
> >
> > Terminate the declaration with a trailing / as thus:
> >
> > CREATE OR REPLACE PROCEDURE MY_PROC
> > AS
> > BEGIN
> > DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) -
> 20;
> > DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) -
> 20;
> > DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) -
> 20;
> > DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) -
> 20;
> > END;
> > /
>
> The trailing slash is (IIRC) specific to the Oracle client tools, not part
> of the base Oracle SQL syntax.
>
> The problem is that Squirrel is interpreting the ";" as a query separation
> marker and sending the individual pieces of the above to Oracle as
> separate query commands.
>
> To fix:
>
> Open up the Session Properties dialog in Squirrel, go to the SQL tab,
> locate the "Statement Separator" option and change it to something that
> doesn't appear in the code you're trying to run to generate the SP,
> perhaps "|||".
>
> Then you should be able to create your SP.
>
> You'll want to switch the statement separator back to ";" for normal
> interactive use.
>
> --
>   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
> -----------------------------------------------------------------------
>   3 days until Daylight Saving Time begins in U.S. - Spring Forward
>
>
> ------------------------------------------------------------------------------
> Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
> Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
> endpoint security space. For insight on selecting the right partner to
> tackle endpoint security challenges, access the full report.
> http://p.sf.net/sfu/symantec-dev2dev
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Can't create Oracle Procedure in Squirrel

[John H. <jh...@im...>]

On Thu, 7 Mar 2013, Drav Sloan wrote:

> urbanmojo wrote:
>> Hi:
>>
>> I am using Squirrel as the client tool using JDBC RAC driver against Oracle
>> 11.1. I am trying to replace an existing Oracle procedure with:
>>
>> CREATE OR REPLACE PROCEDURE MY_PROC
>> AS
>> BEGIN
>> DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) - 20;
>> DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) - 20;
>> DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) - 20;
>> DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) - 20;
>> END;
>>
>> It fails with the error:
>> Query 1 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.047, SQL
>> query: 0.047, Building output: 0
>> 6,326 Row(s) Deleted
>> Query 2 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.672, SQL
>> query: 0.672, Building output: 0
>> 12,097 Row(s) Deleted
>> Query 3 of 5, Rows read: 0, Elapsed time (seconds) - Total: 1.25, SQL query:
>> 1.25, Building output: 0
>> 5,040 Row(s) Deleted
>> Query 4 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.531, SQL
>> query: 0.531, Building output: 0
>> Error: ORA-00900: invalid SQL statement
>>
>> SQLState: 42000
>> ErrorCode: 900
>> Error occured in:
>> END
>> What am I doing wrong? I've tried different things but nothing seems to give
>> me an executable procedure.
>
> Terminate the declaration with a trailing / as thus:
>
> CREATE OR REPLACE PROCEDURE MY_PROC
> AS
> BEGIN
> DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) - 20;
> DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) - 20;
> DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) - 20;
> DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) - 20;
> END;
> /

The trailing slash is (IIRC) specific to the Oracle client tools, not part 
of the base Oracle SQL syntax.

The problem is that Squirrel is interpreting the ";" as a query separation 
marker and sending the individual pieces of the above to Oracle as 
separate query commands.

To fix:

Open up the Session Properties dialog in Squirrel, go to the SQL tab, 
locate the "Statement Separator" option and change it to something that 
doesn't appear in the code you're trying to run to generate the SP, 
perhaps "|||".

Then you should be able to create your SP.

You'll want to switch the statement separator back to ";" for normal 
interactive use.

-- 
  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
-----------------------------------------------------------------------
  3 days until Daylight Saving Time begins in U.S. - Spring Forward

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

[John H. <jh...@im...>]

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
-----------------------------------------------------------------------
  3 days until Daylight Saving Time begins in U.S. - Spring Forward

Re: [Squirrel-sql-users] Can't create Oracle Procedure in Squirrel

[Robert M. <rob...@gm...>]

You need the Oracle plugin for SQuirreL. Go to Help -> Software Update ->
Check(button) -> Ok(button)
Then find the artifact called oracle-assembly.zip and click on the action
value of "NONE" and change it to install.

After its downloaded you will need to restart and agree to install the
update.

Rob

On Thu, Mar 7, 2013 at 10:01 AM, urbanmojo <cra...@gm...>wrote:

> Hi:
>
> I am using Squirrel as the client tool using JDBC RAC driver against Oracle
> 11.1. I am trying to replace an existing Oracle procedure with:
>
> CREATE OR REPLACE PROCEDURE MY_PROC
> AS
> BEGIN
> DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) - 20;
> DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) - 20;
> DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) - 20;
> DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) - 20;
> END;
>
> It fails with the error:
> Query 1 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.047, SQL
> query: 0.047, Building output: 0
> 6,326 Row(s) Deleted
> Query 2 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.672, SQL
> query: 0.672, Building output: 0
> 12,097 Row(s) Deleted
> Query 3 of 5, Rows read: 0, Elapsed time (seconds) - Total: 1.25, SQL
> query:
> 1.25, Building output: 0
> 5,040 Row(s) Deleted
> Query 4 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.531, SQL
> query: 0.531, Building output: 0
> Error: ORA-00900: invalid SQL statement
>
> SQLState: 42000
> ErrorCode: 900
> Error occured in:
> END
> What am I doing wrong? I've tried different things but nothing seems to
> give
> me an executable procedure.
>
>
>
> --
> View this message in context:
> http://squirrel-sql-client.10976.n7.nabble.com/Can-t-create-Oracle-Procedure-in-Squirrel-tp3082.html
> Sent from the Users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
> Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
> endpoint security space. For insight on selecting the right partner to
> tackle endpoint security challenges, access the full report.
> http://p.sf.net/sfu/symantec-dev2dev
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

[Squirrel-sql-users] SQuirreL SQL client freezes at splash screen

[Jordan A. <jor...@gm...>]

(Apologies if this question is posted twice, my previous post was over the
size limit due to a screenshot).

Just installed SQuirreL client on Windows 8 64 bit and it freezes while
loading plugins on the splash screen.  Client version is 3.4.0.  Any
suggestions for how to investigate this issue?

Re: [Squirrel-sql-users] Can't create Oracle Procedure in Squirrel

[Dennis B. <Den...@gm...>]

Hello!

How are you executing the command? Looks like each DELETE gets send 
individually to your database.

I don't have access to a Squirrel installation at the moment but IIRC 
there is a command to run all selected code in one piece.


HTH and best regards,
Dennis Benzinger

Am 07.03.2013 16:01, schrieb urbanmojo:
> Hi:
>
> I am using Squirrel as the client tool using JDBC RAC driver against Oracle
> 11.1. I am trying to replace an existing Oracle procedure with:
>
> CREATE OR REPLACE PROCEDURE MY_PROC
> AS
> BEGIN
> DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) - 20;
> DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) - 20;
> DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) - 20;
> DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) - 20;
> END;
>
> It fails with the error:
> Query 1 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.047, SQL
> query: 0.047, Building output: 0
> 6,326 Row(s) Deleted
> Query 2 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.672, SQL
> query: 0.672, Building output: 0
> 12,097 Row(s) Deleted
> Query 3 of 5, Rows read: 0, Elapsed time (seconds) - Total: 1.25, SQL query:
> 1.25, Building output: 0
> 5,040 Row(s) Deleted
> Query 4 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.531, SQL
> query: 0.531, Building output: 0
> Error: ORA-00900: invalid SQL statement
>
> SQLState: 42000
> ErrorCode: 900
> Error occured in:
> END
> What am I doing wrong? I've tried different things but nothing seems to give
> me an executable procedure.
>
>
>
> --
> View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Can-t-create-Oracle-Procedure-in-Squirrel-tp3082.html
> Sent from the Users mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
> Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
> endpoint security space. For insight on selecting the right partner to
> tackle endpoint security challenges, access the full report.
> http://p.sf.net/sfu/symantec-dev2dev
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] Can't create Oracle Procedure in Squirrel

[Drav S. <hol...@re...>]

urbanmojo wrote:
> Hi:
> 
> I am using Squirrel as the client tool using JDBC RAC driver against Oracle
> 11.1. I am trying to replace an existing Oracle procedure with:
> 
> CREATE OR REPLACE PROCEDURE MY_PROC 
> AS
> BEGIN
> DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) - 20;
> DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) - 20;
> DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) - 20;
> DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) - 20;
> END;
> 
> It fails with the error:
> Query 1 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.047, SQL
> query: 0.047, Building output: 0
> 6,326 Row(s) Deleted
> Query 2 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.672, SQL
> query: 0.672, Building output: 0
> 12,097 Row(s) Deleted
> Query 3 of 5, Rows read: 0, Elapsed time (seconds) - Total: 1.25, SQL query:
> 1.25, Building output: 0
> 5,040 Row(s) Deleted
> Query 4 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.531, SQL
> query: 0.531, Building output: 0
> Error: ORA-00900: invalid SQL statement
> 
> SQLState: 42000
> ErrorCode: 900
> Error occured in:
> END
> What am I doing wrong? I've tried different things but nothing seems to give
> me an executable procedure.

Terminate the declaration with a trailing / as thus:

CREATE OR REPLACE PROCEDURE MY_PROC 
AS
BEGIN
 DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) - 20;
 DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) - 20;
 DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) - 20;
 DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) - 20;
END;
/

Regards

D.

Re: [Squirrel-sql-users] Can't create Oracle Procedure in Squirrel

[Blair M. <cra...@gm...>]

That still gives the same error. How about the semi-colons--is that correct?

On 3/7/13 11:06 PM, Drav Sloan wrote:
> urbanmojo wrote:
>> Hi:
>>
>> I am using Squirrel as the client tool using JDBC RAC driver against Oracle
>> 11.1. I am trying to replace an existing Oracle procedure with:
>>
>> CREATE OR REPLACE PROCEDURE MY_PROC
>> AS
>> BEGIN
>> DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) - 20;
>> DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) - 20;
>> DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) - 20;
>> DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) - 20;
>> END;
>>
>> It fails with the error:
>> Query 1 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.047, SQL
>> query: 0.047, Building output: 0
>> 6,326 Row(s) Deleted
>> Query 2 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.672, SQL
>> query: 0.672, Building output: 0
>> 12,097 Row(s) Deleted
>> Query 3 of 5, Rows read: 0, Elapsed time (seconds) - Total: 1.25, SQL query:
>> 1.25, Building output: 0
>> 5,040 Row(s) Deleted
>> Query 4 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.531, SQL
>> query: 0.531, Building output: 0
>> Error: ORA-00900: invalid SQL statement
>>
>> SQLState: 42000
>> ErrorCode: 900
>> Error occured in:
>> END
>> What am I doing wrong? I've tried different things but nothing seems to give
>> me an executable procedure.
> Terminate the declaration with a trailing / as thus:
>
> CREATE OR REPLACE PROCEDURE MY_PROC
> AS
> BEGIN
>   DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) - 20;
>   DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) - 20;
>   DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) - 20;
>   DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) - 20;
> END;
> /
>
> Regards
>
> D.
>

[Squirrel-sql-users] Can't create Oracle Procedure in Squirrel

[urbanmojo <cra...@gm...>]

Hi:

I am using Squirrel as the client tool using JDBC RAC driver against Oracle
11.1. I am trying to replace an existing Oracle procedure with:

CREATE OR REPLACE PROCEDURE MY_PROC 
AS
BEGIN
DELETE FROM table1 WHERE IEX_DATE >= (select max(idate) from table1) - 20;
DELETE FROM table2 WHERE IEX_DATE >= (select max(idate) from table2) - 20;
DELETE FROM table3 WHERE IEX_DATE >= (select max(idate) from table3) - 20;
DELETE FROM table4 WHERE IEX_DATE >= (select max(idate) from table4) - 20;
END;

It fails with the error:
Query 1 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.047, SQL
query: 0.047, Building output: 0
6,326 Row(s) Deleted
Query 2 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.672, SQL
query: 0.672, Building output: 0
12,097 Row(s) Deleted
Query 3 of 5, Rows read: 0, Elapsed time (seconds) - Total: 1.25, SQL query:
1.25, Building output: 0
5,040 Row(s) Deleted
Query 4 of 5, Rows read: 0, Elapsed time (seconds) - Total: 0.531, SQL
query: 0.531, Building output: 0
Error: ORA-00900: invalid SQL statement

SQLState: 42000
ErrorCode: 900
Error occured in:
END
What am I doing wrong? I've tried different things but nothing seems to give
me an executable procedure.



--
View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Can-t-create-Oracle-Procedure-in-Squirrel-tp3082.html
Sent from the Users mailing list archive at Nabble.com.

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

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

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

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

[John H. <jh...@im...>]

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

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

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

First post here so I have no clue about if I'm doing things right, feel free to flame and show me the right way.

My question: In dbaccess and other Informix command, I'm allowed to do the
unload to 'file' command. You can see the api of the Informix command here:
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.mig.doc/mig192.htm

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.

Another option could be a Squirrel specific syntax that I can put in a script to tell next select will be downloaded into a file.

Thanks a lot for help.

[Squirrel-sql-users] Any alternative colour schemes for GUI?

[Luís de S. <lui...@gm...>]

Hello everyone,

I'd like to know if there are any alternative colour schemes for the
GUI. I find the white backgrounds especially aggressive.

Thank you.

Re: [Squirrel-sql-users] what to do with fw.jar

[René A V. <RVa...@ct...>]

Hello John,

>> That happens a lot on mailing lists: reply to list plus reply to original
sender:

Yes, thanks, I see how that can happen when responding to an email from
someone on the list, who also had sent his email to the list... such as I am
doing right now.  You will probably get two of my reply, so in the future I
will consider whether I want to include the original sender as an explicit
addressee.

However, that doesn’t explain the dual notices that I was getting from
SourceForge when the Project got updated...  Since I've unsubscribed from
SQuirreL notices, it's now a moot point for me.

René A Valencourt, CCP, MCTS
IS Dept.
CTB, Inc.
A Berkshire Hathaway Company


-----Original Message-----
From: John Hardin [mailto:jh...@im...] 
Sent: Tuesday, February 26, 2013 10:18 AM
To: Squirrel SQL users list
Subject: Re: [Squirrel-sql-users] what to do with fw.jar

On Tue, 26 Feb 2013, René A Valencourt wrote:

>>> I think you may have asked (knowingly or unknowingly) to receive
> notifications?
>
> I did request ?Update Notifications?, thinking that would let me know 
> when SQuirreL were updated to a new level.  I didn?t realize that I 
> would get notices for trivial events.

That's "notifications of updates to the revision control repository", which
will occur more often than official releases.
>
> In the meantime, it?s still puzzling why I get the notices in pairs.  
> The last email from you came twice at the same time again.

That happens a lot on mailing lists: reply to list plus reply to original
sender:

>> To: RVa...@ct...
>> Cc: Squirrel SQL users list

-- 
  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
-----------------------------------------------------------------------
   Political Correctness is a doctrine which is based on the premise
   that it is possible, through nothing more than a suitable choice
   of words, to pick up a turd by the clean end.
-----------------------------------------------------------------------
  15 days until Albert Einstein's 134th Birthday

************************************************************
This message may contain privileged, confidential and/or
trade secret information which is protected by law and is
intended only for the addressee.  If you are not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this message is strictly
prohibited.  If you have received this message in error, 
please immediately notify us, and permanently delete all
copies of the message.  Due to the nature of the Internet, 
e-mail messages are not secure and may be delayed or
undelivered.  Also, in accordance with CTB company policy,
e-mail messages may be reviewed or retained by CTB
employees in addition to or other than the intended recipient.


This footnote also confirms that this email message has
been swept by Postini for the presence of computer viruses.
************************************************************

Re: [Squirrel-sql-users] what to do with fw.jar

[John H. <jh...@im...>]

On Tue, 26 Feb 2013, René A Valencourt wrote:

>>> I think you may have asked (knowingly or unknowingly) to receive
> notifications?
>
> I did request ?Update Notifications?, thinking that would let me know when
> SQuirreL were updated to a new level.  I didn?t realize that I would get
> notices for trivial events.

That's "notifications of updates to the revision control repository", 
which will occur more often than official releases.
>
> In the meantime, it?s still puzzling why I get the notices in pairs.  The
> last email from you came twice at the same time again.

That happens a lot on mailing lists: reply to list plus reply to original 
sender:

>> To: RVa...@ct...
>> Cc: Squirrel SQL users list

-- 
  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
-----------------------------------------------------------------------
   Political Correctness is a doctrine which is based on the premise
   that it is possible, through nothing more than a suitable choice
   of words, to pick up a turd by the clean end.
-----------------------------------------------------------------------
  15 days until Albert Einstein's 134th Birthday

Re: [Squirrel-sql-users] what to do with fw.jar

[René A V. <RVa...@ct...>]

>> I think you may have asked (knowingly or unknowingly) to receive
notifications…

 

I did request “Update Notifications”, thinking that would let me know when
SQuirreL were updated to a new level.  I didn’t realize that I would get
notices for trivial events.  I’ve unsubscribed.

 

In the meantime, it’s still puzzling why I get the notices in pairs.  The
last email from you came twice at the same time again.

 

Thanks!

 

René A Valencourt, CCP, MCTS
IS Dept.
CTB, Inc.
A Berkshire Hathaway Company

574.658.5208
574.658.8002 (FAX)

 

 

From: Robert Manning [mailto:rob...@gm...] 
Sent: Monday, February 25, 2013 7:43 PM
To: RVa...@ct...
Cc: Squirrel SQL users list
Subject: Re: [Squirrel-sql-users] what to do with fw.jar

 

Well, that is confusing, isn't it?  I think you may have asked (knowingly or
unknowingly) to receive notifications when there were updates to the
SQuirreL project, via the SourceForge page.  Maybe it was "Watch this
project" or something like that.  In any case, I think these notifications
were triggered by our automatic nightly snapshot upload - the dates
correspond with commits to the source code.  So, you can ignore these
notifications.  They do not apply to the version you have installed.

Rob

On Mon, Feb 25, 2013 at 11:01 AM, René A Valencourt <RVa...@ct...>
wrote:

Rob,

I received notices February 11, 12, 18, and 20.  Upon cursory perusal, it
appears that the archives may be identical aside from the pom.properties
file; however, at least that file is different in each one.

The links appear to be straightforward.

I have attached the emails for you to examine.  By the way, I get these
notices in pairs, sent out simultaneously to the same email address…

René A Valencourt, CCP, MCTS
IS Dept.
CTB, Inc.
A Berkshire Hathaway Company

574.658.5208
574.658.8002 (FAX)

 

 

From: Robert Manning [mailto:rob...@gm...] 
Sent: Monday, February 25, 2013 10:26 AM
To: RVa...@ct...
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] what to do with fw.jar

There have been no further updates to the stable version (3.4.0).  What is
the update URL that you are using ?

Rob

 

On Mon, Feb 25, 2013 at 10:15 AM, René A Valencourt <RVa...@ct...>
wrote:

Hi Rob,

>> The SQuirreL installer places this file along with many other jar files
in the lib/ folder.

Yes, it did.

>> You appear to have the latest stable version installed (3.4.0).  Are you
looking for information on how to install a snapshot version?

My installation is a Windows 7 desktop.  I received notices (due to my
subscription to SQuirreL notifications) that a new fw.jar was available.
This was subsequent to the release of 3.4.0, and the notices mention only
the fw.jar file, hence my question.

If I understand you correctly, you’re saying that all I need to do is
replace the fw.jar file in the lib folder, that no further installation is
needed than what has already been done.  ?

René A Valencourt, CCP, MCTS
IS Dept.
CTB, Inc.
A Berkshire Hathaway Company

574.658.5208
574.658.8002 (FAX)

 

From: Robert Manning [mailto:rob...@gm...] 
Sent: Saturday, February 23, 2013 6:59 AM
To: RVa...@ct...
Subject: Re: [Squirrel-sql-users] what to do with fw.jar

The archive file "fw.jar" is a core library of "framework" classes used by
SQuirreL.  The SQuirreL installer places this file along with many other jar
files in the lib/ folder.  You shouldn't need to replace individual files in
the this directory manually, unless directed to do so by a developer.  The
installer and the software update feature will do this for you.  You appear
to have the latest stable version installed (3.4.0).  Are you looking for
information on how to install a snapshot version?

Rob

 

On Thu, Feb 21, 2013 at 9:47 AM, René A Valencourt <RVa...@ct...>
wrote:

I have found no instructions on what to do with fw.jar.

I have found it in the Squirrel-sql-3.4.0\lib directory.  Do I just replace
it, or is there an install process?

What exactly is the purpose of fw.jar?

Thanks,

René

_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


************************************************************
This message may contain privileged, confidential and/or
trade secret information which is protected by law and is
intended only for the addressee.  If you are not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this message is strictly
prohibited.  If you have received this message in error, 
please immediately notify us, and permanently delete all
copies of the message.  Due to the nature of the Internet, 
e-mail messages are not secure and may be delayed or
undelivered.  Also, in accordance with CTB company policy,
e-mail messages may be reviewed or retained by CTB
employees in addition to or other than the intended recipient.


This footnote also confirms that this email message has
been swept by Postini for the presence of computer viruses.
************************************************************

Re: [Squirrel-sql-users] what to do with fw.jar

[Robert M. <rob...@gm...>]

Well, that is confusing, isn't it?  I think you may have asked (knowingly
or unknowingly) to receive notifications when there were updates to the
SQuirreL project, via the SourceForge page.  Maybe it was "Watch this
project" or something like that.  In any case, I think these notifications
were triggered by our automatic nightly snapshot upload - the dates
correspond with commits to the source code.  So, you can ignore these
notifications.  They do not apply to the version you have installed.

Rob

On Mon, Feb 25, 2013 at 11:01 AM, René A Valencourt
<RVa...@ct...>wrote:

> Rob,****
>
> ** **
>
> I received notices February 11, 12, 18, and 20.  Upon cursory perusal, it
> appears that the archives may be identical aside from the pom.properties
> file; however, at least that file is different in each one.****
>
> ** **
>
> The links appear to be straightforward.****
>
> ** **
>
> I have attached the emails for you to examine.  By the way, I get these
> notices in pairs, sent out simultaneously to the same email address…****
>
> ** **
>
> ** **
>
> René A Valencourt, CCP, MCTS
> IS Dept.
> CTB, Inc.
> A Berkshire Hathaway Company****
>
> 574.658.5208
> 574.658.8002 (FAX)****
>
> ** **
>
> ** **
>
> ** **
>
> *From:* Robert Manning [mailto:rob...@gm...]
> *Sent:* Monday, February 25, 2013 10:26 AM
> *To:* RVa...@ct...
> *Cc:* squ...@li...
>
> *Subject:* Re: [Squirrel-sql-users] what to do with fw.jar****
>
> ** **
>
>
> There have been no further updates to the stable version (3.4.0).  What is
> the update URL that you are using ?
>
> Rob****
>
> ** **
>
> On Mon, Feb 25, 2013 at 10:15 AM, René A Valencourt <
> RVa...@ct...> wrote:****
>
> Hi Rob,****
>
> >> The SQuirreL installer places this file along with many other jar
> files in the lib/ folder.****
>
> Yes, it did.****
>
> >> You appear to have the latest stable version installed (3.4.0).  Are
> you looking for information on how to install a snapshot version?****
>
> My installation is a Windows 7 desktop.  I received notices (due to my
> subscription to SQuirreL notifications) that a new fw.jar was available.
> This was subsequent to the release of 3.4.0, and the notices mention only
> the fw.jar file, hence my question.****
>
> If I understand you correctly, you’re saying that all I need to do is
> replace the fw.jar file in the lib folder, that no further installation is
> needed than what has already been done.  ?****
>
> René A Valencourt, CCP, MCTS
> IS Dept.
> CTB, Inc.
> A Berkshire Hathaway Company****
>
> 574.658.5208
> 574.658.8002 (FAX)****
>
>  ****
>
> *From:* Robert Manning [mailto:rob...@gm...]
> *Sent:* Saturday, February 23, 2013 6:59 AM
> *To:* RVa...@ct...
> *Subject:* Re: [Squirrel-sql-users] what to do with fw.jar****
>
> The archive file "fw.jar" is a core library of "framework" classes used by
> SQuirreL.  The SQuirreL installer places this file along with many other
> jar files in the lib/ folder.  You shouldn't need to replace individual
> files in the this directory manually, unless directed to do so by a
> developer.  The installer and the software update feature will do this for
> you.  You appear to have the latest stable version installed (3.4.0).  Are
> you looking for information on how to install a snapshot version?
>
> Rob****
>
>  ****
>
> On Thu, Feb 21, 2013 at 9:47 AM, René A Valencourt <RVa...@ct...>
> wrote:****
>
> I have found no instructions on what to do with fw.jar.
>
> I have found it in the Squirrel-sql-3.4.0\lib directory.  Do I just replace
> it, or is there an install process?
>
> What exactly is the purpose of fw.jar?
>
> Thanks,
>
> René****
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users****
>