Archives of the TeradataForum
Message Posted: Thu, 07 Dec 2000 @ 16:05:37 GMT
| Subj: || || Re: Loops in BTEQ? |
| From: || || Jeff Ohlman |
ONe way I've done this is to create a wrapper for BTEQ using Perl. This will work for Unix or Windows. I use Perl to pipe the sql (from
a file or from within the script) to BTEQ. Works like a charm, especially when the sql requires modification on each iteration. Of course
this requires Perl on your system as well as knowledge of Perl. You could use any other method of piping though.