• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

sql

  1. C

    WIP - Open Work Orders per Workcenter/ Sequence

    Hello everybody! 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...
  2. D

    Securing Access to iNavigator SQL Scripts and ACS SQL Scripts

    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...
  3. K

    Financial Statements SQL Query - F0006 F0901 F0902

    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.
  4. S

    Is there someone who already build a SQL query to load base prices in the P4106?

    Hello everybody, 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...
  5. X

    How to insert blob content into F00165 via SQL from SQL server to Oracle database

    Hi 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
  6. Aludoq_GPM

    Hi fellows, tip of how to use a dynamic sql within JDE 8.0 7334

    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. Table...
  7. B

    Top Tables in E1 /DB2

    By chance anyone has a SQL command in handy which pulls out the top 10 or top 30 tables on E1/DB2 I sense that these are the big ones F4211,F0101,F4101,F0911,F4311 But need more data Thanks in advance
  8. DSauve

    Question about accessing SQL Server db using jdbc

    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...
  9. D

    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...
  10. D

    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...
  11. M

    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...
Top