Skip to content

Latest commit

 

History

History
57 lines (42 loc) · 1.81 KB

File metadata and controls

57 lines (42 loc) · 1.81 KB
title getSubString Method (SQLServerClob) | Microsoft Docs
ms.custom
ms.date 01/19/2017
ms.prod sql
ms.prod_service connectivity
ms.reviewer
ms.technology connectivity
ms.topic conceptual
apiname
SQLServerClob.getSubString
apilocation
sqljdbc.jar
apitype Assembly
ms.assetid bf915590-a883-4403-befa-5b5bb42f34d8
author David-Engel
ms.author v-daenge

getSubString Method (SQLServerClob)

[!INCLUDEDriver_JDBC_Download]

Returns a copy of the specified substring in the CLOB based on the given starting position and the number of characters to copy.

Syntax

  
public java.lang.String getSubString(long pos,  
                                     int length)  

Parameters

pos

The first character of the substring to be extracted. The first character is at position 1.

length

The number of consecutive characters to be copied.

Return Value

A String that is the specified substring in the CLOB.

Exceptions

SQLServerException

Remarks

This getSubString method is specified by the getSubString method in the java.sql.Clob interface.

Trying to get zero characters from a null or zero-length CLOB returns an empty string. Trying to get any length of characters at any position other than position 1 in a zero-length CLOB will cause a position exception to be thrown.

See Also

SQLServerClob Methods
SQLServerClob Members
SQLServerClob Class