Loading into multiple tables from single source file
Does anyone know if the FastLoad utility can be used to load into multiple tables from a single source file? Say you have a source file with several record types, and you wish for each of the record types to be loaded into their own table, can this tool be used for that? I have tried a similar attempt on DB2 with its LOAD utility with no success.
Re: Loading into multiple tables from single source file
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?