Chapter 3 DBMS Reference Guide

Common entries for Join Index

You can define values for the following common entries for the Join Index object in the DBMS definition.

Entry Example (Sybase Adaptive Server Anywhere 6)
Enable Enable = Yes
Maxlen MaxLen = 128
SqlListQuery In Adaptive Server IQ: 

{JIDX ID, OWNER ID, REFRLIST ...}
SELECT j.joinindex_name, u.user_name, lt.table_name || ',' || rt.table_name || ','
FROM sysiqjoinindex j, sysuserperm u, sysiqjoinixcolumn jc, systable lt, systable rt
WHERE j.joinindex_id = jc.joinindex_id
AND j.creator = u.user_id
AND jc.left_table_id = lt.table_id AND jc.right_table_id = rt.table_id
ORDER BY joinindex_name
SqlAttrQuery 
In Adaptive Server IQ:


{JIDX ID, OWNER ID, RFJNLIST ...}
SELECT j.joinindex_name, u.user_name, lt.table_name || '.' || lc.column_name || '=' || rt.table_name || '.' || rc.column_name || ','
FROM sysiqjoinindex j, sysuserperm u, sysiqjoinixcolumn jc, systable lt, systable rt, syscolumn lc, syscolumn rc
WHERE j.joinindex_id = jc.joinindex_id
AND j.creator = u.user_id
AND jc.left_table_id = lt.table_id AND jc.right_table_id = rt.table_id
AND jc.left_column_id = lc.column_id AND jc.right_column_id = rc.column_id  
AND lc.table_id = lt.table_id AND rc.table_id = rt.table_id
ORDER BY joinindex_name
Options 
_
Drop 
if exists(select 1 from sys.sysiqjoinindex where joinindex_name='%JIDX%') then
   drop join index %JIDX%
end if
Add 
_
DefOptions 
_
Create 
create join index %JIDX% for
%JIDXDEFN%
ModifiableAttributes List of extended attributes that will be taken into account in the merge dialog box during database synchronization
ReversedStatements List of statements that will be reverse engineered

For a description of each of the common object entries, see section "Common object entries".

 

Copyright (C) 2005. Sybase Inc. All rights reserved.