The star (asterisk) in SELECT statements

Informix® allows you to use the star character in the select list along with other expressions:

SELECT col1, * FROM tab1 ...

IBM® DB2® does not support this. You must use the table name as a prefix to the star:

SELECT col1, tab1.* FROM tab1 ...

Solution

Always use the table name with stars.