Comparison of Database Capabilities
| Feature / Function |
IBM i Access for Windows (V5R4) |
IBM i Access for Web (V5R4) |
| ODBC Driver (32-bit, 64-bit) |
Yes |
No |
| OLE DB Provider (32-bit, 64-bit) |
Yes |
No |
| Add-ins for Visual Basic |
Yes |
No |
| .NET Provider (32-bit, 64-bit) |
Yes |
No |
From an IBM i command, start programs/commands on a PC
Incoming Remote Command |
Yes |
No |
| GUI to find, add, update, delete selected records in DB2 for i database table |
No |
Yes |
| GUI to convert query results to .PDF format |
No |
Yes |
| GUI to e-mail query results in one step |
No |
Yes |
| Wizard to import Query/400 SQL requests |
No |
Yes |
| Wizard to import Query Manager SQL requests |
No |
Yes |
| Wizard to import IBM i Access for Windows Data Transfer requests |
No |
Yes |
| Programming Support |
|
|
| ActiveX automation Objects |
Yes |
No |
| Limited support using java.net.URL and the documented URL Interfaces |
No |
Yes |
| SQL |
|
|
| All SQL Statements Supported |
Yes |
Yes |
| Wizards to build SELECT statements and convert to PC format |
Yes |
Yes |
| Can build SELECT statements with group, having, and join support |
Yes |
No |
| Can create dynamic queries (prompted for input at time of running) |
No |
Yes |
| Access to members other than the default member |
Yes |
No |
| Wizards to upload PC data to DB2 for i |
Yes |
Yes |
Support for Source Physical Files
(Note: sequence and data generated on uploads is not returned by default) |
Yes |
No (treated the same as other Table Values) |
| Microsoft Excel |
|
|
| Upload data directly from Excel |
Yes |
No |
| Excel dates/times handled as dates/times |
Yes |
No, handled as character strings |
| Requests |
|
|
| Can run predefined saved requests |
Yes |
Yes |
| Schedule requests to run silently |
Yes |
No |
| Can Share requests amongst users |
No, put on shared drive |
Yes, via Shortcuts |
| Can run multiple requests simultaneously (batch) |
Yes (RTOPCB, RFROMPCB) |
No |
| Asynchronous Processing (i.e., control returned before request completes) |
No |
Yes (except for Browser option) |
| Supported File Formats |
|
|
| Comma Separated Values (.csv) |
Yes |
Yes |
| Data Interchange Format (.dif) |
Yes |
Yes |
| Extensible Markup Language (.xml) |
Yes |
Yes |
| Hyper Text Markup Language (.html) (on downloads) |
Yes |
Yes |
| No conversion |
Yes |
No |
| ASCII Text |
Yes |
Yes |
| Text - Tab Delimited |
Yes |
Yes |
| Basic Random |
Yes |
No |
| Basic Sequential |
Yes |
No |
| DOS Random |
Yes |
No |
| DOS Random Type 2 |
Yes |
No |
| Preview (on downloads) |
Yes |
Yes |
| Portable Document Format (.pdf) (on downloads) |
No (can send to PC printer by selecting 'Print' as output device) |
Yes |
| Microsoft Excel Version 3 |
Yes |
Yes |
| Microsoft Excel Version 4 |
Yes |
Yes |
| Microsoft Excel Version 5 |
Yes |
No |
| Microsoft Excel Version 7 |
Yes |
No |
| Microsoft Excel Version 8 |
Yes |
No |
| Microsoft Excel XML |
Yes |
Yes |
| Lotus 1-2-3 |
Yes |
No |
| Lotus 1-2-3 Version 1 |
No |
Yes |
| Lotus 1-2-3 Version 4 |
Yes |
No |
| Lotus 1-2-3 Version 9 |
Yes |
No |
