Using the Solution Database in FICO Platform

All Xpress components (Insight, Workbench, and Executor) deployed on FICO^® Platform in the same solution, at the same lifecycle stage, will share the solution database.

insightgetsoldbconnstr and insightgetsoldb can be used to access the solution database.

model ODBCTest

uses "mmodbc","mmsystem","mminsight"

public declarations
  connStr: text
  soldb: insightsoldb

  ciphers: list of text
  teams: list of text
  teamnames: list of string

end-declarations

connStr:=insightgetsoldbconnstr
writeln('connection string: ', connStr)

soldb:=insightgetsoldb
writeln('  drivername: ', soldb.drivername)
writeln('  server: ', soldb.server)
writeln('  port: ', soldb.port)
writeln('  username: ', soldb.username)
writeln('  password: ', soldb.password)
writeln('  database: ', soldb.database)
writeln('  odbcparams: ', soldb.odbcparams)

SQLconnect(connStr)
if not getparam('SQLsuccess') then
  writeln('SQL connection error')
  exit(1)
end-if

SQLexecute("SHOW STATUS LIKE 'ssl_cipher'", ciphers)
writeln(ciphers)

teamnames:=["Wibbles", "Wobbles"]

SQLexecute("drop table if exists MoselTest")
SQLexecute("create table MoselTest (team VARCHAR(300))")
SQLexecute("INSERT into MoselTest (team) values(?)", teamnames)

SQLexecute("SELECT team FROM MoselTest ORDER BY team ASC", teams)
if not getparam('SQLsuccess') then
  writeln('SQL read error')
  exit(1)
end-if
writeln(teams)
SQLdisconnect

end-model