Index by: file name | procedure name | procedure call | annotation

## sqlrcurCmd.tcl Annotations

Created from `../../../src/api/tcl/sqlrcurCmd.tcl`

Procedure Summary
`affectedRows { }` Returns the number of rows that were updated inserted or deleted by the query.
`cacheOff { }` Sets query caching
`cacheToFile { filename }` Sets query caching on.
`clearBinds { }` Clears all bind
`colCount { }` Returns the number of columns in the current result
`countBindVariables { }` Parses the previously prepared query counts the number of bind variables defined in it and returns that
`defineOutputBindBlob { variable }` Defines a binary lob output bind
`defineOutputBindClob { variable }` Defines a character lob output bind
`defineOutputBindCursor { variable }` Defines a cursor output bind
`defineOutputBindDouble { variable }` Defines a decimal output bind
`defineOutputBindInteger { variable }` Defines an integer output bind
`defineOutputBindString { variable bufferlength }` Defines an output bind variable.
`dontGetColumnInfo { }` Tells the server not to send any column info {names types sizes}.
`endOfResultSet { }` Returns false if part of the result set is still pending on the server and true if not.
`errorMessage { }` If a query failed and generated an error the error message is available here.
`executeQuery { }` Execute the query that was previously prepared and
`fetchFromBindCursor { }` Fetch from a cursor that was returned as an output bind
`firstRowIndex { }` Returns the index of the first buffered row.
`getCacheFileName { }` Returns the name of the file containing the cached result
`getColumnInfo { }` Tells the server to send column
`getColumnIsAutoIncrementByIndex { col }` Returns true if the specified column auto-increments and false
`getColumnIsAutoIncrementByName { col }` Returns true if the specified column auto-increments and false
`getColumnIsBinaryByIndex { col }` Returns true if the specified column contains binary data and false
`getColumnIsBinaryByName { col }` Returns true if the specified column contains binary data and false
`getColumnIsNullableByIndex { col }` Returns true if the specified column can contain nulls and false
`getColumnIsNullableByName { col }` Returns true if the specified column can contain nulls and false
`getColumnIsPartOfKeyByIndex { col }` Returns true if the specified column is part of a composite key and false
`getColumnIsPartOfKeyByName { col }` Returns true if the specified column is part of a composite key and false
`getColumnIsPrimaryKeyByIndex { col }` Returns true if the specified column is a primary key and false
`getColumnIsPrimaryKeyByName { col }` Returns true if the specified column is a primary key and false
`getColumnIsUniqueByIndex { col }` Returns true if the specified column is unique and false
`getColumnIsUniqueByName { col }` Returns true if the specified column is unique and false
`getColumnIsUnsignedByIndex { col }` Returns true if the specified column is an unsigned number and false
`getColumnIsUnsignedByName { col }` Returns true if the specified column is an unsigned number and false
`getColumnIsZeroFilledByIndex { col }` Returns true if the specified column was created with the zero-fill flag and false
`getColumnIsZeroFilledByName { col }` Returns true if the specified column was created with the zero-fill flag and false
`getColumnLengthByIndex { col }` Returns the number of bytes required on the server to store the data for the specified
`getColumnLengthByName { col }` Returns the number of bytes required on the server to store the data for the specified
`getColumnList { table wild }` Sends a query that returns a list of columns in the table specified by the "table" parameter matching "wild".
`getColumnName { col }` Returns the name of the specified
`getColumnNameByIndex { col }` Returns the name of the specified
`getColumnNames { }` Returns a null terminated array of the column names of the current result
`getColumnPrecisionByIndex { col }` Returns the precision of the specified column.
`getColumnPrecisionByName { col }` Returns the precision of the specified column.
`getColumnScaleByIndex { col }` Returns the scale of the specified column.
`getColumnScaleByName { col }` Returns the scale of the specified column.
`getColumnTypeByIndex { col }` Returns the type of the specified
`getColumnTypeByName { col }` Returns the type of the specified
`getColumnTypeByName { col }` Returns the type of the specified
`getDatabaseList { wild }` Sends a query that returns a list of databases/schemas matching "wild".
`getFieldAsDoubleByIndex { row col }` Returns the specified field as a
`getFieldAsDoubleByName { row col }` Returns the specified field as a
`getFieldAsIntegerByIndex { row col }` Returns the specified field as an
`getFieldAsIntegerByName { row col }` Returns the specified field as an
`getFieldByIndex { row col }` Returns the specified field as a
`getFieldByName { row col }` Returns the specified field as a
`getFieldLengthByIndex { row col }` Returns the length of the specified
`getFieldLengthByName { row col }` Returns the length of the specified
`getLongestByIndex { col }` Returns the length of the longest field in the specified
`getLongestByName { col }` Returns the length of the longest field in the specified
`getOutputBindBlob { variable }` Get the value stored in a previously defined binary lob output bind
`getOutputBindClob { variable }` Get the value stored in a previously defined character lob output bind
`getOutputBindCursor { variable }` Get the cursor associated with a previously defined output bind
`getOutputBindDouble { variable }` Get the value stored in a previously defined decimal output bind
`getOutputBindInteger { variable }` Get the value stored in a previously defined integer output bind
`getOutputBindLength { variable }` Get the length of the value stored in a previously defined output bind
`getOutputBindString { variable }` Get the value stored in a previously defined string output bind
`getResultSetBufferSize { }` Returns the number of result set rows that will be buffered at a time or 0 for the entire result
`getResultSetId { }` Returns the internal ID of this result set.
`getRow { row }` Returns a null terminated array of the values of the fields in the specified
`getRowLengths { row }` Returns a null terminated array of the lengths of the fields in the specified
`getTableList { wild }` Sends a query that returns a list of tables matching "wild".
`inputBind { variable value precision scale }` Defines a input bind variable.
`inputBindBlob { variable value size }` Defines a binary lob input bind
`inputBindClob { variable value size }` Defines a character lob input bind
`inputBinds { variables values precisions scales }` Defines an array of input bind
`lowerCaseColumnNames { }` Columns names are converted to lower
`mixedCaseColumnNames { }` Columns names are returned in the same case as they are defined in the database.
`openCachedResultSet { filename }` Opens a cached result set.
`prepareFileQuery { path filename }` Prepare to execute the contents of "path"/"filename".
`prepareQuery { query length }` Prepare to execute "query" with length "length".
`prepareQuery { query length }` Prepare to execute "query" with length "length".
`resumeCachedResultSet { id filename }` Resumes a result set previously left open using suspendSession and continues caching the result set to "filename".
`resumeResultSet { id }` Resumes a result set previously left open using suspendSession.
`rowCount { }` Returns the number of rows in the current result set {if the result set is being stepped through this returns the number of rows processed so
`sendFileQuery { path filename }` Sends the query in file "path"/"filename" directly and gets a result
`sendQuery { query length }` Sends "query" with length "length" directly and gets a result set.
`sendQuery { query length }` Sends "query" with length "length" directly and gets a result set.
`setCacheTtl { ttl }` Sets the time-to-live for cached result sets.
`setResultSetBufferSize { rows }` Sets the number of rows of the result set to buffer at a time.
`sqlrcurCmd { sqlrc }` Creates a cursor to run queries and fetch result sets using connecton
`sqlrcurDelete { }` Destroys the cursor and cleans up all assocuated result set
`substitution { variable value precision scale }` Defines a substitution
`substitutions { variables values precisions scales }` Defines an array of substitution
`suspendResultSet { }` Tells the server to leave this result set open when the connection calls suspendSession so that another connection can connect to it using resumeResultSet after it calls
`totalRows { }` Returns the total number of rows that will be returned in the result set.
`upperCaseColumnNames { }` Columns names are converted to upper
`validateBinds { }` If you are binding to any variables that might not actually be in your query call this to ensure that the database won't try to bind them unless they really are in the query.
`validBind { variable }` Returns true if "variable" was a valid bind variable of the

Procedure Detail

### affectedRows

    proc affectedRows {  }

  Returns the number of rows that were updated inserted or deleted by the query. Not all databases support this call. Don't use it for applications which are designed to be portable across databases. 0 is returned by databases which don't support this option.
  Defined in:
    sqlrcurCmd.tcl, line 265

### cacheOff

    proc cacheOff {  }

  Sets query caching off.
  Defined in:
    sqlrcurCmd.tcl, line 72

### cacheToFile

    proc cacheToFile { filename }

  Sets query caching on. Future queries will be cached to the file "filename". A default time-to-live of 10 minutes is also set. Note that once cacheToFile is called the result sets of all future queries will be cached to that file until another call to cacheToFile changes which file to cache to or a call to cacheOff turns off caching.
  Defined in:
    sqlrcurCmd.tcl, line 58

### clearBinds

    proc clearBinds {  }

  Clears all bind variables.
  Defined in:
    sqlrcurCmd.tcl, line 173

### colCount

    proc colCount {  }

  Returns the number of columns in the current result set.
  Defined in:
    sqlrcurCmd.tcl, line 242

### countBindVariables

    proc countBindVariables {  }

  Parses the previously prepared query counts the number of bind variables defined in it and returns that number.
  Defined in:
    sqlrcurCmd.tcl, line 178

### defineOutputBindBlob

    proc defineOutputBindBlob { variable }

  Defines a binary lob output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 162

### defineOutputBindClob

    proc defineOutputBindClob { variable }

  Defines a character lob output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 165

### defineOutputBindCursor

    proc defineOutputBindCursor { variable }

  Defines a cursor output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 168

### defineOutputBindDouble

    proc defineOutputBindDouble { variable }

  Defines a decimal output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 159

### defineOutputBindInteger

    proc defineOutputBindInteger { variable }

  Defines an integer output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 156

### defineOutputBindString

    proc defineOutputBindString { variable bufferlength }

  Defines an output bind variable. "bufferlength" bytes will be reserved to store the value.
  Defined in:
    sqlrcurCmd.tcl, line 153

### dontGetColumnInfo

    proc dontGetColumnInfo {  }

  Tells the server not to send any column info {names types sizes}. If you don't need that info you should call this method to improve performance.
  Defined in:
    sqlrcurCmd.tcl, line 27

### endOfResultSet

    proc endOfResultSet {  }

  Returns false if part of the result set is still pending on the server and true if not. This method can only return false if setResultSetBufferSize {} has been called with a parameter other than 0.
  Defined in:
    sqlrcurCmd.tcl, line 277

### errorMessage

    proc errorMessage {  }

  If a query failed and generated an error the error message is available here. If the query succeeded then this method returns NULL.
  Defined in:
    sqlrcurCmd.tcl, line 285

### executeQuery

    proc executeQuery {  }

  Execute the query that was previously prepared and bound.
  Defined in:
    sqlrcurCmd.tcl, line 196

### fetchFromBindCursor

    proc fetchFromBindCursor {  }

  Fetch from a cursor that was returned as an output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 200

### firstRowIndex

    proc firstRowIndex {  }

  Returns the index of the first buffered row. This is useful when buffering only part of the result set at a time.
  Defined in:
    sqlrcurCmd.tcl, line 270

### getCacheFileName

    proc getCacheFileName {  }

  Returns the name of the file containing the cached result set.
  Defined in:
    sqlrcurCmd.tcl, line 69

### getColumnInfo

    proc getColumnInfo {  }

  Tells the server to send column info.
  Defined in:
    sqlrcurCmd.tcl, line 30

### getColumnIsAutoIncrementByIndex

    proc getColumnIsAutoIncrementByIndex { col }

  Returns true if the specified column auto-increments and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 442

### getColumnIsAutoIncrementByName

    proc getColumnIsAutoIncrementByName { col }

  Returns true if the specified column auto-increments and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 446

### getColumnIsBinaryByIndex

    proc getColumnIsBinaryByIndex { col }

  Returns true if the specified column contains binary data and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 433

### getColumnIsBinaryByName

    proc getColumnIsBinaryByName { col }

  Returns true if the specified column contains binary data and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 438

### getColumnIsNullableByIndex

    proc getColumnIsNullableByIndex { col }

  Returns true if the specified column can contain nulls and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 382

### getColumnIsNullableByName

    proc getColumnIsNullableByName { col }

  Returns true if the specified column can contain nulls and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 386

### getColumnIsPartOfKeyByIndex

    proc getColumnIsPartOfKeyByIndex { col }

  Returns true if the specified column is part of a composite key and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 406

### getColumnIsPartOfKeyByName

    proc getColumnIsPartOfKeyByName { col }

  Returns true if the specified column is part of a composite key and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 410

### getColumnIsPrimaryKeyByIndex

    proc getColumnIsPrimaryKeyByIndex { col }

  Returns true if the specified column is a primary key and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 390

### getColumnIsPrimaryKeyByName

    proc getColumnIsPrimaryKeyByName { col }

  Returns true if the specified column is a primary key and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 394

### getColumnIsUniqueByIndex

    proc getColumnIsUniqueByIndex { col }

  Returns true if the specified column is unique and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 398

### getColumnIsUniqueByName

    proc getColumnIsUniqueByName { col }

  Returns true if the specified column is unique and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 402

### getColumnIsUnsignedByIndex

    proc getColumnIsUnsignedByIndex { col }

  Returns true if the specified column is an unsigned number and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 414

### getColumnIsUnsignedByName

    proc getColumnIsUnsignedByName { col }

  Returns true if the specified column is an unsigned number and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 418

### getColumnIsZeroFilledByIndex

    proc getColumnIsZeroFilledByIndex { col }

  Returns true if the specified column was created with the zero-fill flag and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 423

### getColumnIsZeroFilledByName

    proc getColumnIsZeroFilledByName { col }

  Returns true if the specified column was created with the zero-fill flag and false otherwise.
  Defined in:
    sqlrcurCmd.tcl, line 428

### getColumnLengthByIndex

    proc getColumnLengthByIndex { col }

  Returns the number of bytes required on the server to store the data for the specified column
  Defined in:
    sqlrcurCmd.tcl, line 346

### getColumnLengthByName

    proc getColumnLengthByName { col }

  Returns the number of bytes required on the server to store the data for the specified column
  Defined in:
    sqlrcurCmd.tcl, line 350

### getColumnList

    proc getColumnList { table wild }

  Sends a query that returns a list of columns in the table specified by the "table" parameter matching "wild". If wild is empty or NULL then a list of all columns will be returned.
  Defined in:
    sqlrcurCmd.tcl, line 91

### getColumnName

    proc getColumnName { col }

  Returns the name of the specified column.
  Defined in:
    sqlrcurCmd.tcl, line 330

### getColumnNameByIndex

    proc getColumnNameByIndex { col }

  Returns the name of the specified column.
  Defined in:
    sqlrcurCmd.tcl, line 333

### getColumnNames

    proc getColumnNames {  }

  Returns a null terminated array of the column names of the current result set.
  Defined in:
    sqlrcurCmd.tcl, line 327

### getColumnPrecisionByIndex

    proc getColumnPrecisionByIndex { col }

  Returns the precision of the specified column. Precision is the total number of digits in a number. eg: 123.45 has a precision of 5. For non-numeric types it's the number of characters in the string.
  Defined in:
    sqlrcurCmd.tcl, line 358

### getColumnPrecisionByName

    proc getColumnPrecisionByName { col }

  Returns the precision of the specified column. Precision is the total number of digits in a number. eg: 123.45 has a precision of 5. For non-numeric types it's the number of characters in the string.
  Defined in:
    sqlrcurCmd.tcl, line 366

### getColumnScaleByIndex

    proc getColumnScaleByIndex { col }

  Returns the scale of the specified column. Scale is the total number of digits to the right of the decimal point in a number. eg: 123.45 has a scale of 2.
  Defined in:
    sqlrcurCmd.tcl, line 372

### getColumnScaleByName

    proc getColumnScaleByName { col }

  Returns the scale of the specified column. Scale is the total number of digits to the right of the decimal point in a number. eg: 123.45 has a scale of 2.
  Defined in:
    sqlrcurCmd.tcl, line 378

### getColumnTypeByIndex

    proc getColumnTypeByIndex { col }

  Returns the type of the specified column.
  Defined in:
    sqlrcurCmd.tcl, line 339

### getColumnTypeByName

    proc getColumnTypeByName { col }

  Returns the type of the specified column.
  Defined in:
    sqlrcurCmd.tcl, line 342

### getColumnTypeByName

    proc getColumnTypeByName { col }

  Returns the type of the specified column.
  Defined in:
    sqlrcurCmd.tcl, line 342

### getDatabaseList

    proc getDatabaseList { wild }

  Sends a query that returns a list of databases/schemas matching "wild". If wild is empty or NULL then a list of all databases/schemas will be returned.
  Defined in:
    sqlrcurCmd.tcl, line 80

### getFieldAsDoubleByIndex

    proc getFieldAsDoubleByIndex { row col }

  Returns the specified field as a decimal.
  Defined in:
    sqlrcurCmd.tcl, line 302

### getFieldAsDoubleByName

    proc getFieldAsDoubleByName { row col }

  Returns the specified field as a decimal.
  Defined in:
    sqlrcurCmd.tcl, line 305

### getFieldAsIntegerByIndex

    proc getFieldAsIntegerByIndex { row col }

  Returns the specified field as an integer.
  Defined in:
    sqlrcurCmd.tcl, line 296

### getFieldAsIntegerByName

    proc getFieldAsIntegerByName { row col }

  Returns the specified field as an integer.
  Defined in:
    sqlrcurCmd.tcl, line 299

### getFieldByIndex

    proc getFieldByIndex { row col }

  Returns the specified field as a string.
  Defined in:
    sqlrcurCmd.tcl, line 290

### getFieldByName

    proc getFieldByName { row col }

  Returns the specified field as a string
  Defined in:
    sqlrcurCmd.tcl, line 293

### getFieldLengthByIndex

    proc getFieldLengthByIndex { row col }

  Returns the length of the specified field.
  Defined in:
    sqlrcurCmd.tcl, line 310

### getFieldLengthByName

    proc getFieldLengthByName { row col }

  Returns the length of the specified field.
  Defined in:
    sqlrcurCmd.tcl, line 313

### getLongestByIndex

    proc getLongestByIndex { col }

  Returns the length of the longest field in the specified column.
  Defined in:
    sqlrcurCmd.tcl, line 450

### getLongestByName

    proc getLongestByName { col }

  Returns the length of the longest field in the specified column.
  Defined in:
    sqlrcurCmd.tcl, line 454

### getOutputBindBlob

    proc getOutputBindBlob { variable }

  Get the value stored in a previously defined binary lob output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 218

### getOutputBindClob

    proc getOutputBindClob { variable }

  Get the value stored in a previously defined character lob output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 222

### getOutputBindCursor

    proc getOutputBindCursor { variable }

  Get the cursor associated with a previously defined output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 230

### getOutputBindDouble

    proc getOutputBindDouble { variable }

  Get the value stored in a previously defined decimal output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 214

### getOutputBindInteger

    proc getOutputBindInteger { variable }

  Get the value stored in a previously defined integer output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 210

### getOutputBindLength

    proc getOutputBindLength { variable }

  Get the length of the value stored in a previously defined output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 226

### getOutputBindString

    proc getOutputBindString { variable }

  Get the value stored in a previously defined string output bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 206

### getResultSetBufferSize

    proc getResultSetBufferSize {  }

  Returns the number of result set rows that will be buffered at a time or 0 for the entire result set.
  Defined in:
    sqlrcurCmd.tcl, line 19

### getResultSetId

    proc getResultSetId {  }

  Returns the internal ID of this result set. This parameter may be passed to another cursor for use in the resumeResultSet method. Note: The value this method returns is only valid after a call to suspendResultSet.
  Defined in:
    sqlrcurCmd.tcl, line 471

### getRow

    proc getRow { row }

  Returns a null terminated array of the values of the fields in the specified row.
  Defined in:
    sqlrcurCmd.tcl, line 319

### getRowLengths

    proc getRowLengths { row }

  Returns a null terminated array of the lengths of the fields in the specified row.
  Defined in:
    sqlrcurCmd.tcl, line 323

### getTableList

    proc getTableList { wild }

  Sends a query that returns a list of tables matching "wild". If wild is empty or NULL then a list of all tables will be returned.
  Defined in:
    sqlrcurCmd.tcl, line 85

### inputBind

    proc inputBind { variable value precision scale }

  Defines a input bind variable. The value may be a string, integer or decimal. If the value is a decimal, then precision and scale may also be specified. If you don't have the precision and scale then set them both to 0. However in that case you may get unexpected rounding behavior if the server is faking binds.
  Defined in:
    sqlrcurCmd.tcl, line 137

### inputBindBlob

    proc inputBindBlob { variable value size }

  Defines a binary lob input bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 140

### inputBindClob

    proc inputBindClob { variable value size }

  Defines a character lob input bind variable.
  Defined in:
    sqlrcurCmd.tcl, line 143

### inputBinds

    proc inputBinds { variables values precisions scales }

  Defines an array of input bind variables.
  Defined in:
    sqlrcurCmd.tcl, line 146

### lowerCaseColumnNames

    proc lowerCaseColumnNames {  }

  Columns names are converted to lower case.
  Defined in:
    sqlrcurCmd.tcl, line 42

### mixedCaseColumnNames

    proc mixedCaseColumnNames {  }

  Columns names are returned in the same case as they are defined in the database. This is the default.
  Defined in:
    sqlrcurCmd.tcl, line 36

### openCachedResultSet

    proc openCachedResultSet { filename }

  Opens a cached result set. Returns true on success and false on failure.
  Defined in:
    sqlrcurCmd.tcl, line 236

### prepareFileQuery

    proc prepareFileQuery { path filename }

  Prepare to execute the contents of "path"/"filename". Returns false if the // file couldn't be opened.
  Defined in:
    sqlrcurCmd.tcl, line 120

### prepareQuery

    proc prepareQuery { query length }

  Prepare to execute "query" with length "length". This method must be used if the query contains binary data.
  Defined in:
    sqlrcurCmd.tcl, line 115

### prepareQuery

    proc prepareQuery { query length }

  Prepare to execute "query" with length "length". This method must be used if the query contains binary data.
  Defined in:
    sqlrcurCmd.tcl, line 115

### resumeCachedResultSet

    proc resumeCachedResultSet { id filename }

  Resumes a result set previously left open using suspendSession and continues caching the result set to "filename". Returns true on success and false on failure.
  Defined in:
    sqlrcurCmd.tcl, line 482

### resumeResultSet

    proc resumeResultSet { id }

  Resumes a result set previously left open using suspendSession. Returns true on success and false on failure.
  Defined in:
    sqlrcurCmd.tcl, line 476

### rowCount

    proc rowCount {  }

  Returns the number of rows in the current result set {if the result set is being stepped through this returns the number of rows processed so far}.
  Defined in:
    sqlrcurCmd.tcl, line 248

### sendFileQuery

    proc sendFileQuery { path filename }

  Sends the query in file "path"/"filename" directly and gets a result set.
  Defined in:
    sqlrcurCmd.tcl, line 105

### sendQuery

    proc sendQuery { query length }

  Sends "query" with length "length" directly and gets a result set. This method must be used if the query contains binary data.
  Defined in:
    sqlrcurCmd.tcl, line 101

### sendQuery

    proc sendQuery { query length }

  Sends "query" with length "length" directly and gets a result set. This method must be used if the query contains binary data.
  Defined in:
    sqlrcurCmd.tcl, line 101

### setCacheTtl

    proc setCacheTtl { ttl }

  Sets the time-to-live for cached result sets. The sqlr-cachemanger will remove each cached result set "ttl" seconds after it's created provided it's scanning the directory containing the cache files.
  Defined in:
    sqlrcurCmd.tcl, line 65

### setResultSetBufferSize

    proc setResultSetBufferSize { rows }

  Sets the number of rows of the result set to buffer at a time. 0 {the default} means buffer the entire result set.
  Defined in:
    sqlrcurCmd.tcl, line 14

### sqlrcurCmd

    proc sqlrcurCmd { sqlrc }

  Creates a cursor to run queries and fetch result sets using connecton "sqlrc".
  Defined in:
    sqlrcurCmd.tcl, line 3

### sqlrcurDelete

    proc sqlrcurDelete {  }

  Destroys the cursor and cleans up all assocuated result set data.
  Defined in:
    sqlrcurCmd.tcl, line 7

### substitution

    proc substitution { variable value precision scale }

  Defines a substitution variable.
  Defined in:
    sqlrcurCmd.tcl, line 125

### substitutions

    proc substitutions { variables values precisions scales }

  Defines an array of substitution variables.
  Defined in:
    sqlrcurCmd.tcl, line 128

### suspendResultSet

    proc suspendResultSet {  }

  Tells the server to leave this result set open when the connection calls suspendSession so that another connection can connect to it using resumeResultSet after it calls resumeSession.
  Defined in:
    sqlrcurCmd.tcl, line 463

### totalRows

    proc totalRows {  }

  Returns the total number of rows that will be returned in the result set. Not all databases support this call. Don't use it for applications which are designed to be portable across databases. 0 is returned by databases which don't support this option.
  Defined in:
    sqlrcurCmd.tcl, line 256

### upperCaseColumnNames

    proc upperCaseColumnNames {  }

  Columns names are converted to upper case.
  Defined in:
    sqlrcurCmd.tcl, line 39

### validateBinds

    proc validateBinds {  }

  If you are binding to any variables that might not actually be in your query call this to ensure that the database won't try to bind them unless they really are in the query. There is a performance penalty for calling this method.
  Defined in:
    sqlrcurCmd.tcl, line 186

### validBind

    proc validBind { variable }

  Returns true if "variable" was a valid bind variable of the query.
  Defined in:
    sqlrcurCmd.tcl, line 190

Index by: file name | procedure name | procedure call | annotation
File generated 2012-01-10 at 06:42.