Re: [Squirrel-sql-users] Using Squirrel on AS400 ISeries

[Stefan W. <ste...@ao...>]

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
>
>