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?
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?
Pivoting is the answer
Jari
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.