summaryrefslogtreecommitdiffstats
path: root/r/connect.R (plain)
blob: 7d2829cf80d92a7b15eb44b5910271a8a474f84d
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
require (RJDBC);
drv <- JDBC ("com.ibm.db2.jcc.DB2Driver");
conn <- dbConnect (drv, "jdbc:db2:exp004");

dbListTables (conn);

dbGetQuery (conn, "SELECT COUNT(*) FROM vis_collect");

d <- dbReadTable (conn, "vis_collect");

summary (d);

hist (d$"N_CITES");

dbDisconnect (conn);
dbUnloadDriver (drv);

Valid XHTML 1.0 Strict

Copyright © 2009 Don Pellegrino All Rights Reserved.