summaryrefslogtreecommitdiffstats
path: root/r/connect.R (plain)
blob: 75e84df5a4558f948df16da5e1b85d8e9b3469cb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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.