BVSNews - The Newsletter - Issue 22 - December 4, 2014

From the Desk of Brad
Software News
Field Exit Forms - Another Form of Support

A few months ago we created the Field Exit Community Site which is used for BVSTools to better communicate with my customers.  We also invite anyone and everyone to join and share their experiences as well.

For our customers we are finding it a much better medium to share  examples and answer Frequently Asked Questions.  We receive many emails a week and a lot of them are very similar.  So now instead of a quick answer we can take the time to put together an nice example to share with you, the customers.

Feel free to take a look at the forums.  If you're so inclined, also feel free to sign up and share your experiences with our software or the IBM i in general.  

Also, please keep an eye on the BVSTools Announcement forum for news about new products and updates.

SQL for the Rest of Us

IBM i tool builder Bob Cozzi has developed a Command Entry-based SQL query tool for IBM i.

"Query File SQL" allow users to run SQL statements from within CL and Command Entry. This includes an automatic reporting tool that utilizes the SQL SELECT statement.

By enabling SQL SELECT within CL and Command Entry, Cozzi has unlocked the full power of SQL to IBM i users. You can now build reports/listing, PDF, CSV, or outfiiles using the SELECT statement.

Query File SQL is available for a trial download at
G4G Adds Google Drive Functionality!

The latest version of GreenTools for Google Apps (G4G) now contains a new addon for Google Drive (G4GGDRV).

As of this offering you are able to upload files to Google Drive using a command or ILE functions.  You also are able to retrieve a list of files on your Google Drive.

An example of the command to upload a file to your Google Drive would look something like this:

G4GUPLOAD ID( STMF('/tmp/') 
TOFLR('/MyPath/AS400 Stuff/Backups')
You can see a full example of how we personally use this new feature to backup our IBM i (AS/400, iSeries) to Google Drive.

See the G4G  documentation for more information.

JSON Parser Now Available from BVSTools

Because a lot of our applications now deal with the "cloud" and Web Services we needed to be able to parse JSON data.  

We created our own internal processes for this, and customers have been asking for it as well, so we decided to make it available to the public.

The product is named JSONTOOL and can be downloaded from this link.

Examples of using JSONTOOL can be found in this Field Exit post.

If you would no longer wish to receive a newsletter from, simply reply to this email with the word REMOVE in the body.

Bradley V. Stone

Copyright 1995-2014 BVS/Tools, Inc.