sql

  1. Dynamic Upload?

    Hi guys. I have to make a business function that works similar to B9600430 - Business function for Dynamic Data Selection, but I am not figuring it out. To explain better, I need to execute a SQL clause inside the business function (in this case, an update clause), but I don't have the table...
  2. SQL Summary Views (Virtual Tables) and System Impact

    Someone else has done this - so I'm looking for feedback and insight.... File Structure looks like this: A - Header Table 1 - Detail 1 Table b - Detail of Detail 1 Table We have several Applications and Reports - that summarize the Detail and the 'Detail of Detail' - and due to the...
  3. Strange SQL submitted by JDE

    hi, I am hoping someone has some idea about some intermittent SQL we are seeing being submitted. The SQL takes the form: Select * from <table> where (1=:1) we have seen examples where the table is the F0006, F0901, F0004, F0010, F04257W, F0005 - as well as various custom tables. We see SQL...
Back
Top