Question: what is the difference between api mode and utility mode in ab initio?
Answer: API and utility are two possible interfaces to databases from the Ab Initio software and their uses can differ depending on the database in question. ... In general, however, it is useful to remember that API mode executes SQL statements. Utility mode — Makes direct use of the vendor's utilities to access the database.