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 ...