The ECPG library is called libecpg.a or libecpg.so. Additionally, the ECPG library is used for communication to the database server so the source program is linked using -lecpg -lpq.
The following are the methods present in the ECPG library. These methods are “hidden” by default:
● ECPGdebug(int on, FILE *stream) turns on debug logging if called with the first argument non-zero. Debug logging is done on stream. Most SQL statements log the arguments and the corresponding result.
The most important being ECPGdo that is called on almost all SQL statements, logs both its expanded string, i.e. the string with all the input variables inserted, and the result from the database server. This method is quite useful when searching for errors in SQL statements.
● ECPGstatus () returns TRUE if the user is connected to the underlying database and FALSE otherwise.
