Does anyone have any idea on how to imitate SQL TRIM functionality in Data Request within Orchestrator ?
I have a data request based on a UDC but my input isnt working because of all the spaces within the feild which makes it impossible to get the value i'm looking for.
Help ?!? :P
For the Shop Floor Control context, how would you determine the amount of open work orders per workcenter (Business Unit)?
I am working on a SQL to get a daily report. For now I would guess I would check in F4801 for orders where status <90 and then reference to F31122Z1 where...
To Secure Interactive SQL I can:
- CRTAUTL, add only users that should have STRSQL
- EDTOBJAUT, *PUBLIC *EXCLUDE, Remove any others, Add AUTHL STRSQL
- Seems to block a profile not on the list for STRSQL (not authorized to command)
How do we secure access to iNavigator SQL Scripts (Older Client...
First post on this site. Inherited a OneWorld Xe environment on Microsoft SQL Server. Need to pull in via SQL query from F0006 F0901 F0902. Anyone have this query available to read in balance sheet and P&L data? Basically trying to do an M&A financial roll-up to a new company defined in another ERP.
First time I am really playing with items, costs and prices....
Items mass upload is ok, costs also (via interop).
But what about prices (F4106) I have 4000 items that are waiting to get a price....
Anyone can help me building a sql statement that will fill the F4106 and all...
we have some pdf files stored on SQL server in BLOB field and I need your help with insert this BLOB field to F00165 (Oracle database) via SQL. Program for copying from SQL server to Oracle database is written in C#. Thanks for your help. Petr
Few years ago, i'd a trouble with performance to extract data from large table (like Cardex).
At this time we've used a mix approach with Oracle SQL call directly by the JDE, putting the data to a temporally table to be showing in JDE.
The picture in attach show how this solution works.
We have a SQL Server database that we would like to access from JDE E1. I've created a system DSN to point to the database, created a system user for myself and set up OCM mappings, and can access a table in this database from UTB. If I try to access this same table from DATABROWSER on my...
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...
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...
I am hoping someone has some idea about some intermittent SQL we are seeing being submitted.
The SQL takes the form:
Select * from <table>
we have seen examples where the table is the F0006, F0901, F0004, F0010, F04257W, F0005 - as well as various custom tables.
We see SQL...