Examples of AliasSymbol


Examples of org.teiid.query.sql.symbol.AliasSymbol

       
        GroupSymbol g = new GroupSymbol("x.y.z"); //$NON-NLS-1$
        From from = new From();
        from.addGroup(g);
       
        AliasSymbol as = new AliasSymbol("fooAlias", new ElementSymbol("fooKey")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
    select.addSymbol(as);

    Query query = new Query();
    query.setSelect(select);
View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_RIGHT_OUTER, crits);
    From from = new From();
    from.addClause(jp);

    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("myG.a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
    select.addSymbol(as);
    select.addSymbol(new ElementSymbol("myH.b")); //$NON-NLS-1$

    Query query = new Query();
View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_RIGHT_OUTER, crits);
    From from = new From();
    from.addClause(jp);

    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("myG.a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
    select.addSymbol(as);
    select.addSymbol(new ElementSymbol("myH.b")); //$NON-NLS-1$

    Query query = new Query();
View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_LEFT_OUTER, crits);
    From from = new From();
    from.addClause(jp);

    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("myG.a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
    select.addSymbol(as);
    select.addSymbol(new ElementSymbol("myH.b")); //$NON-NLS-1$

    Query query = new Query();
View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_LEFT_OUTER, crits);
    From from = new From();
    from.addClause(jp);

    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("myG.a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
    select.addSymbol(as);
    select.addSymbol(new ElementSymbol("myH.b")); //$NON-NLS-1$

    Query query = new Query();
View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

    crits.add(jcrit);   
    JoinPredicate jp = new JoinPredicate(g, h, JoinType.JOIN_FULL_OUTER, crits);
    From from = new From();
    from.addClause(jp);

    AliasSymbol as = new AliasSymbol("myA", new ElementSymbol("myG.a")); //$NON-NLS-1$ //$NON-NLS-2$
    Select select = new Select();
    select.addSymbol(as);
    select.addSymbol(new ElementSymbol("myH.b")); //$NON-NLS-1$

    Query query = new Query();
View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

    From from = new From();
    from.addGroup(g);

    Function f = new Function("replace", new Expression[] {new ElementSymbol("a", false), new Constant("x"), new Constant("y")}); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
    ExpressionSymbol es = new ExpressionSymbol("y", f); //$NON-NLS-1$
    AliasSymbol as = new AliasSymbol("y", es); //$NON-NLS-1$
    Select select = new Select();
    select.addSymbol(as);

    Query query = new Query();
    query.setSelect(select);
View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

        From from = new From();
        from.addGroup(g);

        Function f = new Function("left", new Expression[] {new ElementSymbol("fullname", false), new Constant(new Integer(3))}); //$NON-NLS-1$ //$NON-NLS-2$
        ExpressionSymbol es = new ExpressionSymbol("expr", f); //$NON-NLS-1$
        AliasSymbol as = new AliasSymbol("x", es); //$NON-NLS-1$
        Select select = new Select();
        select.addSymbol(as);

        Query query = new Query();
        query.setSelect(select);
View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

        From from = new From();
        from.addGroup(g);

        Function f = new Function("right", new Expression[] {new ElementSymbol("fullname", false), new Constant(new Integer(3))}); //$NON-NLS-1$ //$NON-NLS-2$
        ExpressionSymbol es = new ExpressionSymbol("expr", f); //$NON-NLS-1$
        AliasSymbol as = new AliasSymbol("x", es); //$NON-NLS-1$
        Select select = new Select();
        select.addSymbol(as);

        Query query = new Query();
        query.setSelect(select);
View Full Code Here

Examples of org.teiid.query.sql.symbol.AliasSymbol

        From from = new From();
        from.addGroup(g);

        Function f = new Function("char", new Expression[] { new Constant("x")}); //$NON-NLS-1$ //$NON-NLS-2$
        ExpressionSymbol es = new ExpressionSymbol("expr", f); //$NON-NLS-1$
        AliasSymbol as = new AliasSymbol("x", es); //$NON-NLS-1$
        Select select = new Select();
        select.addSymbol(as);

        Query query = new Query();
        query.setSelect(select);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.