Not logged in : Login

About: What Does Prepare Method Do? -- Answer     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : schema:Answer, within Data Space : www.openlinksw.com associated with source document(s)
QRcode icon
http://www.openlinksw.com/describe/?url=https%3A%2F%2Fdata.openlinksw.com%2Foplweb%2Ffaq%2Fuda%2Fbd90c45a86ab9969cbc2da878868776c%23this

AttributesValues
name
  • What Does Prepare Method Do? -- Answer
category
  • ODBC
  • JDBC
  • UDA
text
  • This option is specific to the TDS Driver for MS & Sybase SQLServers, and can take the values None, Partial and Full (connectoptions -O [0, 1, 2] respectively) which are used to determines whether stored procedures are created on the server for calls to SQLPrepare. When set to Full (-O 2), stored procedures are created for every call to SQLPrepare. This setting can result in decreased performance when processing statements that do not contain parameters. When set to Partial (-O 1) (the initial default), the driver creates stored procedures only if the statement contains parameters. Otherwise, the statement is cached and run directly at the time of SQLExecute. When set to None (-O 0), stored procedures are never created. The driver caches the statement, executes it directly at the time of SQLExecute, and reports any syntax or similar errors at the time of SQLExecute.
type
is acceptedAnswer of
Faceted Search & Find service v1.17_git110 as of Apr 06 2022


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3322 as of Apr 19 2022, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory, 2 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2022 OpenLink Software