|
 |
XML Support |
 |
|
Environments and Datasources |
|
 |
z/OS — DB2, VSAM, IMS, IDMS, Adabas, Datacom, sequential
|
|
|
VSE — DB2, VSAM, DL/I, Adabas, Datacom, sequential
|
|
|
Destinations |
| |
|
ODBC or JDBC application — PC or server
|
| |
|
CICS temporary storage queue or transient data queue
|
| |
|
transfer partner database (MS SQL Server, Oracle, Sybase, etc.)
|
|
|
Methods |
| |
|
Dynamic SQL — against DB2, or against VSAM, IMS, DL/I, CA-Datacom/DB (VSE only), or sequential via the Legacy Data Server |
| |
|
Programmatic — via Remote Stored Procedures (RSPs) and eXternal Stored Procedures (XSPs)
|
|
|
Control |
| |
|
Static — enable/disable via ViaSQL Access Server configuration |
| |
|
Client-controlled — via keyword sent with request |
| |
|
RSP-controlled — via code option |
|
|
Datatypes |
| |
|
Supported — CHAR, VARCHAR, LONG VARCHAR, DATE, TIME, TIMESTAMP, FLOAT, DECIMAL, INTEGER, SMALLINT |
| |
|
Not supported — binary and graphic datatypes |
|
|
Applications |
| |
|
Web data display — improved development and processing for HTML or ASP pages |
| |
|
Data exchange — for example, supplying preformatted orders and invoices, to business partners |
|
