E1 Tips The Tips & Tricks of a CNC Administrator on Oracle JDEdwards EnterpriseOne

Posts Tagged ‘system i’

Journaling a Physical File on IBM iSeries Using STRJRNPF

We have a system that needs to interface directly with some EnterpriseOne Files.  This system is written in Java and seems to be very difficult to change any JDBC settings to not use commitment control. Anyway, to get around this issue, we started journaling the physical file that the JDBC command was trying to update ...

EnterpriseOne Tools Release Upgrade From 8.96 to 8.97 Rough Outline

IBM iSeries/AS400/System i Backup libraries and IFS directories Register Pristine Environment in Server Manager Create Server Manager Server Group for Pristine Upgrade Pristine Web Server Create IBM WebSphere Application Server in Server Manager Create IBM HTTP Server in Server Manager General HTML landing page: update links and info Change DNS entries Copy the code used ...

Clean Up Your Web-Only Versions

We have been having some issues lately where users create web-only versions and expect to use them after a full package has been built and deployed. We have processes in place for them to submit new versions to our development teams, but sometimes things don’t happen the way they are designed. Anyway, I was doing ...

EnterpriseOne 8.97 Install Host Table Hic-Up

While installing EnterpriseOne 8.97 on one of our instances, we ran across an issue that was pretty puzzling to both us and Oracle’s Global Support Services group. We had successfully installed both the Server Manager Console and the Enterprise Server (System i, iSeries, AS/400) Management Agent.  When everything is working correctly, the Enterprise Server Management ...

CNC Certification and Consulting

06.27.2008 · Posted in EnterpriseOne - General

If you pay attention to threads on JDEList, every once in a while someone will inquire about the availability of CNC Certification.  Usually, these inquiries are met with the an answer generally like: No, there are no "official" certifications. The latest inquiry was from Spider006.  Essentially, he just wanted to know what some good "supporting" ...

The IBM iSeries (System i) JDK Juggle

While installing the Oracle Server Manager agent, we learned some interesting little Java tricks on the IBM iSeries.  They probably work on all platforms, but I don’t know for sure and I’m not going to take the time to test.  Also, these tips are for OS400 V5R4. How do you know which version of JDK ...

E1 Admins Need To Know Everything About Everything

I admit that I am a "Jack of all trades, master of none".  Which can be a good thing as in the second paragraph of the Wikipedia entry. A Jack of all trades may also be a master of integration, as the individual knows enough from many learned trades and skills to be able to ...

Escape From SQL

05.12.2008 · Posted in EnterpriseOne - SQLs

The other day, one of my coworkers was presented a question from our development team: How can I use SQL to look for a "%" in a column? Well, the first guess is to use something like: SELECT * FROM MYLIB/MYFILE WHERE MYCOL LIKE '%%%' or SELECT * FROM MYLIB/MYFILE WHERE MYCOL LIKE '%%%' Well, ...