/*
 * Copyright (C) 2006 Markus KARG (markus-karg@users.sourceforge.net)
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public final class Foo {

    public static final void main(final String[] args) throws Exception {
        Class.forName("com.sap.dbtech.jdbc.DriverSapDB");
        final Connection c = DriverManager.getConnection("jdbc:sapdb://localhost/SCRUM", "DBA", "SQL");
        c.setAutoCommit(false);

        c.createStatement().execute("CREATE TABLE A (A1 INTEGER)");
        c.createStatement().execute("CREATE TABLE B (B1 INTEGER, B2 INTEGER)");
        c.createStatement().execute("INSERT INTO A (A1) VALUES (456)");
        final PreparedStatement s = c.prepareStatement("SELECT 1 FROM A,B WHERE A.A1=B.B1 AND B.B2=ABS(?)");
        s.setInt(1, 123);
        s.executeQuery();

        c.rollback();
    }
    
}