can any one help please. Following is the code we are using to access the database
install.packages("RODBC")
install.packages("ibmdbR")
library(RODBC)
library(ibmdbR)
Sys.setenv(LD_LIBRARY_PATH="/home/db2inst1/sqllib/lib64:/usr/local/ibm/gsk8_64/lib64:/home/db2inst1/sqllib/lib32")
Sys.setenv(LIBPATH="/home/db2inst1/sqllib/lib64:/usr/local/ibm/gsk8_64/lib64:/home/db2inst1/sqllib/lib32")
Sys.setenv(ODBCSYSINI="/etc/odbc.ini")
host.name <- "dashdb-enterprise4-yp-softbank-01.services.au-syd.bluemix.net"
port <- "50001"
user.name <-"sbtestuser01"
pwd <- "XxXxXxXxX"
security <- "SSL"
AUTHENTICATION <- "SERVER"
SSLClientKeystoredb <- "/usr/local/ibm/gsk8_64/lib64/mydbclient.kdb"
SSLClientKeystash <- "/usr/local/ibm/gsk8_64/lib64/mydbclient.sth"
driver.name <- "{IBM DB2 ODBC DRIVER}"
con.text <- paste("BLUDB;DRIVER=BLUDB",
";Database=BLUDB",
";Hostname=",host.name,
";Port=",port,
";security=",security,
";AUTHENTICATION=",AUTHENTICATION,
";SSLClientKeystoredb=",SSLClientKeystoredb,
";SSLClientKeystash=",SSLClientKeystash,
";PROTOCOL=TCPIP",
";UID=", user.name,
";PWD=",pwd,sep="")
con <- idaConnect(con.text)