Package com.alibaba.druid.sql.dialect.db2.visitor

Examples of com.alibaba.druid.sql.dialect.db2.visitor.DB2OutputVisitor

79
80
81
82
83
84
85
86
87
88
        if (JdbcUtils.SQL_SERVER.equals(dbType) || JdbcUtils.JTDS.equals(dbType)) {
            return new SQLServerExprParser(sql);
        }
       
        if (JdbcUtils.DB2.equals(dbType)) {
            return new DB2ExprParser(sql);
        }

        return new SQLExprParser(sql);
    }
View Full Code Here
37
38
39
40
41
42
43
        super(config, JdbcConstants.DB2);
    }

    @Override
    public SQLStatementParser createParser(String sql) {
        return new DB2StatementParser(sql);
    }
View Full Code Here
54
55
56
57
58
59
60
61
62
63
        if (JdbcUtils.H2.equals(dbType)) {
            return new MySqlStatementParser(sql);
        }
       
        if (JdbcUtils.DB2.equals(dbType)) {
            return new DB2StatementParser(sql);
        }

        return new SQLStatementParser(sql);
    }
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
56
                + "             " //
                + "                AND OH.ORDER_ID = ? ) AS TEMP_TAB ) AS TEMP_TAB_WITH_IDX "//
                + " WHERE TEMP_TAB_WITH_IDX.IDX > 0 AND TEMP_TAB_WITH_IDX.IDX <= 20" //
                + "";

        DB2StatementParser parser = new DB2StatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
public class DB2Values_Test extends DB2Test {

    public void test_0() throws Exception {
        String sql = "values 1";

        DB2StatementParser parser = new DB2StatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
public class DB2SelectTest_1 extends DB2Test {

    public void test_0() throws Exception {
        String sql = "SELECT * FROM DSN81010.EMP FETCH FIRST 5 ROWS ONLY;";

        DB2StatementParser parser = new DB2StatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());

View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
public class DB2SelectTest_0 extends DB2Test {

    public void test_0() throws Exception {
        String sql = "SELECT * FROM DSN81010.EMP;";

        DB2StatementParser parser = new DB2StatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());

View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
public class DB2SelectTest_4 extends DB2Test {

    public void test_0() throws Exception {
        String sql = "select * from t OPTIMIZE FOR 10 ROWS";

        DB2StatementParser parser = new DB2StatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());

View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
public class DB2SelectTest_3 extends DB2Test {

    public void test_0() throws Exception {
        String sql = "select * from t for read only";

        DB2StatementParser parser = new DB2StatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());

View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
public class DB2SelectTest_2 extends DB2Test {

    public void test_0() throws Exception {
        String sql = "SELECT CTRYNUM, FMS_INSTANCE_CD FROM DBEFMSDR.FMSA_O_WW_CTRY_AG WHERE ACCT_YR=? WITH UR";

        DB2StatementParser parser = new DB2StatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);
        print(statementList);

        Assert.assertEquals(1, statementList.size());
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.dialect.db2.visitor.DB2OutputVisitor

  • com.alibaba.druid.bvt.sql.db2.DB2SelectTest_0
  • com.alibaba.druid.bvt.sql.db2.DB2SelectTest_1
  • com.alibaba.druid.bvt.sql.db2.DB2SelectTest_2
  • com.alibaba.druid.bvt.sql.db2.DB2SelectTest_3
  • com.alibaba.druid.bvt.sql.db2.DB2SelectTest_4
  • com.alibaba.druid.bvt.sql.db2.DB2SelectTest_5
  • com.alibaba.druid.bvt.sql.db2.DB2Values_Test
  • com.alibaba.druid.sql.ast.SQLExpr
  • com.alibaba.druid.sql.ast.statement.SQLSelectQuery
  • com.alibaba.druid.sql.DB2Test
    • Copyright © 2018 www.massapicom. 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.