I'm very excited about the new "local F specs" coming in V6R1 - see: http://www.mcpressonline.com/programming/rpg/v6r1-rpg-enhancements.html Does anyone know a way to simulate this in V5R4 in a SRVPGM procedure? ...
I have been given the task of modernizing my company's I5 based point of sale system. The main push is to create a friendlier interface/better data views without losing business logic. Is there a good Java way of interacting with an interactive (non-command line) I5 program? Something alone the lines of what PHP provides with their 52...
Does anyone know where I can find the Javadoc for the IBM Developer Kit for Java for the iSeries? The information center doesn't seem to have it. All I could find was the Javadoc for iSeries-specific JAAS. Specifically, I'm looking for the Javadoc for writting Java Stored Procedures (mostly the com.ibm.db2.app package). ...
I'm having great difficultly making my DB2 (AS/400) queries case insensitive. For example: SELECT * FROM NameTable WHERE LastName = 'smith' Will return no results, but the following returns 1000's of results: SELECT * FROM NameTable WHERE LastName = 'Smith' I've read of putting SortSequence/SortType into your connection string b...
I am not looking for Infosphere based solution. Is there any API so that I can use it for my development. ...
I coded a monitoring program in RPG that checks if the fax/400 is operational. And now I want this program to check every 15 minutes. Instead of placing a job every 15 minutes in the job scheduler (which would be ugly to manage), I made the program wait between checks using DLYJOB. Now how can I make this program "place itself" in mem...
Hi everyone , I am trying to convert the current date - 2 months into format yyyymmdd and subtract 1900000 from it. Oracle was easy for me SELECT TO_CHAR(ADD_MONTHS(SYSDATE,-2),'YYYYMMDD') - 19000000 FROM DUAL Can some one suggest me the same for AS400 . Thanks in advance. ...