 |
 |
Archives of the TeradataForum
Message Posted: Wed, 17 Dec 2003 @ 08:40:43 GMT
| Subj: | | Re: Database Unspecfied? |
| |
| From: | | McCann, Andy |
Along these lines, I believe best practice to be to always fully qualify everything OR use a view layer to make sure you only need
point the job in one place. Having a mix of qualified and unqualified tables and columns can cause problems, especially if there are
logic flaws in the SQL. If you know you are being consistent, you can remove this from the equation should you have to sort out
problems.
Happy Christmas
Andy
| |
