# this file is to edit the sqls used when drilling down view*actions, only for user define indicators.
#the format should like: "SqlTemplate." + language + "......" (language is the database list value) 

#for Default
SqlTemplate.SQL.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQL.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQL.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQL.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQL.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.SQL.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQL.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQL.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQL.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQL.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQL.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for MySQL
SqlTemplate.MySQL.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.MySQL.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.MySQL.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.MySQL.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.MySQL.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.MySQL.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.MySQL.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.MySQL.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.MySQL.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.MySQL.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.MySQL.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for PostgreSQL
SqlTemplate.PostgreSQL.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.PostgreSQL.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.PostgreSQL.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.PostgreSQL.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.PostgreSQL.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.PostgreSQL.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.PostgreSQL.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.PostgreSQL.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.PostgreSQL.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.PostgreSQL.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.PostgreSQL.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for Teradata
SqlTemplate.Teradata.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Teradata.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Teradata.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Teradata.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Teradata.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.Teradata.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Teradata.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Teradata.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Teradata.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Teradata.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Teradata.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for Adaptive Server Enterprise | Sybase Adaptive Server IQ
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Adaptive_Server_Enterprise_|_Sybase_Adaptive_Server_IQ.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for AS/400
SqlTemplate.AS/400.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.AS/400.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.AS/400.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.AS/400.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.AS/400.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.AS/400.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.AS/400.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.AS/400.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.AS/400.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.AS/400.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.AS/400.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for Microsoft SQL Server
SqlTemplate.Microsoft_SQL_Server.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Microsoft_SQL_Server.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Microsoft_SQL_Server.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Microsoft_SQL_Server.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Microsoft_SQL_Server.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.Microsoft_SQL_Server.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Microsoft_SQL_Server.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Microsoft_SQL_Server.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Microsoft_SQL_Server.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Microsoft_SQL_Server.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Microsoft_SQL_Server.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for Informix
SqlTemplate.Informix.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Informix.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Informix.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Informix.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Informix.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.Informix.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Informix.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Informix.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Informix.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Informix.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Informix.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for SQLite
SqlTemplate.SQLite.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQLite.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQLite.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQLite.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQLite.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.SQLite.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQLite.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQLite.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQLite.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQLite.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.SQLite.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for Hive
SqlTemplate.Hive.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Hive.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Hive.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Hive.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Hive.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.Hive.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Hive.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Hive.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Hive.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Hive.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Hive.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for Oracle
SqlTemplate.Oracle.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Oracle.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Oracle.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Oracle.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Oracle.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.Oracle.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Oracle.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Oracle.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Oracle.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Oracle.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Oracle.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for Access
SqlTemplate.Access.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Access.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Access.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Access.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Access.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.Access.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Access.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Access.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Access.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Access.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.Access.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>

#for DB2
SqlTemplate.DB2.UDI.Count=SELECT COUNT(*) FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.DB2.UDI.Count.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.DB2.UDI.RealValue=SELECT <COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.DB2.UDI.RealValue.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.DB2.UDI.Frequency=SELECT <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> , <SECOND_COLUMN_EXPRESSION_TEXT_FIELD> FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%> GROUP BY <GROUP_BY_TEXT_FIELD>  ORDER BY <ORDER_BY_TEXT_FIELD>
SqlTemplate.DB2.UDI.Frequency.ViewRows=SELECT * FROM <%=__TABLE_NAME__%> WHERE <FIRST_COLUMN_EXPRESSION_TEXT_FIELD> = <%=__INDICATOR_VALUE__%> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.DB2.UDI.Match=SELECT COUNT(CASE WHEN <MATCHING_EXPRESSION_TEXT_FIELD> THEN 1 END), COUNT(*) FROM  <%=__TABLE_NAME__%> WHERE <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.DB2.UDI.Match.ViewValidValues=SELECT <%=__COLUMN_NAMES__%>  FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.DB2.UDI.Match.ViewInvalidValues=SELECT  <%=__COLUMN_NAMES__%> FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.DB2.UDI.Match.ViewValidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE <MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD> <%=__AND_WHERE_CLAUSE__%>
SqlTemplate.DB2.UDI.Match.ViewInvalidRows=SELECT * FROM  <%=__TABLE_NAME__%> WHERE NOT (<MATCHING_EXPRESSION_TEXT_FIELD> AND <WHERE_TEXT_FIELD>) <%=__AND_WHERE_CLAUSE__%>