JDE Development, SQL Scripts, Administration & More – Content for advanced Developers, CNCs and SysAdmins
I waited far too long in my career to write this simple function to clean up SQL queries that involve looking up JDE UDC Descriptions. As you may know, JDE has an entire catalog of “User Defined Codes” that are all stored in a single table called F0005. This table has many properties that make …
Purpose Two queries for extracting information from the JDE Data Dictionary. One is used to export an entire JDE Data Dictionary with all of the useful properties by Item. The second is used to search the Data Dictionary for an Item and retrieve a list of all other Items that are fully compatible. It’s very …
How to setup a HTTP Load Balancer for JDE using the open source Apache httpd webserver. Your Apache must have the following core modules enabled: mod_rewrite, mod_headers, mod_proxy, mod_proxy_http, mod_proxy_balancer You may need to adjust the following settings: ServerName ServerAlias DocumentRoot <Directory> (to match DocumentRoot) BalancerMember (list the URL for each of your JDE instances) …
About By default, JDE creates a lot of database table index definitions. When the “Generate Table” command is used in OMW, all of the JDE-defined Indexes are generated along with it. But why does JDE have so many indexes to begin with? The reason for all of those predefined indexes really comes down to design …
Purpose Display all jobs in the JDE Scheduler system in an efficient & easy-to-read format. About Like most of the applications in JDE that were built for system administrators, the JDE Scheduler Application P91300 is pretty awful to use. Critical information is scattered throughout several different screens without one good screen to overview the entire …
Purpose Re-balance the JDE F4229 “Sales As-Of” file based on actual details in the F42119 Sales Detail History file. This should be used to maintain reporting accuracy if you have directly modified Sales Detail History in F42119. About JDE maintains a Sales History Summary in the file F4229 that is used to help increase reporting …
[SQL Server only] Purpose Quickly copy data for 1 or more tables from one database to another. This is useful for performing partial data refreshes between environments. About This query is optimized for speed. For each table: disable all indexes, truncate table, copy data from source, rebuild indexes. Usage Specify table(s) to be refreshed in …