Handling SQL errors when preparing statements

The PostgreSQL connector is implemented with the PostgreSQL libpq API. This library does not provide a way to send SQL statements to the database server during the BDL PREPARE instruction, like the Informix^® interface does. The statement is sent to the server only when opening the cursors or when executing the statement, because the database driver needs to provide the data types of the SQL parameters (only known at OPEN / EXECUTE time).

Therefore, when preparing an SQL statement with the BDL PREPARE instruction, no SQL errors can be returned if the statement has syntax errors or if a column or a table name does not exist in the database. However, an SQL error will occur after the OPEN or EXECUTE instructions.