Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Execute SQL Statement from JDE Applications

edited Nov 2, 2010 1:08AM in Design Tools & Output Technologies - JDE1 (MOSC) 2 commentsAnswered
 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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center