Database parameters

PBUseProcOwner – PB Docs 125

PBUseProcOwner database parameter Description When you access a database through the ODBC interface and define a DataWindow object that uses a stored procedure as its data source, PBUseProcOwner specifies whether PowerBuilder should qualify the stored procedure with the owner name in the SQL EXECUTE statement passed to the driver. PowerBuilder qualifies the stored procedure with…

BindSPInput – PB Docs 125

BindSPInput database parameter Description Specifies that PowerBuilder bind input parameters in dynamic SQL statements when executing a stored procedure. Controls ADO.NET O90 Oracle9i O10 Oracle 10g SNC SQL Native Client for Microsoft SQL Server Syntax

Parameter Description value Specifies whether you want to bind input parameters in dynamic SQL statements when executing stored procedures….

BinTxtBlob – PB Docs 125

BinTxtBlob database parameter Description Specifies that binary data or an ANSI string is to be submitted to or retrieved from a text column with UPDATEBLOB or SELECTBLOB. Controls ASE, SYC Sybase Adaptive Server Enterprise I10 Informix IN9 Informix OLE DB O90 Oracle9i O10 Oracle 10g ORA Oracle 11g SNC SQL Native Client for Microsoft SQL…

NCharBind – PB Docs 125

NCharBind database parameter Description Specifies whether PowerBuilder binds input string parameters to the Char or NChar datatype. Controls ADO.NET (Oracle.DataAccess.Client only) O90 Oracle9i O10 Oracle 10g ORA Oracle 11g SNC SQL Native Client for Microsoft SQL Server Syntax

Parameter Description value Specifies whether PowerBuilder binds string input parameters to the Char or NChar datatype….

NumbersInternal – PB Docs 125

NumbersInternal database parameter Description Specifies that numbers should be retrieved from the database using Oracle’s internal 21-byte binary NUMBER datatype format instead of using OCI strings. The NumbersInternal parameter is relevant only when you are accessing an Oracle database configured with an EBCDIC character set or other non-ASCII character set. When to specify NumbersInternal You…

NLS_Charset – PB Docs 125

NLS_Charset database parameter Description Specifies the client-side character set for the current environment handle. Controls O90 Oracle9i O10 Oracle 10g ORA Oracle 11g Syntax

Parameter Description value Specifies the client-side character set for the current environment handle. Values are: Unicode (Default) The OCI client uses the UTF-16 character set. When connecting to EAServer with…

NCharLiteral – PB Docs 125

NCharLiteral database parameter Description Specifies whether the NChar literal replacement feature in the Oracle client is enabled. This feature replaces string literals on the client that are prefaced with the letter N with an internal format. The internal format is decoded to Unicode by the database server when the statement is executed. When to specify…

NumericFormat – PB Docs 125

NumericFormat database parameter Description If supported by the DBMS or back-end database, setting NumericFormat tells the driver to do special formatting of numeric strings in SQL syntax. This formatting affects how PowerBuilder generates numeric values in the SQL syntax it internally builds in DataWindow objects and sends to your database. Controls JDB JDBC ODBC Syntax…

StatementCache – PB Docs 125

StatementCache database parameter Description Specifies whether statement caching is enabled and the maximum number of statements to cache. Controls O10 Oracle 10g ORA Oracle 11g Syntax

Parameter Description value Specifies whether statement caching is enabled and the maximum number of statements to cache. Values are: 0 Statement caching is disabled. n Statement caching is…

OnlineIndex – PB Docs 125

OnlineIndex database parameter Description Specifies that the Database painter should use the ONLINE keyword when you create or drop an index on a table so that the index can be created or dropped without locking the table. When to specify OnlineIndex You must specify the OnlineIndex parameter before connecting to the database. Controls I10 Informix…