We are writing queries against our data to find data quality issues. Currently, there are about 500 and have quite a few more to do.
We have a request for high level count of failures for each one. With some pixie dust, we generate a Select ID#, BU, Count(*) for each of these.
In an effort to automate these, we generated a new query with a union inbetween the Count(*) queries.
Now... when we run this, because of the modification of these queries to count (*), there are some errors that we need to resolve.
Is there a way that SQL Assistant can highlight the error or display the line # where the error occurs? It kind of defeats the puropse of automation id we still have to run one at a time to locate the errors..
Is this possible?
If you are referring to SQL syntax errors SQL Assistant will highlight the reported position of the error. This only applies if you use Teradata.net rather than ODBC however.
Note that it will only report the first syntax error since Teradata stops parsing as soon as it finds an error.
I am just used to SQL Server where the cursor goes to the line where your syntax error is or the line is highlighted.
Or if you haven't included all the necessary criteria for an expression.