Selected join after a "Where" clause takes about 10 to 30 secs.for the code completion to display the columns.
Workaround:
Edit an XML file in the {Application}Template\Insight\Default.xml directory
Â
Â
STATUS:
Waiting for fix in future release of Toad for DB2.
Additional Information:
This will still get suggestions on the column names, just not "joins" based on foreign keys. What you need to edit is this (The file might be slightly different but generally the same):
<Chunk>
<Type>Select</Type>
<Type>CreateView</Type>
<Type>SelectAssign</Type>
<Keyword>
<Start>SELECT</Start>
<Include Name="STAR" Type="Virtual"/>
<Include Name="COLUMNS" Type="Extra"/>
<Include Name="SELECTFROM" Type="Virtual" Sorted="Yes"/>
<Include Name="VARIABLE" Type="Virtual"/>
<Include Name="FUNCTION" Type="ObjectParams" Secondary="Yes" Combine="None"/>
<Include Name="UDF" Type="ObjectParams" Secondary="Yes" Combine="None"/>
<Include Name="FUNCTION" Type="Snippet" Secondary="Yes" Combine="None"/>
<Include Name="" Type="Object" Secondary="Yes" AddDot="Yes" Combine="None"/>
</Keyword>
<Keyword>
<Start>GROUP</Start>
<Start>ORDER</Start>
<Include Name="COLUMNS" Type="Extra"/>
<Include Name="VARIABLE" Type="Virtual"/>
<Include Name="FUNCTION" Type="ObjectParams" Secondary="Yes" Combine="None"/>
<Include Name="UDF" Type="ObjectParams" Secondary="Yes" Combine="None"/>
<Include Name="FUNCTION" Type="Snippet" Secondary="Yes" Combine="None"/>
<Include Name="" Type="Object" Secondary="Yes" AddDot="Yes" Combine="None"/>
</Keyword>
<Keyword>
<Start>WHERE</Start>
<Start>HAVING</Start>
<Include Name="COLUMNS" Type="Extra" Combine="Where"/>
<!-- <Include Name="RELATION" Type="Virtual" Combine="Where"/> -- Remove this line --!>
<Include Name="VARIABLE" Type="Virtual" Combine="Where"/>
<Include Name="FUNCTION" Type="ObjectParams" Secondary="Yes" Combine="None"/>
<Include Name="UDF" Type="ObjectParams" Secondary="Yes" Combine="None"/>
<Include Name="FUNCTION" Type="Snippet" Secondary="Yes" Combine="None"/>
<Include Name="" Type="Object" Secondary="Yes" AddDot="Yes" Combine="None"/>
</Keyword>
