Inside a Stored Procedure i need to read the values from a flat file and load that into a table and do some operations in that. Likewise i also need to do some transformations in some tables and write the output into a flat file. How can i achieve this functionality inside a SP?
Thanks in advance :)
I don't think you can do that in a SQL SP.
But an External SP written in C should be able to achieve that.
Just get my self clarified.
I need to import file from a analytical tool called Spotfire(version5.5) to a table in Teradata.
I am new bee here.
I want to use stored procedure to do so.
In that sense, Data will be taken from Spotfire server (called Spotfire library) and dumped into the teradata using Information link.
Sorry if the above information is confusing. My intended query was, whether is it possible to import flat file to Terdata using Stored Procedure.
Thanks in advance!