Result from BTEQ to be loaded in a table

Tools
Enthusiast

Result from BTEQ to be loaded in a table

hi

i am using a shell script to execute a BTEQ script. the result of BTEQ script is transfered to result.log.

i need to use the result of BTEQ script for analysis purpose.

Anyone suggest me how i can transfer the result data to a result table in teradata.

Or if there is any other approach i can use to get only the data table part from log file.

I am creating a C# web application, which indirectly is executing the BTEQ script.

Regards

Akhshay Gandhi
2 REPLIES
Enthusiast

Re: Result from BTEQ to be loaded in a table

why do you want to first dump the o/p of the result set to a log and then load it back to a result table ... ?

you can always modify the bteq to insert directly into a result table.

INSERT INTO
SELECT .......

Enthusiast

Re: Result from BTEQ to be loaded in a table

oohhh yes,

thank you, actually i initially not thought of using that data, so thinking after that step only, its silly

thank you very much.

regards
Akhshay Gandhi