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