Create table QTEMP/IFC as ( SELECT AUTOSTART AS IFCSTS, INTERNET AS ADRIP, LIND AS LIGNE, SUBNETMASK AS MASK, TEXT AS TEXTE FROM QUSRSYS/QATOCIFC WHERE LIND <> ' ' AND LIND <> '*LOOPBACK' ORDER BY AUTOSTART DESC, LIND ) With DATA