Class JdbcCallableStatement

    Jdbc Callable Statement

    A JDBC Callable Statement . For documentation of this class, see java.sql.CallableStatement .

    Methods

    Method Return type Brief description
    add Batch()
    		void For documentation of this method, see java.sql.PreparedStatement#addBatch() .
    add Batch(sql)
    		void For documentation of this method, see java.sql.Statement#addBatch(String) .
    cancel()
    		void For documentation of this method, see java.sql.Statement#cancel() .
    clear Batch()
    		void For documentation of this method, see java.sql.Statement#clearBatch() .
    clear Parameters()
    		void For documentation of this method, see java.sql.PreparedStatement#clearParameters() .
    clear Warnings()
    		void For documentation of this method, see java.sql.Statement#clearWarnings() .
    close()
    		void For documentation of this method, see java.sql.Statement#close() .
    execute()
    		Boolean For documentation of this method, see java.sql.PreparedStatement#execute() .
    execute(sql)
    		Boolean For documentation of this method, see java.sql.Statement#execute(String) .
    execute(sql, autoGeneratedKeys)
    		Boolean For documentation of this method, see java.sql.Statement#execute(String, int) .
    execute(sql, columnIndexes)
    		Boolean For documentation of this method, see java.sql.Statement#execute(String, int[]) .
    execute(sql, columnNames)
    		Boolean For documentation of this method, see java.sql.Statement#execute(String, String[]) .
    execute Batch()
    		Integer[] For documentation of this method, see java.sql.Statement#executeBatch() .
    execute Query()
    		Jdbc Result Set For documentation of this method, see java.sql.PreparedStatement#executeQuery() .
    execute Query(sql)
    		Jdbc Result Set For documentation of this method, see java.sql.Statement#executeQuery(String) .
    execute Update()
    		Integer For documentation of this method, see java.sql.PreparedStatement#executeUpdate() .
    execute Update(sql)
    		Integer For documentation of this method, see java.sql.Statement#executeUpdate(String) .
    execute Update(sql, autoGeneratedKeys)
    		Integer For documentation of this method, see java.sql.Statement#executeUpdate(String, int) .
    execute Update(sql, columnIndexes)
    		Integer For documentation of this method, see java.sql.Statement#executeUpdate(String, int[]) .
    execute Update(sql, columnNames)
    		Integer For documentation of this method, see java.sql.Statement#executeUpdate(String, String[]) .
    get Array(parameterIndex)
    		Jdbc Array For documentation of this method, see java.sql.CallableStatement#getArray(int) .
    get Array(parameterName)
    		Jdbc Array For documentation of this method, see java.sql.CallableStatement#getArray(String) .
    get Big Decimal(parameterIndex)
    		Big Number For documentation of this method, see java.sql.CallableStatement#getBigDecimal(int) .
    get Big Decimal(parameterName)
    		Big Number For documentation of this method, see java.sql.CallableStatement#getBigDecimal(String) .
    get Blob(parameterIndex)
    		Jdbc Blob For documentation of this method, see java.sql.CallableStatement#getBlob(int) .
    get Blob(parameterName)
    		Jdbc Blob For documentation of this method, see java.sql.CallableStatement#getBlob(String) .
    get Boolean(parameterIndex)
    		Boolean For documentation of this method, see java.sql.CallableStatement#getBoolean(int) .
    get Boolean(parameterName)
    		Boolean For documentation of this method, see java.sql.CallableStatement#getBoolean(String) .
    get Byte(parameterIndex)
    		Byte For documentation of this method, see java.sql.CallableStatement#getByte(int) .
    get Byte(parameterName)
    		Byte For documentation of this method, see java.sql.CallableStatement#getByte(String) .
    get Bytes(parameterIndex)
    		Byte[] For documentation of this method, see java.sql.CallableStatement#getBytes(int) .
    get Bytes(parameterName)
    		Byte[] For documentation of this method, see java.sql.CallableStatement#getBytes(String) .
    get Clob(parameterIndex)
    		Jdbc Clob For documentation of this method, see java.sql.CallableStatement#getClob(int) .
    get Clob(parameterName)
    		Jdbc Clob For documentation of this method, see java.sql.CallableStatement#getClob(String) .
    get Connection()
    		Jdbc Connection For documentation of this method, see java.sql.Statement#getConnection() .
    get Date(parameterIndex)
    		Jdbc Date For documentation of this method, see java.sql.CallableStatement#getDate(int) .
    get Date(parameterIndex, timeZone)
    		Jdbc Date For documentation of this method, see java.sql.CallableStatement#getDate(int, Calendar) .
    get Date(parameterName)
    		Jdbc Date For documentation of this method, see java.sql.CallableStatement#getDate(String) .
    get Date(parameterName, timeZone)
    		Jdbc Date For documentation of this method, see java.sql.CallableStatement#getDate(String, Calendar) .
    get Double(parameterIndex)
    		Number For documentation of this method, see java.sql.CallableStatement#getDouble(int) .
    get Double(parameterName)
    		Number For documentation of this method, see java.sql.CallableStatement#getDouble(String) .
    get Fetch Direction()
    		Integer For documentation of this method, see java.sql.Statement#getFetchDirection() .
    get Fetch Size()
    		Integer For documentation of this method, see java.sql.Statement#getFetchSize() .
    get Float(parameterIndex)
    		Number For documentation of this method, see java.sql.CallableStatement#getFloat(int) .
    get Float(parameterName)
    		Number For documentation of this method, see java.sql.CallableStatement#getFloat(String) .
    get Generated Keys()
    		Jdbc Result Set For documentation of this method, see java.sql.Statement#getGeneratedKeys() .
    get Int(parameterIndex)
    		Integer For documentation of this method, see java.sql.CallableStatement#getInt(int) .
    get Int(parameterName)
    		Integer For documentation of this method, see java.sql.CallableStatement#getInt(String) .
    get Long(parameterIndex)
    		Integer For documentation of this method, see java.sql.CallableStatement#getLong(int) .
    get Long(parameterName)
    		Integer For documentation of this method, see java.sql.CallableStatement#getLong(String) .
    get Max Field Size()
    		Integer For documentation of this method, see java.sql.Statement#getMaxFieldSize() .
    get Max Rows()
    		Integer For documentation of this method, see java.sql.Statement#getMaxRows() .
    get Meta Data()
    		Jdbc Result Set Meta Data For documentation of this method, see java.sql.PreparedStatement#getMetaData() .
    get More Results()
    		Boolean For documentation of this method, see java.sql.Statement#getMoreResults() .
    get More Results(current)
    		Boolean For documentation of this method, see java.sql.Statement#getMoreResults(int) .
    get NClob(parameterIndex)
    		Jdbc Clob For documentation of this method, see java.sql.CallableStatement#getNClob(int) .
    get NClob(parameterName)
    		Jdbc Clob For documentation of this method, see java.sql.CallableStatement#getNClob(String) .
    get NString(parameterIndex)
    		String For documentation of this method, see java.sql.CallableStatement#getNString(int) .
    get NString(parameterName)
    		String For documentation of this method, see java.sql.CallableStatement#getNString(String) .
    get Object(parameterIndex)
    		Object For documentation of this method, see java.sql.CallableStatement#getObject(int) .
    get Object(parameterName)
    		Object For documentation of this method, see java.sql.CallableStatement#getObject(String) .
    get Parameter Meta Data()
    		Jdbc Parameter Meta Data For documentation of this method, see java.sql.PreparedStatement#getParameterMetaData() .
    get Query Timeout()
    		Integer For documentation of this method, see java.sql.Statement#getQueryTimeout() .
    get Ref(parameterIndex)
    		Jdbc Ref For documentation of this method, see java.sql.CallableStatement#getRef(int) .
    get Ref(parameterName)
    		Jdbc Ref For documentation of this method, see java.sql.CallableStatement#getRef(String) .
    get Result Set()
    		Jdbc Result Set For documentation of this method, see java.sql.Statement#getResultSet() .
    get Result Set Concurrency()
    		Integer For documentation of this method, see java.sql.Statement#getResultSetConcurrency() .
    get Result Set Holdability()
    		Integer For documentation of this method, see java.sql.Statement#getResultSetHoldability() .
    get Result Set Type()
    		Integer For documentation of this method, see java.sql.Statement#getResultSetType() .
    get Row Id(parameterIndex)
    		Jdbc Row Id For documentation of this method, see java.sql.CallableStatement#getRowId(int) .
    get Row Id(parameterName)
    		Jdbc Row Id For documentation of this method, see java.sql.CallableStatement#getRowId(String) .
    get SQLXML(parameterIndex)
    		Jdbc SQLXML For documentation of this method, see java.sql.CallableStatement#getSQLXML(int) .
    get SQLXML(parameterName)
    		Jdbc SQLXML For documentation of this method, see java.sql.CallableStatement#getSQLXML(String) .
    get Short(parameterIndex)
    		Integer For documentation of this method, see java.sql.CallableStatement#getShort(int) .
    get Short(parameterName)
    		Integer For documentation of this method, see java.sql.CallableStatement#getShort(String) .
    get String(parameterIndex)
    		String For documentation of this method, see java.sql.CallableStatement#getString(int) .
    get String(parameterName)
    		String For documentation of this method, see java.sql.CallableStatement#getString(String) .
    get Time(parameterIndex)
    		Jdbc Time For documentation of this method, see java.sql.CallableStatement#getTime(int) .
    get Time(parameterIndex, timeZone)
    		Jdbc Time For documentation of this method, see java.sql.CallableStatement#getTime(int, Calendar) .
    get Time(parameterName)
    		Jdbc Time For documentation of this method, see java.sql.CallableStatement#getTime(String) .
    get Time(parameterName, timeZone)
    		Jdbc Time For documentation of this method, see java.sql.CallableStatement#getTime(String, Calendar) .
    get Timestamp(parameterIndex)
    		Jdbc Timestamp For documentation of this method, see java.sql.CallableStatement#getTimestamp(int) .
    get Timestamp(parameterIndex, timeZone)
    		Jdbc Timestamp For documentation of this method, see java.sql.CallableStatement#getTimestamp(int, Calendar) .
    get Timestamp(parameterName)
    		Jdbc Timestamp For documentation of this method, see java.sql.CallableStatement#getTimestamp(String) .
    get Timestamp(parameterName, timeZone)
    		Jdbc Timestamp For documentation of this method, see java.sql.CallableStatement#getTimestamp(String, Calendar) .
    get URL(parameterIndex)
    		String For documentation of this method, see java.sql.CallableStatement#getURL(int) .
    get URL(parameterName)
    		String For documentation of this method, see java.sql.CallableStatement#getURL(String) .
    get Update Count()
    		Integer For documentation of this method, see java.sql.Statement#getUpdateCount() .
    get Warnings()
    		String[] For documentation of this method, see java.sql.Statement#getWarnings() .
    is Closed()
    		Boolean For documentation of this method, see java.sql.Statement#isClosed() .
    is Poolable()
    		Boolean For documentation of this method, see java.sql.Statement#isPoolable() .
    register Out Parameter(parameterIndex, sqlType)
    		void For documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int) .
    register Out Parameter(parameterIndex, sqlType, scale)
    		void For documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, int) .
    register Out Parameter(parameterIndex, sqlType, typeName)
    		void For documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, String) .
    register Out Parameter(parameterName, sqlType)
    		void For documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int) .
    register Out Parameter(parameterName, sqlType, scale)
    		void For documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, int) .
    register Out Parameter(parameterName, sqlType, typeName)
    		void For documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, String) .
    set Array(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setArray(int, Array) .
    set Big Decimal(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, BigDecimal) .
    set Big Decimal(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setBigDecimal(String, BigDecimal) .
    set Blob(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setBlob(int, Clob) .
    set Blob(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setBlob(String, Blob) .
    set Boolean(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean) .
    set Boolean(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setBoolean(String, boolean) .
    set Byte(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setByte(int, byte) .
    set Byte(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setByte(String, byte) .
    set Bytes(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[]) .
    set Bytes(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setBytes(String, byte[]) .
    set Clob(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setClob(int, Clob) .
    set Clob(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setBlob(String, Clob) .
    set Cursor Name(name)
    		void For documentation of this method, see java.sql.Statement#setCursorName(String) .
    set Date(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setDate(int, Date) .
    set Date(parameterIndex, x, timeZone)
    		void For documentation of this method, see java.sql.PreparedStatement#setDate(int, Date, Calendar) .
    set Date(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setDate(String, Date) .
    set Date(parameterName, x, timeZone)
    		void For documentation of this method, see java.sql.CallableStatement#setDate(String, Date, Calendar) .
    set Double(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setDouble(int, double) .
    set Double(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setDouble(String, double) .
    set Escape Processing(enable)
    		void For documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean) .
    set Fetch Direction(direction)
    		void For documentation of this method, see java.sql.Statement#setFetchDirection(int) .
    set Fetch Size(rows)
    		void For documentation of this method, see java.sql.Statement#setFetchSize(int) .
    set Float(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setFloat(int, float) .
    set Float(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setFloat(String, float) .
    set Int(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setInt(int, int) .
    set Int(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setInt(String, int) .
    set Long(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setLong(int, long) .
    set Long(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setLong(String, long) .
    set Max Field Size(max)
    		void For documentation of this method, see java.sql.Statement#setMaxFieldSize(int) .
    set Max Rows(max)
    		void For documentation of this method, see java.sql.Statement#setMaxRows(int) .
    set NClob(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setNClob(int, NClob) .
    set NClob(parameterName, value)
    		void For documentation of this method, see java.sql.CallableStatement#setNClob(String, NClob) .
    set NString(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setNString(int, String) .
    set NString(parameterName, value)
    		void For documentation of this method, see java.sql.CallableStatement#setNString(String, String) .
    set Null(parameterIndex, sqlType)
    		void For documentation of this method, see java.sql.PreparedStatement#setNull(int, int) .
    set Null(parameterIndex, sqlType, typeName)
    		void For documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String) .
    set Null(parameterName, sqlType)
    		void For documentation of this method, see java.sql.CallableStatement#setNull(String, int) .
    set Null(parameterName, sqlType, typeName)
    		void For documentation of this method, see java.sql.CallableStatement#setNull(String, int, String) .
    set Object(index, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object) .
    set Object(parameterIndex, x, targetSqlType)
    		void For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int) .
    set Object(parameterIndex, x, targetSqlType, scaleOrLength)
    		void For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, int) .
    set Object(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setObject(String, Object) .
    set Object(parameterName, x, targetSqlType)
    		void For documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int) .
    set Object(parameterName, x, targetSqlType, scale)
    		void For documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int, int) .
    set Poolable(poolable)
    		void For documentation of this method, see java.sql.Statement#setPoolable(boolean) .
    set Query Timeout(seconds)
    		void For documentation of this method, see java.sql.Statement#setQueryTimeout(int) .
    set Ref(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setRef(int, Ref) .
    set Row Id(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setRowId(int, RowId) .
    set Row Id(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setRowId(String, RowId) .
    set SQLXML(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, SQLXML) .
    set SQLXML(parameterName, xmlObject)
    		void For documentation of this method, see java.sql.CallableStatement#setSQLXML(String, SQLXML) .
    set Short(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setShort(int, short) .
    set Short(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setShort(String, short) .
    set String(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setString(int, String) .
    set String(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setString(String, String) .
    set Time(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setTime(int, Time) .
    set Time(parameterIndex, x, timeZone)
    		void For documentation of this method, see java.sql.PreparedStatement#setTime(int, Time, Calendar) .
    set Time(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setTime(String, Time) .
    set Time(parameterName, x, timeZone)
    		void For documentation of this method, see java.sql.CallableStatement#setTime(String, Time, Calendar) .
    set Timestamp(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp) .
    set Timestamp(parameterIndex, x, timeZone)
    		void For documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar) .
    set Timestamp(parameterName, x)
    		void For documentation of this method, see java.sql.CallableStatement#setTimestamp(String, Timestamp) .
    set Timestamp(parameterName, x, timeZone)
    		void For documentation of this method, see java.sql.CallableStatement#setTimestamp(String, Timestamp, Calendar) .
    set URL(parameterIndex, x)
    		void For documentation of this method, see java.sql.PreparedStatement#setURL(int, URL) .
    set URL(parameterName, val)
    		void For documentation of this method, see java.sql.CallableStatement#setURL(String, URL) .
    was Null()
    		Boolean For documentation of this method, see java.sql.CallableStatement#wasNull() .

    Detailed documentation

    add Batch()

    For documentation of this method, see java.sql.PreparedStatement#addBatch() .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    add Batch(sql)

    For documentation of this method, see java.sql.Statement#addBatch(String) .

    Parameters

    Name Type Description
    sql
    		String The SQL command to add to this statement, typically an SQL INSERT or UPDATE .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    cancel()

    For documentation of this method, see java.sql.Statement#cancel() .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    clear Batch()

    For documentation of this method, see java.sql.Statement#clearBatch() .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    clear Parameters()

    For documentation of this method, see java.sql.PreparedStatement#clearParameters() .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    clear Warnings()

    For documentation of this method, see java.sql.Statement#clearWarnings() .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    close()

    For documentation of this method, see java.sql.Statement#close() .

    execute()

    For documentation of this method, see java.sql.PreparedStatement#execute() .

    Return

    Boolean — true if the first result is a result set; false if the first result is an update count or there is no result.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute(sql)

    For documentation of this method, see java.sql.Statement#execute(String) .

    Parameters

    Name Type Description
    sql
    		String The SQL statement to execute.

    Return

    Boolean — true if the first result is a result set; false if it is an update count or if there are no results.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute(sql, autoGeneratedKeys)

    For documentation of this method, see java.sql.Statement#execute(String, int) .

    Parameters

    Name Type Description
    sql
    		String The SQL statement to execute.
    auto Generated Keys
    		Integer A flag that indicates whether auto-generated keys are made available for future retrieval; either Jdbc.Statement.RETURN_GENERATED_KEYS or Jdbc.Statement.NO_GENERATED_KEYS .

    Return

    Boolean — true if the first result is a result set; false if it is an update count or if there are no results.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute(sql, columnIndexes)

    For documentation of this method, see java.sql.Statement#execute(String, int[]) .

    Parameters

    Name Type Description
    sql
    		String The SQL statement to execute.
    column Indexes
    		Integer[] The column indices in the whose auto-generated keys are made available for future retrieval.

    Return

    Boolean — true if the first result is a result set; false if it is an update count or if there are no results.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute(sql, columnNames)

    For documentation of this method, see java.sql.Statement#execute(String, String[]) .

    Parameters

    Name Type Description
    sql
    		String The SQL statement to execute.
    column Names
    		String[] The names of columns in the whose auto-generated keys are made available for future retrieval.

    Return

    Boolean — true if the first result is a result set; false if it is an update count or if there are no results.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute Batch()

    For documentation of this method, see java.sql.Statement#executeBatch() .

    Return

    Integer[] — The update counts for each command in the batch, using the same order in which commands were added to the batch.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute Query()

    For documentation of this method, see java.sql.PreparedStatement#executeQuery() .

    Return

    Jdbc Result Set — A result set that contains the data produced by the query.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute Query(sql)

    For documentation of this method, see java.sql.Statement#executeQuery(String) .

    Parameters

    Name Type Description
    sql
    		String The SQL statement to execute, typically a static SELECT .

    Return

    Jdbc Result Set — A result set containing the results of the execution. This is never null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute Update()

    For documentation of this method, see java.sql.PreparedStatement#executeUpdate() .

    Return

    Integer — The row count ofr SQL Data Manipulation Language statements, or 0 for SQL statements that return nothing.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute Update(sql)

    For documentation of this method, see java.sql.Statement#executeUpdate(String) .

    Parameters

    Name Type Description
    sql
    		String The SQL Data Manipulation Language statement to execute (such as INSERT , UPDATE , or DELETE ), or else a statement that returns nothing (such as a DDL statement).

    Return

    Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute Update(sql, autoGeneratedKeys)

    For documentation of this method, see java.sql.Statement#executeUpdate(String, int) .

    Parameters

    Name Type Description
    sql
    		String The SQL Data Manipulation Language statement to execute (such as INSERT , UPDATE , or DELETE ), or else a statement that returns nothing (such as a DDL statement).
    auto Generated Keys
    		Integer A flag that indicates whether auto-generated keys are made available for future retrieval; either Jdbc.Statement.RETURN_GENERATED_KEYS or Jdbc.Statement.NO_GENERATED_KEYS .

    Return

    Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute Update(sql, columnIndexes)

    For documentation of this method, see java.sql.Statement#executeUpdate(String, int[]) .

    Parameters

    Name Type Description
    sql
    		String The SQL Data Manipulation Language statement to execute (such as INSERT , UPDATE , or DELETE ), or else a statement that returns nothing (such as a DDL statement).
    column Indexes
    		Integer[] The column indices in the whose auto-generated keys are made available for future retrieval.

    Return

    Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    execute Update(sql, columnNames)

    For documentation of this method, see java.sql.Statement#executeUpdate(String, String[]) .

    Parameters

    Name Type Description
    sql
    		String The SQL Data Manipulation Language statement to execute (such as INSERT , UPDATE , or DELETE ), or else a statement that returns nothing (such as a DDL statement).
    column Names
    		String[] The names of columns in the whose auto-generated keys are made available for future retrieval.

    Return

    Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Array(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getArray(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Jdbc Array — The value of a ARRAY parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Array(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getArray(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Jdbc Array — The value of a ARRAY parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Big Decimal(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getBigDecimal(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Big Number — The value of a NUMERIC parameter in full precision. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Big Decimal(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getBigDecimal(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Big Number — The value of a NUMERIC parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Blob(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getBlob(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Jdbc Blob — The value of a BLOB parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Blob(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getBlob(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Jdbc Blob — The value of a BLOB parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Boolean(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getBoolean(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Boolean — The value of a BIT or BOOLEAN parameter. Returns false if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Boolean(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getBoolean(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Boolean — The value of a BIT or BOOLEAN parameter. Returns false if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Byte(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getByte(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Byte — The value of a TINYINT parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Byte(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getByte(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Byte — The value of a TINYINT parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Bytes(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getBytes(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Byte[] — The value of a BINARY or VARBINARY parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Bytes(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getBytes(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Byte[] — The value of a BINARY or VARBINARY parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Clob(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getClob(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Jdbc Clob — The value of a CLOB parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Clob(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getClob(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Jdbc Clob — The value of a CLOB parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Connection()

    For documentation of this method, see java.sql.Statement#getConnection() .

    Return

    Jdbc Connection — The connection that produced this statement.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Date(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getDate(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Jdbc Date — The value of a DATE parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Date(parameterIndex, timeZone)

    For documentation of this method, see java.sql.CallableStatement#getDate(int, Calendar) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Return

    Jdbc Date — The value of a DATE parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Date(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getDate(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Jdbc Date — The value of a DATE parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Date(parameterName, timeZone)

    For documentation of this method, see java.sql.CallableStatement#getDate(String, Calendar) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Return

    Jdbc Date — The value of a DATE parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Double(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getDouble(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Number — The value of a DOUBLE parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Double(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getDouble(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Number — The value of a DOUBLE parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Fetch Direction()

    For documentation of this method, see java.sql.Statement#getFetchDirection() .

    Return

    Integer — The default direction for result sets generated by this statement, which is either Jdbc.ResultSet.FETCH_FORWARD or Jdbc.ResultSet.FETCH_REVERSE .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Fetch Size()

    For documentation of this method, see java.sql.Statement#getFetchSize() .

    Return

    Integer — The default row fetch size for result sets generated from this statement.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Float(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getFloat(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Number — The value of a FLOAT parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Float(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getFloat(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Number — The value of a FLOAT parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Generated Keys()

    For documentation of this method, see java.sql.Statement#getGeneratedKeys() .

    Return

    Jdbc Result Set — A result set containing the auto-generated keys generated by the execution of this statement.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Int(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getInt(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Integer — The value of a INTEGER parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Int(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getInt(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Integer — The value of a INTEGER parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Long(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getLong(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Integer — The value of a BIGINT parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Long(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getLong(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Integer — The value of a BIGINT parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Max Field Size()

    For documentation of this method, see java.sql.Statement#getMaxFieldSize() .

    Return

    Integer — The current column byte size limit for columns storing character and binary values; a value of zero indictates no limit.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Max Rows()

    For documentation of this method, see java.sql.Statement#getMaxRows() .

    Return

    Integer — The current maximum number of rows for a result set produced by this statement; a value of 0 indicates no limit.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Meta Data()

    For documentation of this method, see java.sql.PreparedStatement#getMetaData() .

    Return

    Jdbc Result Set Meta Data — The description of a result set's columns, or NULL if this metadata is unavailable.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get More Results()

    For documentation of this method, see java.sql.Statement#getMoreResults() .

    Return

    Boolean — true if the next result is a result set; false otherwise.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get More Results(current)

    For documentation of this method, see java.sql.Statement#getMoreResults(int) .

    Parameters

    Name Type Description
    current
    		Integer A flag that indicates what happens to current result sets when retrieved. This value is one of Jdbc.Statement.CLOSE_CURRENT_RESULT , Jdbc.Statement.KEEP_CURRENT_RESULT , or Jdbc.Statement.CLOSE_ALL_RESULTS .

    Return

    Boolean — true if the next result is a result set; false otherwise.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get NClob(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getNClob(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer An index indicating which paramater to register (the first parameter is 1, the second is 2, and so on).

    Return

    Jdbc Clob — The value of a NCLOB parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get NClob(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getNClob(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Jdbc Clob — The value of a NCLOB parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get NString(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getNString(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer An index indicating which paramater to register (the first parameter is 1, the second is 2, and so on).

    Return

    String — A string that maps a NCHAR , NVARCHAR , or LONGNVARCHAR value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get NString(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getNString(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    String — A string that maps a NCHAR , NVARCHAR , or LONGNVARCHAR value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Object(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getObject(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Object — An object holding the parameter value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Object(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getObject(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Object — An object holding the parameter value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Parameter Meta Data()

    For documentation of this method, see java.sql.PreparedStatement#getParameterMetaData() .

    Return

    Jdbc Parameter Meta Data — The parameter metadata, including the number, types, and properties for each parameter.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Query Timeout()

    For documentation of this method, see java.sql.Statement#getQueryTimeout() .

    Return

    Integer — The current query timeout in seconds; a value of zero indicates no timeout.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Ref(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getRef(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Jdbc Ref — The value of a REF parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Ref(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getRef(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Jdbc Ref — The value of a REF parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Result Set()

    For documentation of this method, see java.sql.Statement#getResultSet() .

    Return

    Jdbc Result Set — The current result set, or null if the result is an update count or there are no more results.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Result Set Concurrency()

    For documentation of this method, see java.sql.Statement#getResultSetConcurrency() .

    Return

    Integer — The result set concurrency for result sets generated from this statement, which is either Jdbc.ResultSet.CONCUR_READ_ONLY or Jdbc.ResultSet.CONCUR_UPDATABLE .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Result Set Holdability()

    For documentation of this method, see java.sql.Statement#getResultSetHoldability() .

    Return

    Integer — The result set holdability, which is either Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT or Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Result Set Type()

    For documentation of this method, see java.sql.Statement#getResultSetType() .

    Return

    Integer — The result set type for result sets generated from this statement, which is Jdbc.ResultSet.TYPE_FORWARD_ONLY , Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE , or Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Row Id(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getRowId(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer An index indicating which paramater to register (the first parameter is 1, the second is 2, and so on).

    Return

    Jdbc Row Id — The ROWID value. Returns null if the parameter contains an SQL NULL .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Row Id(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getRowId(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Jdbc Row Id — The ROWID value. Returns null if the parameter contains an SQL NULL .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get SQLXML(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getSQLXML(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer An index indicating which paramater to register (the first parameter is 1, the second is 2, and so on).

    Return

    Jdbc SQLXML — A SQLXML object that maps to an SQL XML value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get SQLXML(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getSQLXML(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Jdbc SQLXML — A SQLXML object that maps to an SQL XML value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Short(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getShort(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Integer — The value of a SMALLINT parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Short(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getShort(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Integer — The value of a SMALLINT parameter. Returns 0 if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get String(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getString(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    String — The value of a CHAR , VARCHAR , or LONGVARCHAR parameter.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get String(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getString(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    String — The value of a CHAR , VARCHAR , or LONGVARCHAR parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Time(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getTime(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Jdbc Time — The value of a TIME parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Time(parameterIndex, timeZone)

    For documentation of this method, see java.sql.CallableStatement#getTime(int, Calendar) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Return

    Jdbc Time — The value of a TIME parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Time(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getTime(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Jdbc Time — The value of a TIME parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Time(parameterName, timeZone)

    For documentation of this method, see java.sql.CallableStatement#getTime(String, Calendar) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Return

    Jdbc Time — The value of a TIME parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Timestamp(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getTimestamp(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    Jdbc Timestamp — The value of a TIMESTAMP parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Timestamp(parameterIndex, timeZone)

    For documentation of this method, see java.sql.CallableStatement#getTimestamp(int, Calendar) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Return

    Jdbc Timestamp — The value of a TIMESTAMP parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Timestamp(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getTimestamp(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    Jdbc Timestamp — The value of a TIMESTAMP parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Timestamp(parameterName, timeZone)

    For documentation of this method, see java.sql.CallableStatement#getTimestamp(String, Calendar) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Return

    Jdbc Timestamp — The value of a TIMESTAMP parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get URL(parameterIndex)

    For documentation of this method, see java.sql.CallableStatement#getURL(int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).

    Return

    String — The value of a DATALINK parameter as a string.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get URL(parameterName)

    For documentation of this method, see java.sql.CallableStatement#getURL(String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter.

    Return

    String — The value of a DATALINK parameter. Returns null if the value is null .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Update Count()

    For documentation of this method, see java.sql.Statement#getUpdateCount() .

    Return

    Integer — The current result as an update count, or -1 if the current result is a result set or if there are no more results.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    get Warnings()

    For documentation of this method, see java.sql.Statement#getWarnings() .

    Return

    String[] — The current set of warnings, or null if there are no warnings.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    is Closed()

    For documentation of this method, see java.sql.Statement#isClosed() .

    Return

    Boolean — true if this statement is closed; false otherwise.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    is Poolable()

    For documentation of this method, see java.sql.Statement#isPoolable() .

    Return

    Boolean — true if this statement is poolable; false otherwise.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    register Out Parameter(parameterIndex, sqlType)

    For documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer An index indicating which paramater to register (the first parameter is 1, the second is 2, and so on).
    sql Type
    		Integer The JDBC type code to register. If the parameter is of JDBC type NUMERIC or DECIMAL , use register Out Parameter(parameterIndex, sqlType, scale) instead.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    register Out Parameter(parameterIndex, sqlType, scale)

    For documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer An index indicating which paramater to register (the first parameter is 1, the second is 2, and so on).
    sql Type
    		Integer The JDBC type code to register.
    scale
    		Integer The desired number of digits to the right of the decimal point (must be zero or greater).

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    register Out Parameter(parameterIndex, sqlType, typeName)

    For documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, String) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to retrieve (the first parameter is 1, the second is 2, and so on).
    sql Type
    		Integer A type code value.
    type Name
    		String The fully-qualified name of an SQL structured type.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    register Out Parameter(parameterName, sqlType)

    For documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to be registered.
    sql Type
    		Integer A type code value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    register Out Parameter(parameterName, sqlType, scale)

    For documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, int) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to be registered.
    sql Type
    		Integer A type code value.
    scale
    		Integer The desired number of digits to the right of the decimal point, which must be zero or greater.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    register Out Parameter(parameterName, sqlType, typeName)

    For documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to be registered.
    sql Type
    		Integer A type code value.
    type Name
    		String The fully-qualified name of an SQL structured type.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Array(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setArray(int, Array) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Array The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Big Decimal(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, BigDecimal) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Big Number The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Big Decimal(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setBigDecimal(String, BigDecimal) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Big Number The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Blob(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setBlob(int, Clob) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Blob The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Blob(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setBlob(String, Blob) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Jdbc Blob A blob that maps to an SQL BLOB value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Boolean(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Boolean The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Boolean(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setBoolean(String, boolean) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Boolean The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Byte(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setByte(int, byte) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Byte The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Byte(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setByte(String, byte) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Byte The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Bytes(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[]) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Byte[] The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Bytes(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setBytes(String, byte[]) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Byte[] The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Clob(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setClob(int, Clob) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Clob The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Clob(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setBlob(String, Clob) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Jdbc Clob A clob that maps to an SQL CLOB value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Cursor Name(name)

    For documentation of this method, see java.sql.Statement#setCursorName(String) .

    Parameters

    Name Type Description
    name
    		String The new cursor name, which must be unique within a connection.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Date(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setDate(int, Date) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Date The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Date(parameterIndex, x, timeZone)

    For documentation of this method, see java.sql.PreparedStatement#setDate(int, Date, Calendar) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Date The parameter value to set.
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Date(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setDate(String, Date) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Jdbc Date The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Date(parameterName, x, timeZone)

    For documentation of this method, see java.sql.CallableStatement#setDate(String, Date, Calendar) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Jdbc Date The parameter value to set.
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Double(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setDouble(int, double) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Number The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Double(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setDouble(String, double) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Number The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Escape Processing(enable)

    For documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean) .

    Parameters

    Name Type Description
    enable
    		Boolean If true , escape processing is enabled; otherwise it is disabled.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Fetch Direction(direction)

    For documentation of this method, see java.sql.Statement#setFetchDirection(int) .

    Parameters

    Name Type Description
    direction
    		Integer The specified direction to set, which is either Jdbc.ResultSet.FETCH_FORWARD or Jdbc.ResultSet.FETCH_REVERSE .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Fetch Size(rows)

    For documentation of this method, see java.sql.Statement#setFetchSize(int) .

    Parameters

    Name Type Description
    rows
    		Integer The number of rows to fetch.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Float(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setFloat(int, float) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Number The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Float(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setFloat(String, float) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Number The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Int(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setInt(int, int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Integer The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Int(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setInt(String, int) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Integer The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Long(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setLong(int, long) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Integer The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Long(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setLong(String, long) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Integer The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Max Field Size(max)

    For documentation of this method, see java.sql.Statement#setMaxFieldSize(int) .

    Parameters

    Name Type Description
    max
    		Integer The new column byte size limit; a value of zero indicates no limit.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Max Rows(max)

    For documentation of this method, see java.sql.Statement#setMaxRows(int) .

    Parameters

    Name Type Description
    max
    		Integer The maximum number of rows a result set generated by this statement can have. A value of 0 indicates no limit.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set NClob(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setNClob(int, NClob) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Clob The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set NClob(parameterName, value)

    For documentation of this method, see java.sql.CallableStatement#setNClob(String, NClob) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    value
    		Jdbc Clob The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set NString(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setNString(int, String) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		String The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set NString(parameterName, value)

    For documentation of this method, see java.sql.CallableStatement#setNString(String, String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    value
    		String The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Null(parameterIndex, sqlType)

    For documentation of this method, see java.sql.PreparedStatement#setNull(int, int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    sql Type
    		Integer The SQL type of the specified parameter.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Null(parameterIndex, sqlType, typeName)

    For documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    sql Type
    		Integer The SQL type of the specified parameter.
    type Name
    		String The fully-qualifed name of an SQL user-defined type. Ignored if the parameter isn't a user-defined type or REF .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Null(parameterName, sqlType)

    For documentation of this method, see java.sql.CallableStatement#setNull(String, int) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    sql Type
    		Integer The SQL type code .

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Null(parameterName, sqlType, typeName)

    For documentation of this method, see java.sql.CallableStatement#setNull(String, int, String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    sql Type
    		Integer The SQL type .
    type Name
    		String The fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL REF value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Object(index, x)

    For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object) .

    Parameters

    Name Type Description
    index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Object The object containing the value to set the parameter to.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Object(parameterIndex, x, targetSqlType)

    For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Object The object containing the value to set the parameter to.
    target Sql Type
    		Integer The SQL type to send to the database.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Object(parameterIndex, x, targetSqlType, scaleOrLength)

    For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, int) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Object The object containing the value to set the parameter to.
    target Sql Type
    		Integer The SQL type to send to the database. The scale argument may further qualify this type.
    scale Or Length
    		Integer The number of digits after the decimal for DECIMAL or NUMERIC types, or the length of data for Input Stream or Reader types. Ignored for all other types.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Object(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setObject(String, Object) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Object The object containing the value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Object(parameterName, x, targetSqlType)

    For documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Object The object containing the value to set.
    target Sql Type
    		Integer The SQL type sent to the database.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Object(parameterName, x, targetSqlType, scale)

    For documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int, int) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Object The object containing the value to set.
    target Sql Type
    		Integer The SQL type sent to the database. The scale parameter may further qualify this type.
    scale
    		Integer The number of digits after the decimal point for DECIMAL and NUMERIC types. Ignored for all other types.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Poolable(poolable)

    For documentation of this method, see java.sql.Statement#setPoolable(boolean) .

    Parameters

    Name Type Description
    poolable
    		Boolean If true , requests that this statement be pooled; otherwise requests it not be pooled.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Query Timeout(seconds)

    For documentation of this method, see java.sql.Statement#setQueryTimeout(int) .

    Parameters

    Name Type Description
    seconds
    		Integer The new query timeout in seconds; a value of 0 indicates no timeout.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Ref(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setRef(int, Ref) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Ref The SQL REF value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Row Id(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setRowId(int, RowId) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Row Id The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Row Id(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setRowId(String, RowId) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Jdbc Row Id The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set SQLXML(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, SQLXML) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc SQLXML The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set SQLXML(parameterName, xmlObject)

    For documentation of this method, see java.sql.CallableStatement#setSQLXML(String, SQLXML) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    xml Object
    		Jdbc SQLXML A SQLXML object that maps to an SQL XML value.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Short(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setShort(int, short) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Integer The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Short(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setShort(String, short) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Integer The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set String(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setString(int, String) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		String The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set String(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setString(String, String) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		String The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Time(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setTime(int, Time) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Time The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Time(parameterIndex, x, timeZone)

    For documentation of this method, see java.sql.PreparedStatement#setTime(int, Time, Calendar) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Time The parameter value to set.
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Time(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setTime(String, Time) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Jdbc Time The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Time(parameterName, x, timeZone)

    For documentation of this method, see java.sql.CallableStatement#setTime(String, Time, Calendar) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Jdbc Time The parameter value to set.
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Timestamp(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Timestamp The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Timestamp(parameterIndex, x, timeZone)

    For documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		Jdbc Timestamp The parameter value to set.
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Timestamp(parameterName, x)

    For documentation of this method, see java.sql.CallableStatement#setTimestamp(String, Timestamp) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Jdbc Timestamp The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set Timestamp(parameterName, x, timeZone)

    For documentation of this method, see java.sql.CallableStatement#setTimestamp(String, Timestamp, Calendar) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    x
    		Jdbc Timestamp The parameter value to set.
    time Zone
    		String A time zone string used to construct java.lang.Calendar instance, which in turn is used to build the date. Several formats of time zone strings are recognized: short IDs (such as PST , EST , and GMT ), long IDs (such as US/Pacific and America/Los_Angeles ), and offsets (such as GMT+6:30 ).

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set URL(parameterIndex, x)

    For documentation of this method, see java.sql.PreparedStatement#setURL(int, URL) .

    Parameters

    Name Type Description
    parameter Index
    		Integer The index of the parameter to set (the first parameter is 1, the second is 2, and so on).
    x
    		String The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    set URL(parameterName, val)

    For documentation of this method, see java.sql.CallableStatement#setURL(String, URL) .

    Parameters

    Name Type Description
    parameter Name
    		String The name of the parameter to set.
    val
    		String The parameter value to set.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request

    was Null()

    For documentation of this method, see java.sql.CallableStatement#wasNull() .

    Return

    Boolean — true if the last parameter read was null ; returns false otherwise.

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/script.external_request
    Design a Mobile Site
    View Site in Mobile | Classic
    Share by: