OTL 4.0, Examples for Sybase SQL Server / FreeTDS ODBC

The examples below work with Sybase SQL Server 15.0 for Linux and Windows via FreeTDS ODBC.  The underlying database had "allow NULLs by default", and "ddl in transactions" enabled.

1. Example 547 (Sybase SQL  Server stored procedure call)
2. Example 548 (TIMESTAMP_STRUCT and Sybase SQL  Server)
3. Example 549 (Sybase SQL Server and TEXT column)
4. Example 550 (Sybase SQL  Server and IMAGE column)
5. Example 551 (Sybase SQL  Server: otl_stream::describe_select() and result sets)
6. Example 552 (Datatype override in SELECT, Sybase SQL  Server)
7. Example 553 (Simple Insert/Select and otl_stream::clean() function for OTL/ODBC and Sybase SQL  Server)
8. Example 554 (STL std::strings, ANSI C++ typecasts, Sybase SQL  Server)
9. Example 555 (STL-compliant OTL/ODBC stream iterators, Sybase SQL  Server)
10. Example 556 (#define OTL_UNCAUGHT_EXCEPTION_ON, ODBC / Sybase SQL  Server)
11. Example 557 (#define OTL_EXTENDED_EXCEPTION, ODBC / Sybase SQL  Server)
12. Example 558 (OTL/ODBC and bulk operations with Sybase SQL  Server's TEXT)
13. Example 559 (Group data type override in SELECT, Sybase SQL  Server)
14. Example 560 (Describe otl_stream's bind variables for Sybase SQL  Server)
15. Example 561 (set_transaction_isolation_level, ODBC, Sybase SQL )
16. Example 562 (external logon, ODBC, Sybase SQL )
17. Example 563 (otl_stream::clean(), cancelling SELECT's fetch sequence, Sybase SQL  Server)
18. Example 564 (otl_stream::clean(), cancelling Result Set's fetch sequence, Sybase SQL  Server)
19. Example 565 (otl_stream::clean(), cleaning the Result Set stream's error flags, Sybase SQL  Server )
20. Example 566 (otl_datetime container with Datetime values down to milliseconds in Sybase SQL  Server)
21. Example 567 (otl_exception, derived from a base class, Sybase SQL  Server)
22. Example 568 (OTL_ADD_NULL_TERMINATOR_STRING_SIZE,Sybase SQL  Server)
23. Example 569 (std::string and TEXTs, Sybase SQL  Server)
24. Example 570 (SQL statement label, Sybase SQL  Server)
25. Example 571 (OTL/ODBC, accessing the system data dictionary via ODBC functions, Sybase SQL  Server)
26. Example 572 (OTL/ODBC, accessing the system data dictionary via ODBC functions, Sybase SQL  Server)
27. Example 573 (OTL/ODBC, accessing the system data dictionary via ODBC functions, Sybase SQL  Server)
28. Example 574 (user defined string class and TEXTs, Sybase SQL  Server)
29. Example 575 (OTL tracing, ODBC, Sybase SQL  Server)
30. Example 576 (Explict bind variables in SELECT statement column definitions, ODBC, Sybase SQL  Server)
31. Example 577 (#define OTL_THROWS_ON_SQL_SUCCESS_WITH_INFO, ODBC, Sybase SQL  Server)
32. Example 578 (OTL stream read iterator, simple SELECT, Sybase SQL  / ODBC)
33. Example 579 (OTL stream read iterator, implicit result set, Sybase SQL  / ODBC)
34. Example 580 (Strict numeric type checking on SELECTs)
35. Example 581 (OTL stream read iterator, "get by name" functions, Sybase SQL  / ODBC)
36. Example 582 (Simple Insert/Select, otl_connect::operator<<, <<=, >>)
52. Example 583 (Simple Insert/Select with VARBINARY datatype)
54. Example 584 (Simple Insert/Select with VARBINARY datatype and otl_stream_read_iterator)

---

Prev NextContentsGo Home

Copyright © 1996-2024, Sergei Kuchin, email: skuchin@gmail.com, skuchin@gmail.com .

Permission to use, copy, modify and redistribute this document for any purpose is hereby granted without fee, provided that the above copyright notice appear in all copies. THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.