14 Oct 2008
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 .......
14 Oct 2008
oohhh yes,thank you, actually i initially not thought of using that data, so thinking after that step only, its sillythank you very much.regardsAkhshay Gandhi
You must sign in to leave a comment.
hii 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.RegardsAkhshay Gandhi