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
closeResultSet { }
          Closes the current result set, if one is open.
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.
errorNumber { }
          If a query failed and generated an error, the error number 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 }
          Sends "query" directly and gets a result
sendQueryWithLength { 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 associated 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 268

cacheOff

proc cacheOff {  }
Sets query caching off.
Defined in:
sqlrcurCmd.tcl, line 75

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 61

clearBinds

proc clearBinds {  }
Clears all bind variables.
Defined in:
sqlrcurCmd.tcl, line 176

closeResultSet

proc closeResultSet {  }
Closes the current result set, if one is open. Data that has been fetched already is still available but no more data may be fetched. Server side resources for the result set are freed as well.
Defined in:
sqlrcurCmd.tcl, line 499

colCount

proc colCount {  }
Returns the number of columns in the current result set.
Defined in:
sqlrcurCmd.tcl, line 245

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 181

defineOutputBindBlob

proc defineOutputBindBlob { variable }
Defines a binary lob output bind variable.
Defined in:
sqlrcurCmd.tcl, line 165

defineOutputBindClob

proc defineOutputBindClob { variable }
Defines a character lob output bind variable.
Defined in:
sqlrcurCmd.tcl, line 168

defineOutputBindCursor

proc defineOutputBindCursor { variable }
Defines a cursor output bind variable.
Defined in:
sqlrcurCmd.tcl, line 171

defineOutputBindDouble

proc defineOutputBindDouble { variable }
Defines a decimal output bind variable.
Defined in:
sqlrcurCmd.tcl, line 162

defineOutputBindInteger

proc defineOutputBindInteger { variable }
Defines an integer output bind variable.
Defined in:
sqlrcurCmd.tcl, line 159

defineOutputBindString

proc defineOutputBindString { variable bufferlength }
Defines an output bind variable. "bufferlength" bytes will be reserved to store the value.
Defined in:
sqlrcurCmd.tcl, line 156

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 30

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 280

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 288

errorNumber

proc errorNumber {  }
If a query failed and generated an error, the error number is available here. If there is no error then this method returns 0.
Defined in:
sqlrcurCmd.tcl, line 296

executeQuery

proc executeQuery {  }
Execute the query that was previously prepared and bound.
Defined in:
sqlrcurCmd.tcl, line 199

fetchFromBindCursor

proc fetchFromBindCursor {  }
Fetch from a cursor that was returned as an output bind variable.
Defined in:
sqlrcurCmd.tcl, line 203

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 273

getCacheFileName

proc getCacheFileName {  }
Returns the name of the file containing the cached result set.
Defined in:
sqlrcurCmd.tcl, line 72

getColumnInfo

proc getColumnInfo {  }
Tells the server to send column info.
Defined in:
sqlrcurCmd.tcl, line 33

getColumnIsAutoIncrementByIndex

proc getColumnIsAutoIncrementByIndex { col }
Returns true if the specified column auto-increments and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 453

getColumnIsAutoIncrementByName

proc getColumnIsAutoIncrementByName { col }
Returns true if the specified column auto-increments and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 457

getColumnIsBinaryByIndex

proc getColumnIsBinaryByIndex { col }
Returns true if the specified column contains binary data and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 444

getColumnIsBinaryByName

proc getColumnIsBinaryByName { col }
Returns true if the specified column contains binary data and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 449

getColumnIsNullableByIndex

proc getColumnIsNullableByIndex { col }
Returns true if the specified column can contain nulls and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 393

getColumnIsNullableByName

proc getColumnIsNullableByName { col }
Returns true if the specified column can contain nulls and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 397

getColumnIsPartOfKeyByIndex

proc getColumnIsPartOfKeyByIndex { col }
Returns true if the specified column is part of a composite key and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 417

getColumnIsPartOfKeyByName

proc getColumnIsPartOfKeyByName { col }
Returns true if the specified column is part of a composite key and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 421

getColumnIsPrimaryKeyByIndex

proc getColumnIsPrimaryKeyByIndex { col }
Returns true if the specified column is a primary key and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 401

getColumnIsPrimaryKeyByName

proc getColumnIsPrimaryKeyByName { col }
Returns true if the specified column is a primary key and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 405

getColumnIsUniqueByIndex

proc getColumnIsUniqueByIndex { col }
Returns true if the specified column is unique and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 409

getColumnIsUniqueByName

proc getColumnIsUniqueByName { col }
Returns true if the specified column is unique and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 413

getColumnIsUnsignedByIndex

proc getColumnIsUnsignedByIndex { col }
Returns true if the specified column is an unsigned number and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 425

getColumnIsUnsignedByName

proc getColumnIsUnsignedByName { col }
Returns true if the specified column is an unsigned number and false otherwise.
Defined in:
sqlrcurCmd.tcl, line 429

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 434

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 439

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 357

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 361

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 94

getColumnName

proc getColumnName { col }
Returns the name of the specified column.
Defined in:
sqlrcurCmd.tcl, line 341

getColumnNameByIndex

proc getColumnNameByIndex { col }
Returns the name of the specified column.
Defined in:
sqlrcurCmd.tcl, line 344

getColumnNames

proc getColumnNames {  }
Returns a null terminated array of the column names of the current result set.
Defined in:
sqlrcurCmd.tcl, line 338

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 369

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 377

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 383

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 389

getColumnTypeByIndex

proc getColumnTypeByIndex { col }
Returns the type of the specified column.
Defined in:
sqlrcurCmd.tcl, line 350

getColumnTypeByName

proc getColumnTypeByName { col }
Returns the type of the specified column.
Defined in:
sqlrcurCmd.tcl, line 353

getColumnTypeByName

proc getColumnTypeByName { col }
Returns the type of the specified column.
Defined in:
sqlrcurCmd.tcl, line 353

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 83

getFieldAsDoubleByIndex

proc getFieldAsDoubleByIndex { row col }
Returns the specified field as a decimal.
Defined in:
sqlrcurCmd.tcl, line 313

getFieldAsDoubleByName

proc getFieldAsDoubleByName { row col }
Returns the specified field as a decimal.
Defined in:
sqlrcurCmd.tcl, line 316

getFieldAsIntegerByIndex

proc getFieldAsIntegerByIndex { row col }
Returns the specified field as an integer.
Defined in:
sqlrcurCmd.tcl, line 307

getFieldAsIntegerByName

proc getFieldAsIntegerByName { row col }
Returns the specified field as an integer.
Defined in:
sqlrcurCmd.tcl, line 310

getFieldByIndex

proc getFieldByIndex { row col }
Returns the specified field as a string.
Defined in:
sqlrcurCmd.tcl, line 301

getFieldByName

proc getFieldByName { row col }
Returns the specified field as a string
Defined in:
sqlrcurCmd.tcl, line 304

getFieldLengthByIndex

proc getFieldLengthByIndex { row col }
Returns the length of the specified field.
Defined in:
sqlrcurCmd.tcl, line 321

getFieldLengthByName

proc getFieldLengthByName { row col }
Returns the length of the specified field.
Defined in:
sqlrcurCmd.tcl, line 324

getLongestByIndex

proc getLongestByIndex { col }
Returns the length of the longest field in the specified column.
Defined in:
sqlrcurCmd.tcl, line 461

getLongestByName

proc getLongestByName { col }
Returns the length of the longest field in the specified column.
Defined in:
sqlrcurCmd.tcl, line 465

getOutputBindBlob

proc getOutputBindBlob { variable }
Get the value stored in a previously defined binary lob output bind variable.
Defined in:
sqlrcurCmd.tcl, line 221

getOutputBindClob

proc getOutputBindClob { variable }
Get the value stored in a previously defined character lob output bind variable.
Defined in:
sqlrcurCmd.tcl, line 225

getOutputBindCursor

proc getOutputBindCursor { variable }
Get the cursor associated with a previously defined output bind variable.
Defined in:
sqlrcurCmd.tcl, line 233

getOutputBindDouble

proc getOutputBindDouble { variable }
Get the value stored in a previously defined decimal output bind variable.
Defined in:
sqlrcurCmd.tcl, line 217

getOutputBindInteger

proc getOutputBindInteger { variable }
Get the value stored in a previously defined integer output bind variable.
Defined in:
sqlrcurCmd.tcl, line 213

getOutputBindLength

proc getOutputBindLength { variable }
Get the length of the value stored in a previously defined output bind variable.
Defined in:
sqlrcurCmd.tcl, line 229

getOutputBindString

proc getOutputBindString { variable }
Get the value stored in a previously defined string output bind variable.
Defined in:
sqlrcurCmd.tcl, line 209

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 22

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 482

getRow

proc getRow { row }
Returns a null terminated array of the values of the fields in the specified row.
Defined in:
sqlrcurCmd.tcl, line 330

getRowLengths

proc getRowLengths { row }
Returns a null terminated array of the lengths of the fields in the specified row.
Defined in:
sqlrcurCmd.tcl, line 334

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 88

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 140

inputBindBlob

proc inputBindBlob { variable value size }
Defines a binary lob input bind variable.
Defined in:
sqlrcurCmd.tcl, line 143

inputBindClob

proc inputBindClob { variable value size }
Defines a character lob input bind variable.
Defined in:
sqlrcurCmd.tcl, line 146

inputBinds

proc inputBinds { variables values precisions scales }
Defines an array of input bind variables.
Defined in:
sqlrcurCmd.tcl, line 149

lowerCaseColumnNames

proc lowerCaseColumnNames {  }
Columns names are converted to lower case.
Defined in:
sqlrcurCmd.tcl, line 45

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 39

openCachedResultSet

proc openCachedResultSet { filename }
Opens a cached result set. Returns true on success and false on failure.
Defined in:
sqlrcurCmd.tcl, line 239

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 123

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 118

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 118

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 493

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 487

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 251

sendFileQuery

proc sendFileQuery { path filename }
Sends the query in file "path"/"filename" directly and gets a result set.
Defined in:
sqlrcurCmd.tcl, line 108

sendQuery

proc sendQuery { query }
Sends "query" directly and gets a result set.
Defined in:
sqlrcurCmd.tcl, line 99

sendQueryWithLength

proc sendQueryWithLength { 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 104

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 68

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 17

sqlrcurCmd

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

sqlrcurDelete

proc sqlrcurDelete {  }
Destroys the cursor and cleans up all associated result set data.
Defined in:
sqlrcurCmd.tcl, line 10

substitution

proc substitution { variable value precision scale }
Defines a substitution variable.
Defined in:
sqlrcurCmd.tcl, line 128

substitutions

proc substitutions { variables values precisions scales }
Defines an array of substitution variables.
Defined in:
sqlrcurCmd.tcl, line 131

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 474

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 259

upperCaseColumnNames

proc upperCaseColumnNames {  }
Columns names are converted to upper case.
Defined in:
sqlrcurCmd.tcl, line 42

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 189

validBind

proc validBind { variable }
Returns true if "variable" was a valid bind variable of the query.
Defined in:
sqlrcurCmd.tcl, line 193

Index by: file name | procedure name | procedure call | annotation
File generated 2016-03-15 at 02:51.