Informix Dynamic Server.2000

Informix Dynamic Server.2000 : Server-Side Programming in C

5 (1 rating by Goodreads)
By (author) 

List price: US$57.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


Throughout 2000, look to Prentice Hall PTR for the hottest new books written for technical professionals. Each month, the PH PTR Technology Focus will highlight some of today's most important technologies and the PTR titles which will help you get the job done! These key books will be supported at conventions, in magazine space ads, on the WWW, and in partnership with the finest bookstores throughout the country.
show more

Product details

  • Paperback | 432 pages
  • 178.8 x 234.4 x 31.8mm | 834.62g
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 013013709X
  • 9780130137098

Table of contents

1. IDS.2000 = Business Advantage.

A Logical Evolution. Relational Evolution. Customization Evolution. DS2000 Features. More Features. What is a DataBlade Module? Performance. Hardware Components. Operating System. DS2000. Query Execution. Performance Advantages. Performance Advantages Summary. Other Advantages. How Far Can We Take IDS.2000?

2. User-Defined Routines.

Processes. Threads. Thread Implementations. DS2000 Multithreading. Dynamic Libraries. Symbol Visibility. UDR Restrictions. Ill-Behaved Functions. Create Function Statement. Function Resolution. Operator Overloading. Built-in Functions Overloading. Library Loading and Unloading. A Simple Example. The MI_FPARAM Argument. Memory Allocation. The DataBlade Development Kit (DBDK).

3. SQL Statements.

Syntax Diagram Explanation. AGGREGATE. Syntax. Description. Parameters Description. Examples. CAST. Syntax. Description. Parameters Description. Examples. DISTINCT TYPE. Syntax. Description. Parameters Description. Examples. FUNCTION. Syntax. Description. Parameters Description. Examples. GRANT. Syntax. Description. Parameters Description. Examples. OPAQUE TYPE. Syntax. Description. Parameters Description. Examples. OPCLASS. Syntax. Description. Parameters Description. Examples. PROCEDURE. Syntax. Description. Parameters Description. Examples. ROW TYPE. Syntax. Description. Parameters Description. Examples. Shared Library Reload. Syntax. Description. Examples.

4. Handling Data Types.


5. Computational Functions.

Functions Applications. Functions Parallelism. The Quarter Function. Function Overloading. Handling NULL Values. Returning a NULL Result. Raising Exceptions. SQLSTATE. mi_lvarchar API functions. Memory Allocation. mi_get_vardata(). mi_get_vardata_align(). mi_get_varlen(). mi_lvarchar_to_string(). mi_new_var(). mi_set_vardata(). mi_set_vardata_align(). mi_set_varlen(). mi_set_varptr(). mi_string_to_lvarchar(). mi_var_copy(). mi_var_free(). mi_var_to_buffer(). The mi_lvarchar Buffer Length.

6. User-Defined Types.

Complex Types. Row Types. Inserting Row Types. Row Type Constraints. Row Type Indexing. Row Type Processing. Getting the Row Type Name. Getting Other Information. Accessing Row Fields. Returning Rows. Executing SQL Statements. Collection Types. Collection Type Constraints. Collection Type Indexing. Collection Type Processing. Cursor Action and Jump Offset. Returning a Collection Type. Creating Complex Types. MI_CONNECTION Usage. Distinct Types.

7. Opaque Types.

Why Use Opaque Types? Elements of Opaque Types. Fixed and Variable-Size Opaque Type. Input and Output Functions. Import and Export Functions. Send and Receive Functions. Importbinary and Exportbinary Functions. The Compare Function. Comparison Functions. Assign and Destroy Functions. Math Functions. The B-Tree Functions. The R-Tree Functions. Like and Matches Functions. Other Functions. NULL Values.

8. Iterator Functions.

DataBlade API Elements. A Countdown Function. An Item Extraction Function. The SET_INIT Section. The SET_RETONE Section. The SET_END Section. Iterator Limitations. Limitations Work-Around. An SPL Solution. A C Solution. The SET_INIT Section. The SET_RETONE Section. The SET_END Section. Joining With an Iterator Function.

9. The Fastpath Interface.

Why Use Fastpath? The Fastpath Functions. Using System Casts. A Casting Example. Calling an Informix Function. Calling Another User Function. Finding Functions Information. Looking in $INFORMIXDIR. Looking in System Catalogs. Using a User-Defined Routine.

10. Smart Blobs and Multirepresentation.

What are Smart Large Objects? Where Are Smart Large Objects Stored? Defining Smart Blob Spaces. How to Find the Sbspaces. Creating Tables. Inserting Smart Large Objects. The Large Object API Functions. Large Object Structures. Processing a Large Object. Large Object Statistics. Large Object Specifications. Creating a Large Object. Getting Row Specifications. Opaque Types and Large Objects. Getting Row Context. The lohandles() Function. Multirepresentation Opaque Types. Large Object Storage Specifications Caveats.

11. Aggregate Functions.

DS2000 Aggregate Functions. Aggregate Functions Use. Extending Built-In Aggregate Functions. How Do Aggregate Functions Work? The User-Defined Aggregate Model. The Type. Defining a User-Defined Aggregate. A Simple Example: MYAVG(). Processing Arguments. Top N Market Share Example. Other Aggregation Usage.

12. Tracing and Debugging.

Most Frequent Problems. Old Library. Symbol Not Found. Value or Reference. Using Buffers. Using mi_lvarchar and mi_bitvarying. Use of SPL. Scripting Your Tests. Tracing. Debugging. Debugging Under UNIX. Debugging Under Windows NT. Shared-Memory Dump.

Appendix: Functions Reference.

Functions Categories. Byte Operations (ESQL/C). Callbacks. Character Processing (ESQL/C). Collections. Connecting and Disconnecting. Converting and Copying. Conversion. Codeset Conversion. DATE Conversion (ESQL/C). DATETIME & INTERVAL (ESQL/C). DECIMAL Operations (ESQL/C). Exception Handling. Function Execution. General Information About Results. General Information About Statements. Handling NULL. Information About the Current Statement. INT8 Access (ESQL/C). LVARCHAR Manipulation. Memory Management. Multirepresentation ADT Support. Operating System File Interface. Parameters and Environment. Parameterized Queries and Cursors. Retrieving Row and Row Data. Save Sets. Sending SQL Statements. Smart Large Object Creation. Smart Large Object I/O. (Moving) Smart Large Objects to and from OS Files. (Manipulating) Smart Large Object Handles. (Handling) Smart Large Object Specifications. (Handling) Smart Large Object Statistics. Thread Management. Transaction and Server Processing State Change. Tracing. Type Conversion (ESQL/C). VARCHARs Manipulation (ESQL/C). Functions Reference.

show more

Rating details

1 ratings
5 out of 5 stars
5 100% (1)
4 0% (0)
3 0% (0)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X