This tools is absolutely free (please read the License Agreement in this page before downloading....)

TRIPOD has changed dowloads policy and does not permit donwload of EXE file. The installer versions are now avalaible as ZIP files

		Standard installer You can launch this setup program directly from the link or save it to your hard disk and run it to install As400Expert. Setup.zip, 1234KB, 15 october 2004
		EXE Only This download contains only the zipped EXE files, plus license and readme files as400expert.zip, 984KB, 15 october 2004
		Old version installer If you got trouble running the new version, you could try the old ODBC based version Setup05.zip, 995KB, 03 october 2003

Main features (in no particular order):

• View field definition for physical and logical files
• SQL Query windows with capability to export results in many formats
• View and Edit data in As/400 tables
• Retrieval of key fields and omit/select clause in logical files
• Capability to drop, move, rename or copy files
• Browsing of source physical file members
• Extract Cobol (Also ILE), DDS and SQL source for physical file
• Visual Query Builder
• Remote command to AS/400
• More to come..........

What's NEW

• Preliminary localization support (will not release)
• Help files (will not release)
• Changes to user interface.
• Configurable display format for SQL result grid
• Now the alias and object selection are grouped in a single tree
• Added hints with file description to object tree
• A new toolbar keep track of all open windows. This should make windows switching a lot more easier than using menus.
• New fields list selection (CTRL+F) in Query Window
• Added context menu to SQL editor
• Clicking in a row in the "Logical File" or Extendend Info" tabs will navigate to that object
• Fixed bugs with multiple query window history.
• Fixed bugs with Visual Query Builder
• Visual Query Builder is now MDI child
• You can drag and drop table from main tree to Visual Query Builder
• Print Table Definition in table form now works correctly
• Print capabilities and Copy value for every grid in applications (also on query result, but output may be is really bad)
• Added progressive start position for fields in table definition
• Added a new tab with info for Alias/DDMF files
• fixed bug with field retrieval for Alias File
• Search Object now scan all connected Alias
• Some toolbar icons redesign
• added shortcuts to some common actions
• updated source to last version of third party components
• More robust MDI handling code
• Some cleanup to reduce EXE size

Based on feedback from various users, this software have been tested on this system combinations

	V4R4	V4R5	V5R1	V5R2
Windows 95 /98	OK	OK	OK	??
Windows 2000	OK	??	OK	??
Windows XP	??	OK	OK	OK

If you get it work under other combinations, please let me know at pkc@katamail.com

Screen Shot of running program
This applications, written on Borland Delphi 6 use a lot of freeware and public domain components taken on the web.

• CAWIN32 - interface to Client Access Api (Paul TOTH)
• KBMEMTable - In-memory Dataset (Kim Bo Madsen/Components4Developers)
• MODBC - Good and simple ODBC implementation (Konstantin Savelyev)
  USED UNTIL VERSION 0.5
• DBEXPCA400 - IBM Client Access/400 driver for dbExpress (Peter Sawatzki)
• mxExport - Components for exporting dataset to excel,word,rtf,csv and so on
• ga SQL parser -Advanced SQL statement parser (Gert Kello)
• SynEdit - Multi-line edit control with syntax highlighting

Tools and library used to accelerate development, debug and distribution of this application

• GExperts - Really useful IDE Extensions for Delphi
• Jedi Format - Code Formatter, make code more readable
• Jedi Code library - Awesome utility library, debug functions
• Inno Setup - Excellent Free setup Compiler (Jordan Russel)
• UPX - the Ultimate Packer for eXecutables (Markus F.X.J. Oberhumer & László Molnár)
• FREEVCS - Free Version control software (now known as JEDIVCS) (Thomas Hensle)

TOP

AS400Expert License Agreement

You are free to use AS400Expert. I hope you find it as valuable as I have.
You are free to distribute AS400Expert as long as the entire package, including this notice, remains intact. You must not sell AS400Expert.
If you do distribute AS400Expert then you cannot charge money for doing so and you must let me know of any packages that will include AS400Expert.
I reserve my rights to modify this agreement in the future.
Please report any bugs or issues you find as doing so will make AS400Expert a better tool for everyone.

NO WARRANTY THIS SOFTWARE (AS400Expert) IS LICENSED FREE OF CHARGE AND PROVIDED ON AN "AS IS" BASIS. I HEREBY DISCLAIM ALL WARRANTIES RELATING TO THIS SOFTWARE, WHETHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO ANY IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, AND ALL SUCH WARRANTIES ARE EXPRESSLY AND SPECIFICALLY DISCLAIMED. THE PERSON USING THE SOFTWARE BEARS ALL RISK AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE. NEITHER I OR ANYONE ELSE WHO HAS BEEN INVOLVED IN THE CREATION, PRODUCTION, OR DELIVERY OF THIS SOFTWARE SHALL BE LIABLE FOR ANY SPECIAL, INCIDENTAL, CONSEQUENTIAL, INDIRECT OR SIMILAR DAMAGES DUE TO LOSS OF DATA OR ANY OTHER REASON, EVEN IF I HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. IF YOU DO NOT AGREE THIS LICENSE, SIMPLY DO NOT USE THIS SOFTWARE

Please keep in mind that this application is made as an hobby project in my spare time. I have a very limited amount of time to try and develop this application (I have no AS/400 at home!!)