Archives of the TeradataForum
Message Posted: Wed, 19 Apr 2001 @ 02:57:56 GMT
| Subj: || || Re: Executing SQL from a Column |
| From: || || Dean Arnold |
If you're willing to sling some Perl, you can probably cause your SQL-rendering SQL to add enough of a Perl DBI wrapper so you can just
run "eval $rendered_sql;" on whatever comes back. In the alternative, you can just render SQL, then stuff the SQL statement in a
prepare/execute sequence (which also works for ODBC/CLI/JDBC, tho Perl is much simpler to use).