How to check “Derived table statement” in ikm usin

2019-08-19 00:51发布

问题:

I am trying to generate Ikm with Derived table statement in source command. I can able to set source command but not able to check the check box "Derived table statement" as shown in picture below.

The code I was trying is

SqlGroupType pSqlGroupType = Expression.SqlGroupType.CONSTANT;//valueOf("SQLQUERY");
    String exp="(<%=odiRef.getUserExit(“SQLQUERY”)%>)";
    Expression pExpression= new Expression(exp, pCrossRefs, pSqlGroupType);
    pSourceCommand.setExpression(pExpression);;

    Collection<ProcedureOption> pGenerationConditions=null;

    ob.addLine("SQLQUERY", pTargetCommand, pSourceCommand, pGenerationConditions);
    OdiIKMLine pLine =null ;
    ob.setDerivedSelectStatementLine(pLine);