|
|||||
|
 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 update the Primary Keys. Actually – Change the primary key values. You can achieve this feat by . . . → Read More: Update Your Primary Keys from JDE For people who have problems with SQL, there’s an easier way of changing backend database values. How about using MS Access where you can directly type in the values, and it gets updated or you can Insert, Update Delete & you can export, import…. and all. Following is the tutorial for setting up MS Access with Oracle Database Backend for JD Edwards EnterpriseOne. . . . → Read More: Change Database values using MS Access (JDE E1 Oracle)  2 comments  EnterpriseOne, Guide  backend, Change, class, Database, default, delete, download, E 9, E9, Edwards, EnterpriseOne, Export, import, Insert, install, JD Edwards, jd edwards enterpriseone, JDE, JDEDATA, LOCAL, MACHINE, MS Access, Oracle, oracle database, SOFTWARE, sql, Standalone, Start, Table, technology, Update, value, Windows, XP A problem with SQL over JDE Data is the way Dates are stored in JD Edwards. JDE stores dates in Julian Format. The following SQL snippet can convert the Julian date into Gregorian Date format or Normal date. . . . → Read More: Convert Julian Date to Gregorian Date (SQL) BSFN – B8000002 (Delete All Rows From Table) does a delete * from tablename. The B8000007 and the B8000002 business functions must be used together to delete all the rows in a table. They will not delete the table specifications or the physical table in the database. B8000007 must be called first to get the environment handle, with the handle only then B8000002 is able to delete all records from the specified table. B8000007 must be called again to free the handle. . . . → Read More: Using BSFN to Delete All Records from a Table One comment EnterpriseOne, Technical alias, architectural design, BSFN, business functions, data dictionary, database side, delete, delete records, delete table, environments, input output, scenarios, sql, table conversion, table query, table space, transaction logs, truncate, variables, work tables |
||||
|
Copyright © 2012 Deepesh M Divakaran - All Rights Reserved |
|||||
Recent Comments