I am developing Visual C++ program to access DB2 database. I check the following doc:
and find there are so many options for my C++ program to access the database, mainly 4 of them:
1. Embed static and dynamic SQL statements in your applications
2. Code DB2 Call Level Interface (DB2 CLI) function calls in your applications to invoke dynamic SQL statements.
I just wonder if I need to insert a large volume of data, will there be big difference between these 4 APIs? Also for support to native DB2 data type, such as DATALINK, will these four APIs have some differences?