Execute SQL Statement from JDE Applications
                     Is there a way to execute SQL Statement from JDE Application? I want to select a random record from location master for cycle count. The SQL statement which I build will look like 
                SELECT LCMCU, LMLOCN, RAND () AS RID from TESTDTA.F4100 WHERE LMLOCN > ' ' ORDER BY RID FETCH FIRST 1 ROWS ONLY;
Thanks,
0