Powerbuilder Connection Reference

Properties – PB Docs 2017

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

Default value 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…

Log – PB Docs 2017

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. Applies to ASE and SYC SAP Adaptive Server Enterprise Syntax

Parameter Description value A value that specifies whether…

Release – PB Docs 2017

Release database parameter Description Specifies what version of SAP 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. Applies to ASE, SYC SAP Adaptive Server Enterprise Syntax

Parameter Description value Specifies the version of…

Time – PB Docs 2017

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. Applies to JDB JDBC ODBC O90 Oracle9i O10 Oracle 10g ORA Oracle 11g Syntax The syntax you use to specify the Time parameter differs…

Timeout – PB Docs 2017

Timeout database parameter Description Specifies the number of seconds the interface should wait for a connection to the data provider to complete. When to specify TimeOut You must specify a value for TimeOut before connecting to the database. Applies to ADO.NET OLE DB SNC SQL Native Client for Microsoft SQL Server Syntax

Parameter Description value The…

URL – PB Docs 2017

URL database parameter Description The location of the database to which you want to connect using the JDBC interface. When to specify URL You must specify the URL parameter before connecting to the database. Applies to JDB JDBC Syntax

Default value None Usage The database URL is obtained from the database JDBC driver documentation….

Date – PB Docs 2017

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. Applies to JDB JDBC ODBC O90 Oracle9i O10 Oracle 10g ORA Oracle 11g Syntax The syntax you use to specify the Date parameter…

DateTime – PB Docs 2017

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.) Applies to JDB JDBC ODBC O90 Oracle9i O10 Oracle 10g ORA Oracle…

Host – PB Docs 2017

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…

Identity – PB Docs 2017

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 value of the newly…