| Function Supported | DB2 for OS/390 | 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 |