JDBC allows you to throw any string at the DB that you can, including database specific sql/dml. So if the database can execute the command ( proprietary of not ) it will. If it is DML or an update of some kind, use statement.executeUpdate( sql )just like you would a standard SQL92 query. There are no limitations on what can be put in your sql string. That only limitation is whether the database/driver implementation can handle the request.
ok you say : if the database and the driver of course supports any string command to be interpreted by the database engine; then it works. I tried it and ok. My problem was to make a sybase specific query. It was working on isql, the command based sql*plus -like tool, and wondered if I could use that command string just as is, without changing anything? Thanks..