Utility free per AS/400
- Dettagli
- Categoria: Faq AS400
- Pubblicato Venerdì, 29 Luglio 2011 09:36
- Scritto da Super User
- Visite: 34708
| DBViewer Plugin for Eclipse | Eclipse plugin as a database front end. Connects with various databases via JDBC driver. | http://www.ne.jp/asahi/zigen/home/plugin/dbviewer/about_en.html | web development |
| Scott Klement's HTTP API | Library of RPG IV functions for integrating HTTP into your IBM i software. | http://www.scottklement.com/httpapi | web development |
| Easy400.net Suite of Tools | Tools include TCP/IP configuration guide; RPG CGI program development toolset; Cobol CGI program development toolset; JavaScript tutorial; WRKVLDL validation list maintenance utility; HTTP powered by Apache; utilities for your website; utility to translate message descriptions used in DDS; utilities to handle spreadsheets on the i; and many more miscellaneous tools. | http://www.easy400.net/easy400p/main.html | web development |
| Craig Rutledge - Open Source iSeries Tools (JCRCMDS) | Set of API-based utilities for IBM i programmers. The source utilities include quick information-retrieval tools you use to write, maintain, and provide analysis of your programs; conversion tools for bringing legacy code up to modern standards; code-generation tools that can save many hours of programming time; file and object tools; analysis helpers; job and spool file finders; and quick, easy access to many other necessary functions. Also provided are Data Queue, Netf, and XML generation tools. | http://www.jcrcmds.com | application development |
| Uzaemon's CRTCSVF | Converts DB2 for i to CSV format PC stream file. Generates small and highly compatible CSV file. [Editor's note: Scroll down Uzaemon's page to see the English version, as well as many other i-related tools.] | http://homepage1.nifty.com/uzaemon | database |
| Eclipse SQL Explorer (RCP/Plugin) | Eclipse SQL Client for database querying/browsing any JDBC-compliant database. Supports plugins with specialized functionality for individual databases (Oracle, DB2, and MySQL) and can be extended to include specialized support for other databases. | http://sourceforge.net/projects/eclipsesql | database |
| MANTIS/400 | IBM i–specific adaptation of Bug Tracker MANTIS Help Desk. Runs native on the i, using native PHP. | http://mantis400.com | application development |
| Aaron Bartell's RPGUI | OpenRPG User Interface (OpenRPGUI) project. Goal is to develop a collection of API's allowing RPG programmers to easily talk to various user interfaces. First attempt is talking with ExtJS. | http://www.mowyourlawn.com/rpgui.html | RPG |
| Paul Touhy's RPGLEDOC | Document procedure and program calls. RPGLEDOC comes in two parts: a set of programs to generate the RPGLEDOC documentation and examples of how you might view the contents of the documentation using either CGIDEV2 or PHP. | http://www.systemideveloper.com/downloadRPGLEDOC.html | RPG |
| Scott Klement's FTP API | Library of RPG IV functions for integrating FTP into your IBM i software. | http://www.scottklement.com/ftpapi/ | RPG |
| Scott Klement's HSSFR4 Service Program | Prototypes, constants, and helper subprocedures (in RPG) for working with POI. Scott's website contains downloads for HSSFR4 for POI versions 3.0-3.1 (without XLSX support) and 3.6 (with XLSX support). It also contains links to all articles Scott has written about POI--some of which have older versions of the code. Scott advises you to use the code from his website because it has the latest version with the latest bug fixes. | http://www.scottklement.com/poi | RPG |
| TN5250J | 5250 terminal emulator for IBM i written in Java, with some cool extra features, such as tabbed screens. | http://tn5250j.sourceforge.net/index.html | client connectivity |
| SQLCreator | SQL query tool built to interact with many databases, including DB2, Oracle, SQL Server, Cache, MySQL, PostgreSQL, SAPDB, Pointbase, and HSQLDB. Features include multiple database support; full database tree view and searching; SQL script execution; advanced SQL editor with syntax highlighting; code completion and keyword typo highlighting; relationship map; history of executed SQL statements; connection wizard; connection alerts; RTF clipboard support; user-defined date formats; ability to view image in database; data export; and automatic query creation. | http://download.cnet.com/SQLCreator/3000-10254_4-10300599.html | database |
| Spiceworks Help Desk | Not strictly i related, but reader who submitted this tool for our list says his shop uses it for job tracking (create a preformatted email to create and close a ticket every time a task is completed). | http://www.spiceworks.com/free-help-desk-software | workplace efficiency |
| MindTouch Core | Not strictly i related, but reader who submitted this tool for our list says his shop uses it for documentation. Download the open-source version by going MindTouch downloads page and scrolling to the section for MindTouch Core v10. | http://www.mindtouch.com/downloads | documentation |
| Scott Klement's JFREECHTR4 | Utility that, through RPG's ability to call Java methods, can be used for creating charts from RPG programs. Scott Klement's System iNetwork article shows how to use the open-source JFreeChart from an RPG program and offers the JFREECHTR4 service program as well as a sample program that demonstrates how to use the utility. | http://systeminetwork.com/article/create-graphs-and-charts-jfreechart | RPG |
| Bryan Dietz's PHP WRKSPLF | PHP Work with Spooled Files script with display, email, and PDF support. | http://home.roadrunner.com/~jbmmdietz/php-wrksplf.html | PHP |
| Olivier Plathey's FPDF | PHP class that lets you generate PDF files with pure PHP, i.e., without using the PDFlib library. FPDF's main features: choice of measure unit, page format and margins; page header and footer management; automatic page break; automatic line break and text justification; image support (JPEG, PNG and GIF); colors; links; TrueType, Type1, and encoding support. | http://www.fpdf.org | PHP |
| TN5250 | Emulates a 5250 terminal or printer over Telnet, for connecting to IBM i. Runs on any UNIX or Windows system. | http://tn5250.sourceforge.net | client connectivity |
| Apache Subversion | Open-source version-control system. | http://subversion.apache.org | application development |
| Subclipse | Eclipse Team Provider plug-in providing support for Subversion within the Eclipse IDE. | http://subclipse.tigris.org | application development |
| SoftLanding Systems' RSE Extensions | WDSC 6.0–compatible plugin that includes spooled file output, IBM i messages, and editing perspective utilities. | http://www.softlanding.com/Solutions/WebSphere/RSE-Plugins.aspx | application development |
| SQuirreL SQL Client | Open-source Java SQL Client program for any JDBC-compliant database. Lets you view the structure of a JDBC-compliant database, browse the data in tables, issue SQL commands, etc. | http://squirrel-sql.sourceforge.net | database |
| openDBcopy | Universal database utility to migrate data from and to any database given a JDBC driver. | http://opendbcopy.sourceforge.net | database |
| Scott Klement's Port of Expat for IBM i | XML parser for IBM i. The Expat XML parser is an open-source XML stream parser written in C. Scott Klement has done of the work of making it compile and run on the IBM i. | http://www.scottklement.com/expat | application development |
| GNU C Compiler (for use in PASE) | Compile AIX C source within PASE to compile various open-source utilities. Scott Klement's System iNetwork article explains how to obtain the compiler and what you need to do to run it. | http://systeminetwork.com/article/use-gnu-c-compiler-pase | application development |
| Perl (for use in PASE) | The Comprehensive Perl Archive Network (CPAN) offers many ports of Perl. For the PASE version, scroll a little more than halfway down the page to the "IBM OS/400" section. | http://www.cpan.org/ports | Perl |
| Scott Klement's 7-Zip | Software to zip, encrypt, tar, compress, etc., in a lot of different formats. Runs under PASE on IBM i. | http://www.scottklement.com/p7zip/ | systems management |
| Emacs | Source editor for working with files in the IFS. (Also available at http://www.xemacs.org/index.html.) |
http://www.gnu.org/software/emacs |
systems management |
| ConTEXT | Source editor for working with files in the IFS. | http://www.contexteditor.org | systems management |
| iSeries Python | Python IBM i port provides a path to rapid object-oriented development. There are many things RPG does better than Python, and conversely many things that take minutes in Python, where they would take a good RPG coder several days. | http://www.iseriespython.com | Python |
| Zend Server Community Edition for IBM i | PHP application stack for IBM i. You can use it in development, testing, and production. | http://www.zend.com/en/products/server-ce/ce-for-ibm-i | PHP |
| Dojo Toolkit | JavaScript tools for web development. Animations, event handling, and a wealth of other utilities are instantly available. | http://dojotoolkit.org | web development |
| Dumpster | Utility that dumps the internals of IBM i spooled files and print resources. | http://www.gumbo.com/Licpgm/Dumpster.html | systems management |
| Bryan Dietz's WRKODBCJOB | Work with the QZDASOINIT jobs. Shows Servicing User/Open Files/IP Address. | http://home.roadrunner.com/~jbmmdietz/wrkodbcjob.html | systems management |
| Adminer | Simple-to-install alternative to PHPMyAdmin. | http://www.adminer.org | PHP |
| Xataface | PHP framework that workswell with MySQL and the DB2 storage engine. | http://xataface.com | PHP |
| FileZilla | Cross-platform FTP, FTPS, and SFTP client with many useful features and an intuitive GUI. | http://filezilla-project.org | file transfer |
| CGIDEV2 | Tool that lets you leverage your RPG skills for web development. Provides a technique, based on a service program, of hiding CGI complexity from your RPG code. In addition, it lets you define your web pages external to your programs. Any script language understood by a web browser (e.g., HTML, XML, WML, or JavaScript) can be used to define your external web pages. | http://www-03.ibm.com/systems/services/labservices/library | RPG |
| Dieter Bender's AppServer4RPG | Utility that provides a way for an RPG program to communicate with Java in a fashion that is different from using RPG's Object data type. | http://sourceforge.net/projects/appserver4rpg | RPG |
| Thomas Raddatz's Log4RPG | Logger for RPG. The development of Log4rpg was inspired by the great Log4j logger used for Java development. It supports a logger hierarchy as well as pluggable layouts and appenders. | http://www.tools400.de/English/Freeware/Service_Programs/Log4rpg/log4rpg.html | RPG |
| Mihael Schmidt's RPG Next Gen | Eclipse-based RPG development environment. | http://rpgnextgen.com | RPG |
| ChangefIT | Change management system for IBM i. | http://www.ecofitonline.com | application development |
| XrefIT | Cross reference system for IBM i. Displays object/program references; provides source view directly from within XRefITTM; fully integrated into ChangefITTM (i.e., task creation and source check-out); selected Libraries can be excluded for database (re)build. | http://www.ecofitonline.com | application development |
| SNDM | Sends Internet mail from IBM i command line. | http://homepage1.nifty.com/uzaemon/iptu/CD-ROM.html | |
| PmWiki (Running under Zend stack) | A wiki you can use for technical references and explaining "how stuff works." | http://www.pmwiki.org/wiki/PmWiki/Download | documentation |
| Scott Klement's sql | Enhanced version of the db2 qshell command. | http://systeminetwork.com/article/improved-db2-command-qshell | database |
| Aaron Bartell's RPGMail | RPG service program that interfaces with the JavaMail API's from Sun. The interfaces are straightforward and restriction free. You can send as many attachments as you like or send to as many people as you wish. | http://www.mowyourlawn.com/html/RPGMail.php | RPG |
| Convert to PDF/HTML | Convertspooled files to PDF or HTML to display on your intranet. Instead of creating inter-office packets of daily reports, email the reports to each user automatically every end-of-day in both PDF and HTML formats. | http://www.code400.com/cvt2pdf.php | web development |
| Sencha Ext JS | Cross-browser JavaScript library for building rich internet applications. Ext JS is dual-licensed. You can either pay for it or use it under the GPL. The GPL allows you to use/distribute it for free as long as your product is also distributed as open source under the GPL or a compatible license. | http://www.sencha.com/products/js | web development |
| CNX Valence Free Community Developer License | Web application framework for IBM i. Prior to production use, you must either: Contribute your apps for relicensing to the Valence community, or support development by upgrading to a Professional Developer License. | http://www.cnxcorp.com/store | web development |
| Scott Klement's JDBCR4 | Utility for calling JDBC from RPG. | http://systeminetwork.com/article/jdbc-rpg-multiple-result-sets | RPG |
| Renaissance | Open-source framework for IBM i application development. | http://www.renaissanceframework.com | application development |
| WinSCP | Runs on PC and connects to IBM i. You can FTP files easily to the IFS, and it handles the translation. | http://winscp.net/eng/index.php | file transfer |
| IUnit | Can help your systems run more smoothly by using unit testing—or the testing of an application's individual components—to verify whether programs work as expected. [Editor's note: See Wim Jongman's article about IUnit in the November 2010 System iNEWS: http://systeminetwork.com/article/put-unit-testing-work-your-ibm-i-programs.] | http://www.remainsoftware.com/iunit | application development |
| LSTFFD | List File Field Description lists the file field descriptions on the screen, with an option to print. LSTFFD lists the file name, library, file type (physical, logical, etc.), whether or not it is uniquely keyed, field name, field description, field type, field length, whether or not it is a key field, and the key sequence. Has an option to display database relations and triggers attached to the file, and will also diplay the data using Query/400 with or without selection. | http://bvstools.com/lstffd.html | database |
| SCNMSGF | Scan Message File lets you search any message file for a message identifier using any text description from the message. | http://www.bvstools.com/scnmsgf.html | systems management |
| F.R.O.G | SQL interface to DB2. | http://www.innovativesys.net | database |
| Spool Converter Standard Version | Enables. *SCS spool conversion to PDF (HTML and TXT too). Previously commercial, the SpoolFactory free tools have become free and are available to download, although it is necessary to request a key (completely free) to activate the license. | http://www.spoolfactory.com/SpoolConverterStandard_En.html | document management |
| Spool Excel | *SCS spool conversion to Excel (XML for Excel 2003). An IBM i-command–based tool. Previously commercial, this SpoolFactory tool is free and available to download, although it is necessary to request a key (completely free) to activate the license. | http://www.spoolfactory.com/SpoolExcel_En.html | document management |
| Spool Splitter Pro | *SCS spool splitting based on conditions or based on groups of pages. An IBM i-command–based tool. Previously commercial, this SpoolFactory tool is free and available to download, although it is necessary to request a key (completely free) to activate the license. | http://www.spoolfactory.com/SpoolSplitterPro_En.html | systems management |
| Spool Chart | Brand new (experimental) tool for chart generation based on content of IBM i reports. Previously commercial, this SpoolFactory tool is free and available to download, although it is necessary to request a key (completely free) to activate the license. | http://www.spoolfactory.com/SpoolChart_En.html | charts |
| DB2iToMySQL | Web-based utility that generates MySQL CREATE TABLE statements from physical file objects on your IBM i. The IBMDB2I engine results in the MySQL table also existing as a Physical File, so you can access it with PHP as MySQL or with RPG as a regular Physical file. You can then paste it into a text file to run it with the mysql command, or import it into PHPMyAdmin. You will have MySQL tables that are the equivalent of IBM i physical files. | http://www.bcdsoftware.com/db2itomysql | database |
| ZipSeries | Tool for saving and restoring on IBM i. It can zip an object, program, or entire library directly to your PC for distribution—without installing anything on your IBM i. | http://www.zipseries.com | backup |
| IceBreak Community Edition | Freeware for all developers who want to build and deploy web applications using RPG and Cobol and other technologies such as SQL, XHTML, XML, and AJAX. | http://www.icebreak-community.com | web development |
| Surveyor/400 | Database tool and file editor for IBM i (free with single-user license). View/upate database files, transfer data to PC in a multitude of formats (including XML), import data from PC, convert IBM i printer files to PDF, and generate SQL CREATE FILE statements from DDS. | http://www.linomasoftware.com/products/surveyor | database |
| Base Runtime Support of CL for Files | On the website that offers this tool, the commands listed under "Using only Run-time commands" are free and provide for file IO from CL to database, display, and printer files. | http://www.powercl.com/clf/clfcommands | CL |
| Base Option of eXtreme CL | The Edit Decimal Variable (EDTDECVXCL) command is provided in the no-charge base option. EDTDECVXCL allows a CL developer to apply edit words and edit codes to decimal variables. | http://www.powercl.com/xcl/xclcommands | CL |
| Carsten Flensburg's CVTDSPFCNS | Convert Display File Constants converts all display file source constants to message descriptions. This procedure lets you externalize the display file texts, subsequently enabling you to translate the texts and thereby support different languages in your application screens. | http://systeminetwork.com/article/apis-example-user-index-apis-part-two | application development |
| Carsten Flensburg's WRKCMDLOG | Work with Command Log lets you work with a list of previously entered commands, retrieved from the current job's job log. All request messages found in the job log will be retrieved. | http://systeminetwork.com/article/apis-example-user-interface-manager-apis | systems management |
| Carsten Flensburg's WRKJOBQJOB | Work with Job Queue Jobs lets you work with all jobs submitted through the specified job queue and not yet completed. This implies that only jobs currently on the specified job queue, or on that have been on that job queue and are currently active, will be included in the list of jobs to work with. | http://systeminetwork.com/article/apis-example-uim-work-management-apis-part-3 | systems management |
| Carsten Flensburg's DSPDTAQE | Display Data Queue Entries lets you display a list of all entries currently in the specified data queue. The information includes key data for keyed data queues, provided that either the sequence parameter special value *BYKEY or *DTAQTYP is specified. | http://systeminetwork.com/article/apis-example-data-queue-apis-and-cl-commands-part-3 | RPG |
| Carsten Flensburg's WRKDTAQ2 | Work with Data Queues lets you list and manage the selected data queue. | http://systeminetwork.com/article/apis-example-data-queue-apis-and-cl-commands-part-4 | RPG |
| Carsten Flensburg's WRKDBF | Work with Data Base Files lets you list and manage the selected database files. | http://systeminetwork.com/article/apis-example-working-database-files-fields-and-more | database |
| Carsten Flensburg's DSPFFD2 | Display File Field Description lets you display a list of the fields in the specified database file. | http://systeminetwork.com/article/apis-example-working-database-files-fields-and-more | database |
| Carsten Flensburg's WRKSPGREF | Work with Service Program References lists all programs and service programs meeting the specified selection criteria and referencing the specified service program. | http://systeminetwork.com/article/apis-example-identifying-and-working-service-program-references | systems management |
| Carsten Flensburg's WRKSVRJOB | Work with Server Jobs lets you work with a list of server jobs on the system. The list is generated based on the specified server name as well as a combination of job name, user name, and job status. | http://systeminetwork.com/article/apis-example-use-work-management-api-list-server-jobs | systems management |
| Carsten Flensburg's FNDMSGD | Find Message Description presents a list of all message descriptions in the specified message file that meet the specified selection criteria in the form of a generic message ID and a text string to be found in either the message text, the second level message text, or both. | http://systeminetwork.com/article/apis-example-finding-ibm-i-message-descriptions | systems management |
| Carsten Flensburg's WRKVLDLE | Work with Validation List Entries lets you work with a list of all the validation list entries contained in the specified validation list object. | http://systeminetwork.com/article/apis-example-listing-and-working-validation-list-entries | systems management |
| Carsten Flensburg's WRKSPLFAUD | Work with Spooled File Audit lets you retrieve and select all or a subset of the Spooled file and Printer output journal entries found in the system audit journal QAUDJRN. | http://systeminetwork.com/article/apis-example-journal-apis-solving-spooled-files-mysteries | systems management |
| Carsten Flensburg's WRKLANPRT | Work with LAN Printers lets you work with a list of all or specific LAN printers configured on the system. | http://systeminetwork.com/article/apis-example-work-lan-printers-command | printing |
| Carsten Flensburg's WRKPRFSECA | Work with Profile Security Attributes displays or prints a list of user profiles that meet the specified selection criteria. The available selection criteria all relate to user profile security and authorization. | http://systeminetwork.com/article/get-thousands-different-user-profile-reports-wrkprfseca | security |
| Carsten Flensburg's RUNJOBCMD | The Run Job Command lets you run a command in another job, including batch jobs. If the command generates completion, exception, or any other types of messages, these will be visible in the job log of the job where the command is run. | http://systeminetwork.com/article/sending-commands-another-job-revisited-i5os-v5r4 | systems management |
| Carsten Flensburg's WRKJOBS | Work with Jobs lets you work with a list of jobs based on a combination of job name, user name, job status, and job type. | http://systeminetwork.com/article/wrkjob-enhanced-run-commands-other-jobs | systems management |
| Carsten Flensburg's CHKPTFSTS | Check PTF Status command locates all PTFs having the specified current status.All installed products are searched unless you specify the optional Select product (SELECT) parameter. | http://systeminetwork.com/article/chkptfsts-check-ptf-status-enhanced-performance | systems management |
| Carsten Flensburg's WRKSBSE | Work with Subsystem Entries lets you work with the routing entries, autostart job entries, prestart job entries, job queue entries of each of the list subsystem descriptions. | http://systeminetwork.com/article/carstens-corner-new-subsystem-entry-commands-part-4 | systems management |
| Carsten Flensburg's WRKRMTOUTQ | Work with Remote Output Queues lets you work with a list of all or a subset of remote output queues configured on the system.A remote output queue is, in the context of this command, confined to output queues configured with a connection type of TCP/IP network. | http://systeminetwork.com/article/carstens-corner-new-work-remote-output-queue-command | systems management |
| Carsten Flensburg's WRKCMDSEC | Work with Command Security lets you create a list of commands, including critical information about the commands, in an audit and security context. | http://systeminetwork.com/article/carstens-corner-new-command-work-command-securitywrkcmdsec | security |
| Dan Darnell's PGP for i Tool | Brings PGP encryption and decryption to the IBM i with a command-line interface. [Editor's Note: See Dan Darnell's explanatory article, as well as download the tool, in the System iNEWS November 2007 article linked at right.] | http://systeminetwork.com/article/pretty-simple-pretty-good-privacy | security |
| DeskfIT Service Desk System | Service Desk software suite built to complement ChangefIT from the non-IT user point of view. Users can create and track progress of their service request(s) realtime. [Editor's Note: ChangefIT is also listed in this spreadsheet. Both tools are available at the same URL.] | http://www.ecofitonline.com | systems management |
| maxView Lite | maxView Lite lets you monitor your IBM i general system statistics in realtime via a browser-based interface. Use your iPhone or Blackberry to instantly see your system status--anywhere, anytime. | http://www.maxava.com/products/monitoring-tools/ | systems management |
