Sample C program to query and load Teradata

Connectivity

Sample C program to query and load Teradata

I have heard of 2 ways to query and load data into Teradata -
'Teradata Preprocessor2 for Embedded SQL'
Using ODBC driver

I have a requirement to provide a way for C and Fortran applications to query and to load data into Teradata. This should work on Windows, Unix and Linux.

Does any one have sample programs that show both these approaches?

Does any one know the pros and cons of both these approaches?

Thank You.