Does that title sound funny? Can you update your Primary Keys of a record in a table too? Ofcourse you can, SQL does allow it. But does that work in an ERP? Yes ERP’s are supposed to keep their data integrity well, and secure it too. But in JD Edwards you have an option to [...] . . . → Read More: Update a Table’s Primary Keys from JDE
I created a custom table. When creating a new table, when is it required to Generate the Table? Also under what circumstances is it necessary to run the Generate Header File option? A report using the custom table seems able to write to a table only when Generate Header File is done. Solution When creating [...] . . . → Read More: Information on Table Design Aid
There are many requirements where data from One table needs to be copied to another. There are also various ways available. But there are some APIs which provide this functionality in very optimum way. e.g. JDEDM_LoadDSfromTableRecord, JDEDM_LoadTableRecordfromDS. Take example where one table contains 200 fields and due to interoperability one more table (Z-table) needs to [...] . . . → Read More: Copy data from one table to another with the help of APIs
In OneWorld XE/8.0 days, we used to have an application – P80010 – Table Definition Browser Application. This application was of great help, as it showed the database fields in the Table, its indexes, the DD item name, description, the Data type of the field etc. You can do the same in the Newer versions of EnterpriseOne too, with a very simple app as shown in the article. . . . → Read More: Writing a P80010 Table Definition Browser App.