Initializing help system before first use

Using other data sources

The initializations block can work with many different data sources and formats thanks to the notion of I/O drivers.

I/O drivers for physical data files:
  • mmodbc.odbc for databases with ODBC connector
  • mmsheet.excel for MS Excel spreadsheets
  • mmsheet.xls and mmsheet.xlsx for generic spreadsheet access, including on non-Windows platforms
  • mmsheet.csv for CSV format files
  • mmoci.oci for Oracle databases
  • mmetc.diskdata for mp-model style data files

Other drivers are available, e.g. for data exchange in memory between models or between a model and the host application.

Change of the data source = change of the I/O driver, no other modifications to your model

initializations from "mmsheet.xls:mydat.xls"
 COST as 'CostData'
end-initializations

initializations to "mmodbc.odbc:mydat.mdb"
 SOL as 'SolTable'
end-initializations

Parent Topic Data handling basics

© 2001-2019 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.