Wesley Newswanger | 10 Jul 19:19 2015

Graph plug-in - AND, OR

Can I do an OR in the graph plug-in? I’m not sure how to use the ‘Add new AND folder’ and “Add new OR folder’ buttons.

 

WHERE INVENTORY_MSTR.PART LIKE '315%'

AND INVENTORY_MST2.DESCRIPTION_2 LIKE '%S4S%'

OR

INVENTORY_MSTR.PART LIKE '315%'

AND INVENTORY_MST2.DESCRIPTION_3 LIKE '%S4S%'

 

Best Regards,

Wesley S. Newswanger    IT & Database Administrator

Keystone Collections
Office:  866.881.6680    ext. 1028
Fax:      877.517.8121
Email:    wesleyn <at> keystonecollections.com

------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Massimo Re | 23 Mar 11:16 2015
Picon

SQL2INS

I need to generate a script that provide to INSERT the result of a SELECT statement.

​So i type :

SELECT * FROM MYFILE WHERE DATE>=201401 AND DATE<=201412.

Then i use Ctrl-T ​and select sql2ins.

The problem is, if the result of SELECT have a number of records (rows) too high, a message inform me that there is no enough memory.


Is possibile to generate a file (.SQL) with the INSERT statement (as sql2file) ?

Any other suggestions ?

Thank you for support.

--
Ma
​x
 
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
PAN Jianfei | 19 Mar 11:11 2015

SQL Client realtime console

Hello,

 

I’m a Squirrel user and I fund  Squirrel a good software.

My question is if Squirrel supports “real-time” console ? I mean that when we have too much rows, can Squirrel started to display rows before finished getting all the rows ?

I mean when I use Jisql I fund that the codes for displaying the result is in the while(ResultSet.next()) loop, with this, we can use next() to let the console to wait and add some codes to make a real-time console to see all the modification in the database.

 

I think what now Squirrel does is :  get all the result rows, and display ;  why not make it like a stream : when it gets a row, it displays immediately?   Is it possible?

 

I have to say that I am just a beginner, maybe I was wrong, but I would like to know how do you like this idea ?

Thanks a lot.

 

Best regards,

Jianfei

 

*******************************

This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information. If you are not the intended recipient you are not authorised to distribute, copy or use this e-mail or any attachment to it. Murex cannot guarantee that it is virus free and accepts no responsibility for any loss or damage arising from its use. If you have received this e-mail in error please notify immediately the sender and delete the original email received, any attachments and all copies from your system.

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Frank Pedroza | 4 Mar 20:07 2015
Picon

double quote in password

Not sure what the problem is, but I'm trying to use squirrel to login to a postgres db. The password contains a double quote char ".  I'm unable to login though and don't know what my options are.  I can login fine as a different user with a different password so I know it's specific to my user.  I've also verified that I can login fine as the troublesome user in pgadmin.

I've noticed in my SQLAliases23.xml file that the password is encoded as follows.

<password>foo&quot;bar</password>

Any thoughts (other than remove the quote from the password) would be much appreciated as I'm dying in pgadmin.
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Bob Haury | 1 Mar 17:54 2015
Picon

Install Error

I’m having an issue with installing Squirrel on my Windows 7 machine.  The error I’m receiving is: “This directory can not be written! Please choose another directory” which I did and received the same error.

 

Thanks,

 

Bob Haury

Senior Consultant

 

Peer Consulting, LLC

Your Healthcare Information Technology Partners

 

425.883.3566 O |  425.890.7910 C |

 

2856 80th Avenue S.E., Suite 200

Mercer Island, Washington 98040

http://www.peerconsulting.net

 

 

PRIVILEGED AND CONFIDENTIAL: The information contained in this electronically transmitted message and any file attachments is privileged and confidential and is intended only for the use of the addressee(s).  If the reader of this message is not the addressee, or the person responsible for delivery to the addressee, you are hereby notified that any dissemination, distribution, or copying of this message and any file attachments is strictly prohibited.  If you have received this message in error, please notify the sender by replying via electronic mail and delete the message and any file attachments from your computer.  Thank you.

 

 

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Mariana Santos | 27 Feb 19:26 2015

