Database parameters

Time – PB Docs 125

Time database parameter Description When you update data in the DataWindow painter, PowerBuilder builds a SQL UPDATE statement in the background. The Time parameter determines how PowerBuilder specifies a time datatype when it builds the SQL UPDATE statement. Controls JDB JDBC ODBC O90 Oracle9i O10 Oracle 10g ORA Oracle 11g Syntax The syntax you use…

Release – PB Docs 125

Release database parameter Description Specifies what version of Sybase Open Client Client-Library (CT-Lib) software is in use on the client workstation. When to specify Release You must specify a value for Release before connecting to the database. Controls ASE, SYC Sybase Adaptive Server Enterprise Syntax

Parameter Description value Specifies the version of Open Client…

Properties – PB Docs 125

Properties database parameter Description Sets properties specific to the particular JDBC driver you are using to connect to the database. Controls JDB JDBC Syntax

Default None Usage The Driver-Specific Properties box allows you to set properties specific to a particular driver. For information about the properties supported by your JDBC driver, see the vendor’s…

Log – PB Docs 125

Log database parameter Description Specifies whether the database server should log updates of text and image data in the transaction log. By default, the database server logs updates of text and image data in the transaction log. Controls ASE, SYC and SYJ Sybase Adaptive Server Enterprise Syntax

Parameter Description value A value that specifies…

Identity – PB Docs 125

Identity database parameter Description Specifies the syntax the SNC database interface uses to obtain the identity value of a new row in a database table.When a DataWindow update request inserts a new row into a Microsoft SQL Server table that contains an IDENTITY column, the DataWindow engine calls the SNC interface to obtain the identity…

Host – PB Docs 125

Host database parameter Description If your DBMS supports it, specifies the workstation name when connecting to the database in PowerBuilder. The Host parameter lets you assign any 10–character label to identify the process you are about to create when you connect to the database. This label helps you distinguish your process from others running on…

Date – PB Docs 125

Date database parameter Description When you update data in the DataWindow painter, PowerBuilder builds a SQL UPDATE statement in the background. The Date parameter determines how PowerBuilder specifies a date datatype when it builds the SQL UPDATE statement. Controls JDB JDBC ODBC O90 Oracle9i O10 Oracle 10g ORA Oracle 11g Syntax The syntax you use…

DateTime – PB Docs 125

DateTime database parameter Description When you update data in the DataWindow painter, PowerBuilder builds a SQL UPDATE statement in the background. The DateTime parameter determines how PowerBuilder specifies a DateTime datatype when it builds the SQL UPDATE statement. (A DateTime datatype contains both a date value and a time value.) Controls JDB JDBC ODBC O90…

CharSet – PB Docs 125

CharSet database parameter Description Specifies the character set you want the Sybase Open Client™ software to use when connecting to a Sybase Adaptive Server Enterprise database or a database accessed through DirectConnect. When to specify CharSet You must specify the CharSet parameter before connecting to a database. Controls ASE, SYC Sybase Adaptive Server Enterprise DIR…

PacketSize (ASE, DIR, SNC, SYC) – PB Docs 125

PacketSize (ASE, DIR, SNC, SYC) database parameter Description When connecting to a database, specifies the packet size in bytes that you want the server to set for transferring data to and from your PowerBuilder application. A packet is a fixed-size chunk of data for sending information over a network. If the server has space limitations,…