Archives of the TeradataForum

Message Posted: Tue, 30 Dec 2003 @ 14:46:40 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Another option is to use SQL Assistant.

Switch on Export and issue:

   Select 'Select '
        , ColumnName
        , ', count(*) from YourDB.YourTbl where '
        , ColumnName
        , ' Is NULL Group By 1;'

        From dbc.columns

        where Databasename='YourDB' and TableName='YourTbl'

Load the resulting export file into the query window and remove the first line (This is the title line)

Execute the Query.

If you export the results to a file (and make sure your export options are set to write all results to a single file) you will get a result file with 2 columns - Column name, and count of nulls. It will not be a simple 2 column output but a set of outputs. It is still basically a 2 column file however.

In many cases you would use Import to run the second part but in this case you are substituting a column name (rather than a value) into a Select statement. Import only allows substitution of values in Select,Insert, Update and Delete statements. (Because it uses true parameterized queries in these cases.) For other statements it uses direct substitution so you could replace either a name or a value.

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>