Command line tool to query an AS/400 server and return results as JSON. It uses the JTOpen Java library from IBM.
It was created to extract data from an AS/400 for consumption into a web application built on CouchDB.
Build is automated using Gradle.
To configure the eclipse project, launch:
gradle eclipse
and import the existing project in Eclipse.
Use gradle distTar to build a distributable package. Use gradle installApp to install into build/install/.
Create a local.properties file in the working directory. Look a Property.java for an enumeration of all properties.
Put your queries in a queries folder in the working directory: a query named onequery is found into queries/onequery.sql.
Each query is parsed with MVEL as an MVEL template. The parameters are taken from the command line as parameter=value pairs.
To run the query onequery with parameters a=b and c=d use:
./bin/As400Querier onequery a=b c=d