ENGINE SQLMSS SET DEFAULT_CONNECTION &CONNECTION
SQL SQLMSS PREPARE SQLOUT FOR
SELECT * from XXX(nolock) where flag='Y' ;
END
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS TMP_OUT1
END
-RUN
-IF &LINES EQ 0 OR &FOCERRNUM NE 0 OR &RETCODE NE 0 GOTO NOMESSAGE;
直接使用SQL语句的写法。