This page describes the new "connection" style database methods. Methods exist to create local database tables, merge them with external databases, and perform queries on external databases.
Note: first use db.connect function to create the connection object - then use the methods on the connection object.
For more information on how Iguana Translator scripts work with databases, see Mapping To/From Databases.
In Iguana 5.0.14 a bug was fixed when 0 or "" (empty string) was returned from a database as a NULL value - now 0 and "" are returned correctly.
| Supported Database | Database code to use with the api parameter |
| My SQL | db.MY_SQL |
| Oracle OCI | db.ORACLE_OCI |
| Oracle ODBC | db.ORACLE_ODBC |
| SQL Lite | db.SQLITE |
| Microsoft SQL Server | db.SQL_SERVER |
| Postgres | db.POSTGRES |
| DB2 | db.DB2 |
| Informix | db.INFORMIX |
| Interbase | db.INTERBASE |
| Filemaker | db.FILEMAKER |
| Sybase ASA | db.SYBASE_ASA |
| Sybase ASE | db.SYBASE_ASE |
| MS Access | db.ACCESS |