executeJDBC(sqlQuery, driverClass, con, user, password, keepAlive)
sqlQuery | a string containing the SQL query to execute. |
driverClass | a string containing the name of the Java class for required JDBC driver. |
con | a string containing the JDBC connection string. |
user | a string containing the user name with access to database. |
password | a string containing the password for the given user name on the database. |
keepAlive | a logical. If TRUE, keeps the database connection alive after executing the query. The default is FALSE. |
## Not run: executeJDBC(driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver", con="jdbc:sqlserver://qadb-s2k:1433;databaseName=testdb;user=testqa;password=testqa;", user="testqa", password="testqa", sqlQuery="UPDATE TEST1 SET Weight = NULL WHERE Weight < 2500")executeJDBC(driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver", con="jdbc:sqlserver://qadb-s2k:1433;databaseName=testdb;user=testqa;password=testqa;", user="testqa", password="testqa", sqlQuery="DROP TABLE TEST1") ## End(Not run)