Examples of org.teiid.query.sql.proc.IfStatement

org.teiid.query.sql.proc.IfStatement

This class represents an if-else statement in the storedprocedure language. It extends the Statement that could part of a block. This statement has an IF block and an optional ELSE block, it also holds reference to the criteria that determines which block should be executed..

    List elmnts = new ArrayList(1);
    elmnts.add(sy1);
    CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);      
      Criteria crit = new HasCriteria(cs);
      
      IfStatement ifStmt = new IfStatement(crit, ifblock);
    helpTest(ifStmt, "IF(HAS LIKE CRITERIA ON (x))\nBEGIN\nDELETE FROM g;\na = 1;\nERROR 'My Error';\nEND"); //$NON-NLS-1$
    }

View Full Code Here

    List elmnts = new ArrayList(1);
    elmnts.add(sy1);
    CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);      
      Criteria crit = new HasCriteria(cs);
      
      IfStatement ifStmt = new IfStatement(crit, ifblock);
    helpTest(ifStmt, "IF(HAS LIKE CRITERIA ON (x))\nBEGIN\nDELETE FROM g;\nEND"); //$NON-NLS-1$
    }

View Full Code Here

      Criteria crit = new HasCriteria(cs);
      
      Block elseblock = new Block();
      elseblock.addStatement(cmdStmt);
      
      IfStatement ifStmt = new IfStatement(crit, ifblock, elseblock);
    helpTest(ifStmt, "IF(HAS LIKE CRITERIA ON (x))\nBEGIN\nDELETE FROM g;\na = 1;\nERROR 'My Error';\nEND\nELSE\nBEGIN\nDELETE FROM g;\nEND"); //$NON-NLS-1$
    }

View Full Code Here

0 1 2 3

TOP

Related Classes of org.teiid.query.sql.proc.IfStatement

org.teiid.query.optimizer.ProcedurePlanner

org.teiid.query.parser.TestOptionsAndHints

org.teiid.query.parser.TestParser

org.teiid.query.resolver.command.UpdateProcedureResolver

org.teiid.query.rewriter.QueryRewriter

org.teiid.query.sql.lang.Criteria

org.teiid.query.sql.proc.TestIfStatement

org.teiid.query.sql.visitor.TestSQLStringVisitor

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.