The New Version of Shadowbase for Open Server internalizes datatype conversions for DATE, TIME, and TIMESTAMP data types.
Effective in release 4.040N of Shadowbase for Open Server, and 4.092 of Shadowbase for NonStop, is support for the new target database format SQLSBV1. This new target database format type enhances all NonStop Open Server data feeds by removing limitations on NonStop SQL DATETIME precision. Formerly, Shadowbase only supported DATETIME year to fraction(6) conversions with precision to the second (the fractions part was removed). This support was the default because historically databases like Oracle only supported resolution to the second in their DATE datatype. Previously, the only way to support fractional precision was with USEREXIT processing.
With the use of the new SQLSBV1 setting, decimal precision is now supported to 6 decimal places, for example, when the target Open schema is SQLSRVR DATETIME2:
SQL/MP source schema
mydate DATETIME YEAR TO FRACTION(6)
with the appropriate consumer parameter
SET CONS TARGETTYPE SQLSBV1
and corresponding Open Server configuration value
Source database format [ORACLE]
(MSSQL, ORACLE, SYBASE, SQL92, SQLSBV1): SQLSBV1
Additionally, SQLSBV1 will use any defined NonStop dummy table column definition to format the data for the target column. For example, when replicating from a column defined as DATETIME YEAR TO FRACTION(6) to SQL Server, you can now define the dummy column to be DATETIME YEAR TO FRACTION(3) to match what the target column can hold, again avoiding the need for a user exit to do the truncation from 6 digits to 3.
Shadowbase Open Server supports receiving SQLSBV1 data from the NonStop in both Cached and Non-Cached forms. However, Shadowbase Open Server does not support replay of SQLSBV1 DOC data to all supported target databases. The following table describes target replay support for SQLSBV1 DOC data.
Microsoft SQL Server Yes
Sybase ASE Yes
IBM DB2 Yes
HP NonStop SQL/MP Yes
*Support for SQLSBV1 to an Oracle target is under consideration at this time. Check with Shadowbase Support for availability of this enhancement for Oracle targets.