Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

MSSQL_SERVER_STATEMENT_TIMEOUT Statement

MSSQL_SERVER_STATEMENT_TIMEOUT Statement

The MSSQL_SERVER_STATEMENT_TIMEOUT statement specifies the timeout interval, in seconds, for processing a Transact-SQL statement issued by the PowerExchange Navigator, DTLUCBRG utility, or DTLURDMO utility to the Microsoft SQL Server Management Objects (SMO) interface.
After this interval elapses, processing of the Transact-SQL statement stops with error message PWX-15700. If you are receive PWX-15700 messages related to this error, use this statement to increase the timeout interval.
Windows
Microsoft SQL Server
MSSQL_SERVER_CONNECT_TIMEOUT
No
MSSQL_SERVER_STATEMENT_TIMEOUT={
seconds
|
60
}
For the
seconds
value, enter a number from 1 to 86400. Default is 60 seconds.