Mimic Green-Screen Interactive SQL Without Development Kit

Hey, Ted:

When it comes to doing a quick query to verify data or troubleshooting a problem, the interactive SQL utility (STRSQL) is indispensable. Unfortunately, this requires purchasing the DB2 Query Manager and SQL Development Kit product, so not everyone has it. An alternative to STRSQL is the Operations Navigator SQL utility, which in my opinion is still fairly slow. Never fear, though, if the inability to do a quick SQL from a green screen has got you down. Here's an easy solution.

READ MORE >

Calling a Java Main Method from RPG

Hey, David:

I can successfully call Java programs from RPG using a prototyped call, but I can't get calls to a Java main method to work. My Java program is named GenerateXML, and it accepts a file name. I can run it from a QShell command line, but when I get the following message is it possible to call a main method?

READ MORE >

Reader Feedback and Insights: He Learned Java

Hey, Ted:

This is regarding Steven's and Gary's letters. I have been working with the AS/400 and iSeries for the past 11 years. I am proud that I embraced Java four years ago and got Sun certification. I installed Tomcat 3.X on an iSeries and starting using servlets two years ago. I have also used WebSphere 3.5 and WebFacing to modernize a few applications. I am currently using WebSphere 5.0 studio tools and am porting servlets to 5.0.