IBM Informix Writer Parameters
Database Connection
This is the data source name similar to an ODBC data source name. When you enter the Database in the Destination Dataset field, the Database field will be automatically populated in the Parameters dialog.
Enter the username and password to access the service.
The time (seconds) after which to terminate a query to the database if it has not yet returned a connection/result.
If it is set to 0, there is no timeout. The default is 30.
Advanced
Some features may contain out-of-range or invalid attribute values. These features cannot be written to the database and will be rejected.
- Yes, the translation aborts immediately after encountering this problem.
- No, the translation continues, but the rejected features are not written to the database.
The number of features that FME places in each transaction before a transaction is committed to the database.
The default value is 1000.
You may want to execute some ad-hoc SQL prior to reading or writing a table. For example, it may be necessary to ensure that a view exists prior to attempting to read from it.
Multiple SQL commands can be delimited by a character specified using the FME_SQL_DELIMITER
keyword, embedded at the beginning of the SQL block. The single character following this keyword will be used to split the SQL, which will then be sent to the database for execution.
Note: Include a space before the character.
For example:
FME_SQL_DELIMITER ;
DELETE FROM instructors;
DELETE FROM people WHERE LastName='Doe' AND FirstName='John'
Multiple delimiters are not allowed and the delimiter character will be stripped before being sent to the database.
Any errors occurring during the execution of these SQL statements will normally terminate the reader with an error. If the specified statement is preceded by a hyphen (“-”), such errors are ignored.
You may want to execute some ad-hoc SQL after reading or writing a set of tables. For example, it may be necessary to clean up a temporary view after writing to the database.
Multiple SQL commands can be delimited by a character specified using the FME_SQL_DELIMITER directive, embedded at the beginning of the SQL block. The single character following this directive will be used to split the SQL, which will then be sent to the database for execution.
Note: Include a space before the character.
For example:
FME_SQL_DELIMITER ; DELETE FROM instructors; DELETE FROM people WHERE LastName='Doe' AND FirstName='John'
Multiple delimiters are not allowed and the delimiter character will be stripped before being sent to the database.
Any errors occurring during the execution of these SQL statements will normally terminate the reader with an error. If the specified statement is preceded by a hyphen (“-”), such errors are ignored.
The time (seconds) after which to terminate a query to the database if it has not yet returned a connection/result.
If it is set to 0, there is no timeout. The default is 30.