cannot see synonym tables using Netezza

Hi all,
View are available but Synonym section is empty, anybody had this issue before?

I can query the tables there but cannot get a list of the ones available. Any suggestion on how to fix it would be much appreciated.

Thanks,
Mariana
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Thomas Lenarz | 26 Feb 21:44 2015
Picon

Empty Contents Tab in SQuirreL when Column-Names contain dashes

Hello,

we experience the problem that the contents tab in SQuirreL stays blank,
if a table contains columns whose names contain non standard characters.

For example column-name test-1. The dash is an invalid character.
For most databases this situation is solved by surrounding the 
column-name by quotes as in "test-1".

By analysing the problem and looking into the log files I discovered 
that SQuirreL actually
generates a SELECT-Statement without surrounding the column-name(s) by 
quotes if the column-names contain invalid characters. That is why the 
contents-tab does not show any data.

The problem can be reproduced easily using the following steps (in my 
case with HSQL-DB):

create table test ( "test-1" char(10) )
insert into test values ('1111111111')

SELECT test-1 FROM "PUBLIC"."TEST"; --> won't work (which is correct)

SELECT "test-1" FROM "PUBLIC"."TEST" --> will work

Contents-Tab stays empty.

I consider this a bug in SQuirreL. It should double-quote columns 
containing invalid characters when generating
the SELECT-Statement for the contents tab.

Your opinion about this? Is there a chance to get this changed in SQuirreL?

Thanks a lot,
Thomas

--

-- 
mailto:thomas.lenarz <at> netcologne.de
http://twitter.com/tommesl

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
GMX | 27 Jan 12:34 2015
Picon
Picon

Graph: relations of the foreign key of the tables

Hi,
I have installed Squirrel SQl Client 3.6 on Windows 8.1.
I am connecting to a Embedded Derby Database. All is ok.
I can also show the tables in the Graph.
But I can not see the "relations of the foreign key of the tables" in 
the Graph.

Please can you help me that i can see this relations in the Graph.

--

-- 
Mit freundlichen Grüßen
Hans-Georg Glöckler

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Chuck Brooks | 23 Jan 20:24 2015
Picon

explain plan


I do not see the explain plan option next to the results tab in the sql window. I am running 3.6 of Squirrel SQL and  would like to get a db2 explain plan. I have all the plug ins installed?

I would appreciate some help

Thanks
--
Dr. Chuck Brooks,  DM/IST
(586) 524-9180
------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Stephen Cprek | 23 Jan 18:16 2015
Picon

Connecting to Gerrit H2 database

Hi,


I am trying to do the difficult task of migrating a H2 database to mariaDB for easier replication/master-slave config etc. After lots of researching I decided to give squirrel sql a try.

I was able to connect to my mariaDB.
I have an embedded H2 database running in a gerrit instance.
I got the jdbc driver working for H2 and can create an alias that successfully connects, but it seems like it's not actually connecting.

For testing purposes I copied my h2 db file into a local dir (say gerrit.h2.db)
I create an alias with H2 embedded and
URL: jdbc:h2:<fullpath>/gerrit.h2.db
un/pw can be blank or sa and no pw and it still connects?

When I actually look at it it's has the name, INFORMATION AND PUBLIC SCHEMA. However the PUBLIC schmea is completely empty and that's where the data is if I was to use gsql on the gerrit server.

If I look in my local dir I see a new file was created appending .mv.db???
gerrit.h2.db.mv.db

I don't know what to try next?

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
John Hardin | 23 Jan 17:28 2015

Squirrel vs. JVM 1.8.0_31

Folks:

Just auto-upgraded to Java 1.8.0_31, and now Squirrel is refusing to 
start, displaying a message that it requires at least 1.6. It worked fine 
yesterday before the upgrade.

Any workaround?

--

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jhardin <at> impsec.org    FALaholic #11174     pgpk -a jhardin <at> impsec.org
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
  Today: John Moses Browning's 160th Birthday

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet

Gmane