Table 16. These functions require the support of specific database management systems.
| Function Supported | DB2 for MVS | workstation database servers | SQL/DS |
|---|---|---|---|
| Length of query statement | 32,765 | 32,765 | 8,192 |
| Number of columns in SELECT statement | 750 | 255 | 255 |
| Import single-precision floating point numbers | X |
| X |
| Long fields with LIKE statement | X |
| X |
| Database synonyms | X |
| X |
| Database aliases for tables or views | X | X |
|
| SAVE=IMMEDIATE option available in Table Editor (Supports CURSOR HOLD | X | X |
|
| Distributed Unit of Work (three-part names) | X |
|
|
| Remote Unit of Work | X | X | on VSE, requires Version 3 Release 4 |