Hi All,
One of our customers have raised following concern,
“is there a function in IFS that can accept SQL statements and return the results in a table format?”
Does anyone have an idea about this?
Page 1 / 1
I am not sure I understand the question… Does the customer want to do reporting? Performing an SQL statement and getting back data is what a Quick Report does, or one can create an IAL or Lobby data source to return data.
If you mean an Oracle facility to take any string and execute it, I would wonder why that is desirable? SQL can already perform very advanced queries where you can return almost anything you can imagine, including hierarchical, pivoted, and list-aggregated data. Throw in some WITH statements, sub-selects, and API calls and there isn’t much you can’t do.
In PL/SQL code, you can write code that returns datasets via things like dynamic querying, ref cursors, and pipelining. Is that what they are referring to?
Joe Kaufman
Search QUICK REPORTS .. these are lists based on SQL statements.
Pivoting is the answer
Jari
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.