Deep Thoughts with Richard Schoen

I created the PHPRUN command a few months back when I started learning PHP. 

I always like to see what else a scripting language is capable of when I am testing. 

I figured since we use QSH and PASE all over the board, then PHP should be able to participate in this mix. 

Feel free to download and use the PHPRUN command.  Source code is included for the CL script if you want to modify and enhance it. 

There’s also a README source member in the source file RJSPHP/SOURCE

Basically the PHPRUN command will run any PHP script with parameters and will allow you to send output back to the regular 400 job by placing STDOUT into a physical *OUTFILE and rolling through the file and processing results. This is a great way to intermix, RPG, CL and PHP. The command also bubbles back the PHP return codes to a data area so you can monitor for a successful script completion from a CL or RPG program. 

PHPRUN Command Download  – Contains RJS FTP Library Installer for RJSPHP library http://downloads.rjssoftware.com/files/commonclasses/rjsphp/rjsphp.exe

REQUEST: If you make any changes or tweaks to the scripts or add any additional functionality, please send them to me so I can incorporate them into the library. I already have several ideas for how to make this more useful, but let’s have some outside input. 

Have fun and send your feedback to me via email.  richard@rjssoftware.com

Having the most precise data in the world doesn’t matter if you can’t get it into the hands of those who need it. That’s why we created RPG2SQL integrator.

Imagine gaining more insight into your company’s performance by generating multi-page spreadsheet reports that contain month-end numbers with negative numbers highlighted in red.  Think of how much more informed you’d be if you could create daily sales summary spreadsheets that were automatically updated each night.  RPG2SQL Integrator accomplishes this by automatically updating MS Excel spreadsheets with data directly pulled from RPG programs.

RJS Software’s RPG2SQL Integrator provides the ability to read and write to SQL Server, Oracle, MySQL and other database formats.  The recently added integration with MS Excel helps your business get even more functionality from an already robust product.

RPG2SQL reads and writes directly to Excel spreadsheets so no data gets missed, and you have the full power of Excel available to your RPG application developers. Contact RJS to schedule a web demo and learn more about the ROI you can achieve by better communicating your key business indicators via RPG2SQL and MS Excel.

When companies experience growth and generate more revenue, they also tend to generate more paperwork. As the number of invoices, proofs of delivery, shop floor data packets, shipping documents and insurance policies generated increases, so does the amount of time it takes to assemble those documents and send them to your customers.

Imagine completing an order and having all the required shipping and certification documentation, such as Material Safety Data Sheets, automatically printed along with a packing list to hand to the truck driver at your loading dock. Or, perhaps, you’re an insurance company that wants to assemble related policy documents into a single document that can be printed and archived without scanning.

RJS Software’s Document Assembly solution provides this functionality and delivers instant ROI by allowing your employees to spend more time helping customers instead of manually assembling packets of paper.

Contact us to see how we can help you achieve fast ROI.

Well I am not personally a huge Twitter fan, but my wife told me that I could use Twitter as sort of a mini-blog where I could share short (140 char) items with anyone who would be crazy enough to follow me.  I don’t plan to use it as a play-by-play site like some folks do, but I will post short web URL link tips and techniques related to Windows, iSeries and other business items I find to be relevent. Besides who would really want to know what I’m doing all the time. Here’s my Twitter link http://www.twitter.com/richardschoen

I just returned from the COMMON 2009 conference in Reno and the main thing I learned from listening to IBM at the opening conference is that they no longer consider the iSeries more than just an OS running on a Power systems box. Why is this a significant event ? Well, we’re starting to see a small although very real shift from some customers towards selecting ERP and other business systems that run on platforms that don’t include OS/400.

While RJS will always remain committed to the native iSeries platform we want to make sure our customers know that even if they do select another platform, our document imaging, electronic forms, workflow and report delivery products are all very capable products running in an iSeries or Multiplatform environment as well. Hopefully for those of you committed to the iSeries, you will be on the platform a long time, but if Windows or some other platform is in your future, feel free to give us a call and we can discuss how your information delivery investment is protected by continuing to choose RJS as your valued information delivery provider.