Three IBM i Java applications - free open source available on the address
https://github.com/vzupka <
https://github.com/vzupka>.
- IBM i Programming Tool
- IBM i SQL Scripts
- IBM i SQL Update Files
IBM i Programming Tool:
This project is not to be installed, it is ready to use as a Java application in the directory of the project. The application requires Java SE 8 installed in a PC.
User documentation can be found in the subdirectory "helpfiles" and it is also accessible under the menu Help in the running application.
This application replaces some functions of the System i Navigator, which ceased to work in Windows 10, especially transfer of files between IBM i and PC, displaying and editing of files and the like. In addition, the application enables compiling source members or stream files and finding errors from the compilation listing.
When editing source files, hihglighting of blocks in diffrent languages (e.g. if - endif, dow - enddo, etc. in RPG) can be set on or off.
When compiling, you can select the source type (e.g. RPGLE or RPG), select compile command (e.g. CRTBNDRPG, CRTRPGMOD), set the correct library list, and other options. You can observe the result of the compilation in the spooled file.
Application programs are written in Java and require version Java SE 8. They cooperate with classes in IBM Toolbox for Java (or JTOpen). The classes require "host servers" running in IBM i and profile QUSER enabled.
The application has been created and tested in systems macOS and Windows 10. Remote connection to the system IBM i, version 7.3 has been used.
Start the application by double click on the IBMiProgTool.jar file.
IBM i SQL Scripts:
This project is not to be installed, it is ready to use as a Java application in the directory of the project. The application requires Java SE 8 installed in a PC.
User documentation can be found in the subdirectory "documents".
Creation of this application was motivated by the fact that the popular utility Query/400 (later called Query for i) is unable to display and print all characters coded in character sets UCS-2 (CCSID 13488), UTF-16 (CCSID 1200), or UTF-8 (CCSID 1208). This application enables creating, saving and running scripts of SQL statements for the IBM DB2 for i as well as flexible formatting and printing of the results.
Script is defined here as a text of SQL statements written in a text file with the suffix .sql. One or more SQL statements delimited by a semicolon can be written in the script. The SQL statements may be of any kind (DDL or DML) and can contain parameters designated by question marks. Most of the time the script will be a query, i. e. a single SELECT statement. That means that the creator of the script must know the SQL language at least at the level of the SELECT statement. Scripts are usually amended by specially structured comment lines which enable flexible formatting of the script result when displayed on the screen or printed on paper.
Programs are written in Java language and require version Java SE 8 or higher. They cooperate with IBM i Toolbox for Java (or JTOpen framework). The programs were created and tested Mac OS X, macOS, Windows 7, Windows 10 with remote Internet connection to system IBM i.
Start the application by double click on either Q_Menu.jar or Q_MenuUser.jar file.
IBM i SQL Update Files:
This project is not to be installed, it is ready to use as a Java application in the directory of the project. The application requires Java SE 8 installed in a PC.
User documentation can be found in the subdirectory "documents".
Motivation for this application was the fact that the popular utility DFU (Data File Utility) is unable to display or print all Unicode characters, especially UTF-8, UTF-16 or UCS-2. The application serves to entering and updating data in database files. It works with physical and logical files. Only one file can be processed at a time.
Programs are written in Java language and require version Java SE 8 or higher. They cooperate with programs from package IBM i Toolbox for Java (or JTOpen). The programs were created in the OS X operating system and tested in systems OS X 10.9 Mavericks, 10.10 Yosemite, 10.11 El Capitan and Windows 7 with remote internet connection to the IBM i, version 7.1.
The application is launched by double click on the shortcut or the original of the file IBMiSqlUpdate.jar.
Vladimir Zupka (Vladimír Župka).
midrange.com
