E9.2 Can a query be build in JDE using 'EXECUTE IMMEDIATE'-like functions?

Felipe Vidal

Active Member
Let's say I have a table in JDE from which I can assemble a SELECT-type query, including fields, tables, JOINs, &c. Somehow I can add the logic to build up a string that would look like my sentence.

Is there a way to execute that query & retrieve the results into a Fetch-like command for variable-assignation? I know if can be done using PL/SQL, with the EXECUTE IMMEDIATE function, but I don't know if JDE per se can do that.