importJDBC(sqlQuery, table, driverClass = sjdbcOptions()$driverClass, con = sjdbcOptions()$con, user = sjdbcOptions()$user, password = sjdbcOptions()$password, keepAlive = sjdbcOptions()$keepAlive, bigdata = FALSE)
sqlQuery | the SQL query string describing the data to be retreived from the database. Required if table is not provided. |
table | a string specifying the name of the table to import. Required if sqlQuery is not provided. Implies sqlQuery="SELECT * FROM <table>". |
driverClass | a string containing the name of the Java class for the required JDBC driver. |
con | the JDBC connection string. |
user | a string specifying the user name with access to the 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. |
bigdata | unsupported in this version. Exists for compatibility with Spotfire S+. |
## Not run: importJDBC(driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver", con="jdbc:sqlserver://qadb-s2k:1433;databaseName=testdb;user=testqa;password=testqa;", sqlQuery="SELECT * FROM FUEL_FRAME")importJDBC(driverClass="COM.ibm.db2.jdbc.net.DB2Driver", con="jdbc:db2://qadb1:6789/QATESTDB", user="testqa", password="testqa", sqlQuery="SELECT * FROM FUEL_FRAME") ## End(Not run)