 |
 |
Archives of the TeradataForum
Message Posted: Fri, 10 Nov 2006 @ 21:49:43 GMT
| Subj: | | Re: Dropping a table from sql assistant |
| |
| From: | | Stone, Randall |
| | If you could mention the reason why you cannot use BTEQ and / or what exactly you want to achieve in your script besides dropping the
table, the probability of Forum members suggesting alternative solutions would be higher. | |
It's not that I don't want to use BTEQ. I just wasn't aware of SQL Assistant's limitations. As it is, I need to have this script finished
before I go home tonight (or I'll be here over the weekend), so I'll finish the prototype using SQL Assistant and learn to use BTEQ next week.
What I'm doing is pulling data from several tables and aggregating it into a summary table, and then using the data in that summary table to
update another table. The data I'm pulling is aggregated from several different systems, and I pull common fields (but differently named) from
those tables into my tables. Since we are in an experimental stage of analyzing this data, I'm constantly modifying the table columns. By doing
the drop and recreate from within the script, I avoid having to do the work twice by changing the insert statement in the script AND altering the
table via a separate script. The typing's nothing, but this way I cut my debugging in half.
Randall
| |
