Previous Topic Next topic Print topic


DB2-1046-00-E Syntax invalid for SELECT DISTINCT

You either used the keyword DISTINCT more than once in a subselect, or it you did not place it directly before the column select list.
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.

Resolution:

Check syntax. Do not use DISTINCT more than once in a subselect. In addition, DISTINCT must precede the column select list.

Previous Topic Next topic Print topic