Is it possible to invoke the Utilities inside a SP?

Database
Enthusiast

Is it possible to invoke the Utilities inside a SP?

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 :)

3 REPLIES
Senior Apprentice

Re: Is it possible to invoke the Utilities inside a SP?

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.

Dieter

Enthusiast

Re: Is it possible to invoke the Utilities inside a SP?

Thanks Dieter :) Is it possible to achieve those functionality  using UDF's??

Re: Is it possible to invoke the Utilities inside a SP?

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!