Skip to main content

 
IBM Power Systems software  >  IBM i  > Software  > 

System i Access

  
Overview Windows Linux Web Wireless
 
  System i Access resources
  Access for Windows and for Web Comparison
  Comments from Users
  Comparison of Database Capabilities
  Developers Corner
  Downloads
  Events
  Packaging
  Presentations

  Comparison of Database Capabilities
     
Feature / Function
iSeries Access
for Windows
(V5R4)
iSeries 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 i5/OS 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 iSeries 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