|
From: Tony (A. A. <aan...@bc...> - 2012-09-07 20:01:14
|
We are running db2 v9 NFM and db2 v10 CM. Both on zos 1.13. Connecting with jdbc.
-----Original Message-----
From: VJ...@ge... [mailto:VJ...@ge...]
Sent: Friday, September 07, 2012 2:40 PM
To: squ...@li...
Subject: Re: [Squirrel-sql-users] Squirrel-sql-users Digest, Vol 75, Issue 2
Hi,
Did anyone able to configure the Squirrel-sql for IBM DB2 9( Function Mode) Version running in Z/OS 1.13.
Thanks, Jasti
--------------------------------------------
Venkatachalapati Rao. JASTI
Information Technology |NA Primary Insurance Systems| Gen Re - A Berkshire Hathaway Company | 120 Long Ridge Road, Stamford, CT 06902 |
Phone:203-328-5533 (W) | 203-400-5642 (M)| E-mail : vj...@ge...
From: squ...@li...
To: squ...@li...,
Date: 09/07/2012 03:30 PM
Subject: Squirrel-sql-users Digest, Vol 75, Issue 2
Send Squirrel-sql-users mailing list submissions to
squ...@li...
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
or, via email, send a message with subject or body 'help' to
squ...@li...
You can reach the person managing the list at
squ...@li...
When replying, please edit your Subject line so it is more specific than "Re: Contents of Squirrel-sql-users digest..."
Today's Topics:
1. Re: According to the driver "PostgreSQL", the url
"flybase.org" is invalid... (Stefan Willinger)
2. Re: Using Squirrel on AS400 ISeries (Stefan Willinger)
3. Re: Auto-update doesn't (Ofnuts)
4. Re: Auto-update doesn't (Ofnuts)
5. Invalid catalog views referenced for Mainframe DB2
(Tony (Antonious) Anderson)
----------------------------------------------------------------------
Message: 1
Date: Sat, 01 Sep 2012 15:53:44 +0200
From: Stefan Willinger <ste...@ao...>
Subject: Re: [Squirrel-sql-users] According to the driver
"PostgreSQL", the url "flybase.org" is invalid...
To: squ...@li...
Message-ID: <504...@ao...>
Content-Type: text/plain; charset="iso-8859-1"
Can you tell us the connection string you are using?
Stefan
On 2012-08-28 17:46, Scott Robinson wrote:
> Dear all,
>
> I am trying to connect to the public PostgreSQL database at
> http://flybase.org but am receiving the error message:
>
> "According to the driver "PostgreSQL", the url "flybase.org
> <http://flybase.org>" is invalid."
>
> I am new to using Squirrel and have looked through the documentation
> but do not know what I could be doing wrong. Any advice would be very
> much appreciated.
>
> Thanks,
>
> Scott
>
>
>
------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond.
> Discussions will include endpoint security, mobile security and the
> latest in malware threats.
> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 2
Date: Sat, 01 Sep 2012 16:05:01 +0200
From: Stefan Willinger <ste...@ao...>
Subject: Re: [Squirrel-sql-users] Using Squirrel on AS400 ISeries
To: Massimo Re <max...@gm...>,
"squ...@li..."
<squ...@li...>
Message-ID: <504...@ao...>
Content-Type: text/plain; charset="iso-8859-1"
Hi,
in the past, sometimes I encountered a similar problem, that the code completion doesn't work always. In my eyes, it doesn't work in a sub-select statement. But mostly, code completion works like a charm.
For some configuration items, please have a look at "File >> New Session Properties >> Code Completion". You can try some of the options.
If you have an example, when the code completion doesn't work, please let us know the situation, than we can have a closer look.
Did you notice some errors or warnings in the log panel (usually they are in red)?
Otherwise, you can update to 3.4 of SQuirreL.
Stefan
On 2012-08-29 11:22, Massimo Re wrote:
> Hi Stefan
> I can't understand why when i hit CTRL+SPACE to see columns name,
> often i can't see them but table names or view names ...
> Sometimes i see them ....
> Is a possible configuration problem ?
> Squirrel version 3.3
> Windows 7
> Dbase : AS400 Iseries
> Thank for your help.
> Max
>
> 2012/8/26 Stefan Willinger <ste...@ao...
> <mailto:ste...@ao...>>
>
> Hi,
>
>> 1) What is the equivalent ORACLE DESC command ?
> You can use the Objects Browser to learn about the structure of a
> table. Just navigate to a table and you will get some information
> (e.g. columns, create script, content) about it.
>
>
>> 2) I've see that in ORACLE SQLDEVELOPER, after you digit SELECT
>> FROM MYTABLE a list of all fields of the table appear so you can
>> easy select or digit the correct name.
>> The same list appear also after WHERE ...
>> Is possible to do the same in Squirrel 3.3 (or 3.4) ? If yes how ?
> Yes, it is possible. You can use the plugin "codecompletion". I
> think, it is already in the base version of SQuirreL. You can
> activate it by hitting CTRL+SPACE. This plugin allows you to
> complete keywords as well as table or column names.
>
> Stefan
>
>
>
> On 2012-08-25 15:41, Massimo Re wrote:
>> Hi all
>> I'm using Squirrel 3,3 on AS400 ISeries ... it work fine.
>> I've some questions ...
>> 1) What is the equivalent ORACLE DESC command ?
>> 2) I've see that in ORACLE SQLDEVELOPER, after you digit SELECT
>> FROM MYTABLE a list of all fields of the table appear so you can
>> easy select or digit the correct name.
>> The same list appear also after WHERE ...
>> Is possible to do the same in Squirrel 3.3 (or 3.4) ? If yes how ?
>> Thank for your help !
>> Max
>>
>>
>>
------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond.
Discussions
>> will include endpoint security, mobile security and the latest in
malware
>> threats.http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>
>>
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li... <
mailto:Squ...@li...>
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
>
------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond.
> Discussions
> will include endpoint security, mobile security and the latest in
> malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> <mailto:Squ...@li...>
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 3
Date: Sat, 01 Sep 2012 18:11:57 +0200
From: Ofnuts <of...@la...>
Subject: Re: [Squirrel-sql-users] Auto-update doesn't
To: squ...@li...
Message-ID: <504...@la...>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
On 09/01/2012 03:52 PM, Stefan Willinger wrote:
> Oh, you are running a IBM-JVM :-)
Yes, doing data processing for real men :)
> Is this the full stacktrace in the logfile? Usually, stacktraces where
> Springframework is involved are much longer.
That's all there is to it, But AFAIK it is complete (the "...16 more"
indicate it's the same 16 last lines as the exception above).
> You can see a NullPointerException in a GenericTypeResolver of
> Springframework. To ensure, that this doesn't depend on your IBM-Java,
> it would be nice, if you can try this with OpenJDK or Oracle's JVM.
OK, if I find some spare time I will. Just have to find a way to have both runtimes coexist on my system.
> If you want an easy solution, I suggest you to download the plain zip
> package of SQuirreL 3.4.0 and I am sure, you will have no troubles.
> You will not loose your settings.
> But on the other hand, if you can test some various Java Versions,
> then you can help us to improve SQuirreL.
I understand that... will do my best :) Very satisfied with the current version anyway, so the update can wait a bit.
------------------------------
Message: 4
Date: Sat, 01 Sep 2012 21:11:03 +0200
From: Ofnuts <of...@la...>
Subject: Re: [Squirrel-sql-users] Auto-update doesn't
To: squ...@li...
Message-ID: <504...@la...>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
OK, installed a Sun V6 runtime and installs runs fine (and new version seems OK with the IBM JVM).
Before that I took a snapshot of my Squirell installation at level
3.3.0 with the updates directory at the ready, so if necessary I can replay the update process with the IBM JVM with some more tracing code.
Contact me directly at this address if you want me to try specific things.
Cheers.
On 09/01/2012 06:11 PM, Ofnuts wrote:
> On 09/01/2012 03:52 PM, Stefan Willinger wrote:
>> Oh, you are running a IBM-JVM :-)
> Yes, doing data processing for real men :)
>
>> Is this the full stacktrace in the logfile? Usually, stacktraces
>> where Springframework is involved are much longer.
> That's all there is to it, But AFAIK it is complete (the "...16 more"
> indicate it's the same 16 last lines as the exception above).
>
>> You can see a NullPointerException in a GenericTypeResolver of
>> Springframework. To ensure, that this doesn't depend on your
>> IBM-Java, it would be nice, if you can try this with OpenJDK or Oracle's JVM.
> OK, if I find some spare time I will. Just have to find a way to have
> both runtimes coexist on my system.
>
>> If you want an easy solution, I suggest you to download the plain zip
>> package of SQuirreL 3.4.0 and I am sure, you will have no troubles.
>> You will not loose your settings.
>> But on the other hand, if you can test some various Java Versions,
>> then you can help us to improve SQuirreL.
> I understand that... will do my best :) Very satisfied with the
> current version anyway, so the update can wait a bit.
>
------------------------------
Message: 5
Date: Fri, 7 Sep 2012 14:14:07 -0500
From: "Tony (Antonious) Anderson" <aan...@bc...>
Subject: [Squirrel-sql-users] Invalid catalog views referenced for
Mainframe DB2
To: "squ...@li..."
<squ...@li...>
Message-ID:
<FA2...@MS...>
Content-Type: text/plain; charset="us-ascii"
When looking through the object tree for Triggers and Indexes, Squirrel attempts to run queries against SYSCAT.TRIGGERS and SYSCAT.INDEXES. These are not valid catalog objects in mainframe DB2. This causes -204, -514, and -516 sql errors in the tool. How would one go about getting Squirrel updated to use the SYSIBM.SYSTRIGGERS and SYSIBM.SYSINDEXES instead?
Thanks.
***CONFIDENTIALITY NOTICE***
This e-mail is intended for the sole use of the individual(s) to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. You are hereby notified that any dissemination, duplication, or distribution of this transmission by someone other than the intended addressee or its designated agent is strictly prohibited. If you receive this e-mail in error, please notify me immediately by replying to this e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
------------------------------
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
End of Squirrel-sql-users Digest, Vol 75, Issue 2
*************************************************
----------------------------------------------------------------------
This transmission, including attachments, is intended for the person or company named and may contain confidential and/or legally privileged information. Unauthorized disclosure, copying or use of this information may be unlawful and is prohibited. If you are not the intended recipient, please delete the original and all copies of this transmission and notify the sender.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|
