Database parameters

PacketSize (ODBC) – PB Docs 125

PacketSize (ODBC) database parameter Description Specifies the network packet size in bytes when you access an ODBC data source in PowerBuilder. Many back-end DBMSs either do not support the PacketSize option or can return only the current network packet size. For information about whether the DBMS you are accessing supports PacketSize, see your DBMS documentation….

Connection Reference – PB Docs 125

Connection Reference Audience This book is for anyone who uses Sybase® PowerBuilder® to connect to a database. It assumes that you are familiar with the database you are using and have installed the server and client software required to access the data. How to use this book This book describes the database parameters and preferences…

PBMaxTextSize – PB Docs 125

PBMaxTextSize database parameter Description Specifies the maximum length of text or large value datatypes returned when you include them in a DataWindow. You can set the PBMaxTextSize parameter if you want to include a long text string in a DataWindow object without treating the text as a binary large object (blob) datatype. Controls SNC SQL…

PBMaxBlobSize – PB Docs 125

PBMaxBlobSize database parameter Description Specifies the maximum blob size that PowerBuilder can read into memory. When to specify PBMaxBlobSize You must specify a value for the PBMaxBlobSize parameter before connecting to the database. Controls ADO.NET OLE DB SNC SQL Native Client for Microsoft SQL Server Syntax

Default PBMaxBlobSize=1024000 Usage PowerBuilder does not restrict the…

PBCatalogOwner – PB Docs 125

PBCatalogOwner database parameter Description Specifies a nondefault owner for the extended attribute system tables. These five tables contain default extended attribute information for your database. When you specify a PBCatalogOwner name that is different from the default owner for your DBMS, PowerBuilder creates a new set of tables with the owner name you specify. When…

PBNewSPInvocation – PB Docs 125

PBNewSPInvocation database parameter Description Uses an alternative method to invoke a stored procedure. Controls ODBC Syntax

Parameter Description value Specifies whether the standard method or an alternative method is used to invoke a stored procedure. Values are: No (Default) Use the standard method to invoke a stored procedure. Yes Use the alternative method to…

PBTrimCharColumns – PB Docs 125

PBTrimCharColumns database parameter Description Specifies whether PowerBuilder should trim trailing spaces from data values retrieved from the following datatypes: Char, Char for Bit Data, VarChar, and VarChar for Bit Data. Controls ODBC OLE DB Syntax

Parameter Description value Specifies whether PowerBuilder should trim trailing spaces from data of type Char, Char for Bit Data,…

PBNoCatalog – PB Docs 125

PBNoCatalog database parameter Description Specifies that PowerBuilder will not check for the existence of catalog tables when creating a DataWindow object at runtime. When to specify PBNoCatalog You must specify the PBNoCatalog parameter before connecting to the database. Controls O90 Oracle9i O10 Oracle 10g ORA Oracle 11g Syntax

Parameter Description value Specifies that PowerBuilder…

OraMTSConFlgs – PB Docs 125

OraMTSConFlgs database parameter Description Specifies the behavior of a transactional PowerBuilder component deployed to COM+. This parameter applies only when a PowerBuilder custom class user object is deployed as a COM+ component and is connecting to an Oracle 8.1.5 or higher database. Deprecated DBParm You can no longer deploy components from PowerBuilder to COM+ servers….

PackageProcs – PB Docs 125

PackageProcs database parameter Description Specifies that the stored procedures and functions encapsulated in an Oracle database package should be appended to the lists of Oracle standalone stored procedures and functions displayed in the DataWindow Object and Database painters. When to specify PackageProcs You must specify the PackageProcs parameter before connecting to the database. Controls O90…