This release includes the following enhancements:
SQL Compiler Directive Options
OpenESQL has been enhanced to support the following new SQL compiler directive options:
- DATE
- Controls the reformatting of date values in output parameters and in input parameter character host variables when DETECTDATE is also specified.
- TIME
- Controls the reformatting of date values in output parameters and in input parameter character host variables when DETECTDATE is also used.
- DATEDELIM
- Specifies a single character as the delimiter between the year, month, and day components to override the default delimiter determined by the HCOSS DIALECT or DATE directive specification.
- TIMEDELIM
- Specifies a single character as the delimiter between the hour, minute, and second components to override the default delimiter determined by the HCOSS DIALECT or TIME directive specification.
- TSTAMPSEP
- Specifies a single character as the separator between the date and time parts of timestamp and date/time data.
SQL Server
We now support Microsoft SQL Server 2012.
