Thanks for that response, it narrows the options down a bit.
To explain the problem a bit more, each source file will in fact be writing to potentially hundreds of tables, and are in IBM mainframe format (EBCDIC, zoned and packed decimal numbers etc). To solve this problem in DB2 I wrote a C application that interfaced with the DB2 CLI (which is ODBC compliant i believe). Ruling out any of the teradata LOAD utilities, what similar options are available for teradata? I quote some possibilities from the teradata website:
>Application Programming Interfaces
>
>Teradata provides a number of standardized interfaces to facilitate easy >development of applications. Included are the ODBC Driver for Teradata, the JDBC >Driver for Teradata, the OLE DB Data Provider for Teradata, the Microsoft .NET >Data Provider for Teradata, the Teradata Call-Level Interface (CLI), and the >TS/API, which permits applications that normally access IBM DB2 to run against >Teradata. Also included are a number of third-party interfaces, such as Sybase >Open Server and Open Client.
I am thinking particulary about the Teradata Call-Level Interface (CLI), where can I find more specific info about this and its potential?
Cheers