ASNA DataGate/400
If the iSeries 400 and/or AS/400 is your server of choice, you will achieve fast, record-level DB2/400 database access from Windows and the Web with DataGate/400. Whether you are developing your client applications in Visual Basic, C, C++ or ASNA Visual RPG, DataGate/400 provides the direct file access needed for efficient Client/Server processing - without SQL and ODBC.
Click on an image to view a larger version.
English
Supported Technologies
Windows XP/2000/NT
C/C++,
RPG,
XML
Software
Click on a technology to view similar products within this category.
Pricing
Users (# of seats)
marketing@asna.com
800-289-2762
Resources
Additional Product Information
iSeries 400 and AS/400 connectivity is supported for TCP/IP.
DataGate/400 retains all iSeries 400 and AS/400 object authority and object locking. Its Remote Program Call support features automatic program initiation and activation, and allows character, numeric and indicator (boolean) parameter data types.
DataGate/400 provides full object control for the iSeries 400 and AS/400 including: creating files; accessing file definitions; adding, deleting and initializing file members; renaming and copying files. It provides full access to CL commands and data areas, and it utilizes all AS/400 CPF error messaging.
Installation on the iSeries 400 and AS/400 is simple. DataGate/400 is self-initiating and requires no programming or maintenance on the iSeries 400 or AS/400 to utilize.
Acceler8DB, the companion product to DataGate/400, provides seamless record-level access to Windows NT/2000 from the Windows Client in addition to the same powerful database on the Client itself. However, the server or local database being accessed is transparent to ASNA Visual RPG, Visual Basic and C++ applications because Acceler8DB and DataGate/400 provide the same API. Any application program can concurrently and interchangeably access multiple Acceler8DB and DB2/400 databases.
"ASNA DataGate provides fast, record-level access to the AS/400. I was able to quickly get my applications running in a client/server environment."
Ralph Smith, RSI, Inc.
ASNA DataGate for SQL Server:
RPG Access to Microsoft's SQL Server 2000
ASNA's upcoming release of DataGate for SQL Server (1st quarter 2002) will provide RPG programmers access to SQL Server 2000 through native RPG file IO using familiar RPG operation codes such as CHAIN and SETLL. AVR programmers will not need to learn SQL to get effective access to SQL Server?the skills they use today for AS/400 file IO will work exactly the same way for SQL Server. And, the same AVR programs that also connect to SQL Server will seamlessly connect to the AS/400 and ASNA?s Acceler8DB database for NT/2000 Servers and laptops. This lets AVR programmers write one set of Web, Wireless and Windows applications that work concurrently with both the AS/400 and SQL Server.
Microsoft SQL Server currently occupies four of the top five TPC-C performance test scores and ten out of ten spots in the TPC?C price/performance test scores (see http://www.tpc.org for details). ASNA?s upcoming support for SQL Server means that AVR programmers will have native, transparent access to two of the most widely used business databases today: DB2/400 and SQL Server. Because SQL Server comprises the core of the Microsoft Database Engine (MSDE?one of Microsoft's engines), ASNA?s SQL Server support also means that AVR programs will also connect seamlessly, again using native RPG file IO, to Microsoft Access. ASNA will also continue to offer support for its own NT/2000 and laptop database, Acceler8DB.
By supporting SQL Server, AVR programmers will have full access to all of SQL Server?s features such as:
?user-defined data types, triggers and referential integrity
?the rich set of SQL Server tools (both included with SQL Server and available from third parties) for ad-hoc query and reporting and SQL Server?s built-in full English query component
?built-in (and third-party) tools for data replication and data warehousing
?direct XML data access
?SQL Server?s "save-while-active" feature
In addition to using native RPG file operations with SQL Server 2000, ASNA?s SQL Server support also offers AVR programmers the ability to use built-in AS/400 features such as open query file and AVR?s CopyData (a CPYF-workalike) between the AS/400 and SQL Server.