WebFocus 中直接使用SQL 语句

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语句的写法。