Advertisement
Guest User

Untitled

a guest
Jan 25th, 2017
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. library(RJDBC)
  2. .jaddClassPath( "/home/517066/sqllib/SQLLIB/java/db2jcc_license_cu.jar" )
  3. .jaddClassPath( "/home/517066/sqllib/SQLLIB/java/db2jcc4.jar" )
  4.  
  5. #Then we need to load the DB2 JDBC driver:
  6. driver <- JDBC("com.ibm.db2.jcc.DB2Driver","home/517066/sqllib/SQLLIB/java/db2jcc4.jar")
  7.  
  8. #At this point we can establish a database connection:
  9. conn = dbConnect(driver,
  10. "jdbc:db2://ip:port/databaseName",
  11. user="username",
  12. password="password")
  13. #Let’s run a query and #store the results into a data frame:
  14. query = "SELECT * FROM SYSIBM.SYSTABLES WHERE NAME LIKE '%USER%'"
  15.  
  16. rs = dbSendQuery(conn, query)
  17. data_frame = fetch(rs, -1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement