1. BookClub

    E9.2 Converting Attachments and Placing Them Back

    Hello! I recently converted all of my attachments from RTF to HTML. I did this by pulling the GDTXFT field from F00165 using SQL and changing it from an image into readable RTF text like so: cast(cast(F00165.GDTXFT as varbinary(max)) as nvarchar(max)) I then changed the RTF as needed to make it...
  2. E9.2 Can a query be build in JDE using 'EXECUTE IMMEDIATE'-like functions?

    Let's say I have a table in JDE from which I can assemble a SELECT-type query, including fields, tables, JOINs, &c. Somehow I can add the logic to build up a string that would look like my sentence. Is there a way to execute that query & retrieve the results into a Fetch-like command for...
  3. SQL Developer amazingly slow

    I'm not sure if I'm doing something wrong, but I simply cannot run any query without having to take a lot of time. I did this: & got this: I've no idea what's going on, or if it's on SQLDeveloper side. But this happens with every query I try to run. Any ideas?
  4. E9.2 Is there an application to test a BSFN?

    Hi, I'm trying to convert the BLOB file of a data structure pulled from F98743. However, using UTL_RAW.CAST_TO_VARCHAR2, HETTORAW & DBMS_LOB.SUBSTR is giving me weird results. I have relied on these functions to convert versions' BLOBs. I'm not sure if I'm doing something wrong. My query is...
  5. E9.2 How to trim in DataRequest ?

    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
  6. 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...
  7. 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...
  8. 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.
  9. 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...
  10. 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
  11. 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...
  12. 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
  13. 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...
  14. 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...
  15. 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...
  16. 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...