getHaving() Method

Usage

public java.lang.String getHaving()

Description

Allows the retrieval of the SQL statement HAVING (on the source during loading, on the staging area during integration). This statement is automatically computed from the filter expressions containing detected aggregation functions.

Parameters

None

Examples

insert into <%=odiRef.getTable("L", "COLL_NAME", "W")%>
select <%=odiRef.getColList("", "[EXPRESSION]", ", ", "", "INS=1")%>
from <%=odiRef.getFrom()%>
where (1=1)
<%=odiRef.getJoin()%>
<%=odiRef.getFilter()%>
<%=odiRef.getGrpBy()%>
<%=odiRef.getHaving()%>