TS DataServer™TS DataServer™
Release Notes Home Basic™ VIP Suite/Tbredcomm™ OPENworkshop® Report-IV™ toPDF T-RemoteControl™

Enhancements

All SQL DataServers

  1. A format's definition will be reloaded when determined to be out of sync with the client.
  2. DEBUG-FLAGS registry/ini file control adds the ability to enable and disable additional information written into the debug log file for an SQL DataServer. The flag values are:
    Flag NumberDescription
    1Disable logging of the process ID number
    2Enable logging of a time stamp
    4Enable logging of parameter values.
    8Enable logging of fetched values

TS DataServer™ for Oracle

  1. TS DataServer for Oracle 11g.

TS DataServer™ for MS SQL Server

  1. Enhanced validation of data source names.
  2. READUNCOMMITTED registry control adds 'WITH (NOLOCK)' to SQL statements when READing. This control is enabled by default.
  3. Replaced FASTFIRSTROW table hint with OPTION FAST(1) query hint when generating SQL statements.

TS DataServer™ for MySQL

  1. Enhanced validation of database names.
  2. Implemented LOCK and UNLOCK.
  3. NO-PLUGIN ini file control signals that MySQL is running without the InnoDB plugin.

TS ODBC DataServer™

  1. TS ODBC DataServer has been updated to ODBC 3.0 compliant.
  2. A LIMIT clause has been added to SELECT statements. The syntax is:

    LIMIT {[offset,] row_count | row_count [OFFSET offset]}.

    This is the same syntax used by MySQL. Must occur after ORDER BY.
  3. Support for TIME to the nearest second has been added for Date Types 5 and 8. Time in key fields is unchanged. Specify using the appropriate {ts 'YYYY-MM-DD HH:MI:SS'} or {t 'HH:MI:SS'}.
  4. Single-Tier can now use the global TERMINAL file.
  5. File Suffix Methods specified in Links have been disabled. This functionality is provided by the ODBC Expose Utility. PRM ODBCFS is provided to enable File Suffix Methods again if necessary.
  6. TIM=mval can be specified in TSODBC.INI to force termination when a connection has been idle for mval minutes. Minutes can not exceed 4 digits. A message is written to TSODBC.LOG that includes the Data Source Name and the User Login.

Changes

All SQL DataServers

  1. Prevent one channel from committing any uncommitted rows on another channel when global commit count has been set.
  2. A WRITE that would update a row, now performs the update and no longer returns an ERR=150.
  3. A problem saving numeric values with a precision greater than 2 for type 0, 1 and 2 has been resolved.
  4. Problems sending a key, date type 5.6, when the date value is beyond the 50 year range have been corrected.
  5. Problems when the table name in the link is enclosed within square brackets have been corrected.

TS DataServer for Oracle

  1. A problem generating SQL statements for EXTRACT has been corrected.
  2. Problems returning a text field when the TEXT_WIDTH value is less than 100 have been corrected.
  3. Problems when columns specified in a format are not in the SQL table have been corrected.

TS ODBC DataServer;

  1. A problem causing Access 2010 using .accdb data links to only display the first record of a linked table has been corrected.

TS DataServer for MS SQL Server

  1. Disable all TS-TABLE-LOCK locking if NO-OPENLOCK is enabled.
  2. Exclusively lock both the data and text field tables before a link ERASE.
  3. Problems copying text field data via Script-IV have been corrected.
  4. Problems when starting tsmssql process as a standard Windows user have been corrected.
  5. A problem generating SQL statements for EXTRACT has been corrected.
  6. Problems with LOCK and UNLOCK have been corrected.

TS DataServer for MySQL

  1. Disable all TS-TABLE-LOCK locking if NO-OPENLOCK is enabled.
  2. Exclusively lock both the data and text field tables before a link ERASE.
  3. Problems copying text field data via Script-IV have been resolved.
  4. Problems updating a text field have been resolved.
  5. Problems when columns specified in a format are not in the SQL table have been corrected.