Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ ODBC Driver GuideThe HCL OneDB™ ODBC Driver Programmer's Manual serves as a user guide and reference for HCL OneDB™ ODBC Driver, which is the HCL OneDB™ implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
Client functionsThese topics describe the HCL OneDB™ ODBC Driver client functions. Use these functions to access and manipulate smart large objects and rows and collections.
Functions for smart large objectsThis section describes each client function that the driver provides for smart large objects.
The ifx_lo_truncate() functionThe ifx_lo_truncate() function truncates a smart large object at the specified position.

The ifx_lo_truncate() function

The ifx_lo_truncate() function truncates a smart large object at the specified position.

Syntax

ifx_lo_truncate(lofd, offset)

The function accepts the following arguments.


Argument	Type	Use	Description
lofd	SQL_INTEGER	Input	Smart-large-object file descriptor
offset	SQL_BIGINT	Input	End of the smart large object. If this value exceeds the end of the smart large object, the function extends the smart large object. If this value is less than the end of the smart large object, the database server reclaims all storage from the offset position to the end of the smart large object. Instead of using the default HCL OneDB™ ODBC Driver C data type of SQL_C_CHAR for offset, use SQL_C_LONG or SQL_C_SHORT.

The ifx_lo_truncate() function sets the end of a smart large object to the location that the offset argument specifies.