Contents of the extended attribute system tables – PB Docs 2017
Contents of the extended attribute system tables PowerBuilder stores five types of extended attribute information in the system tables as described in the following table. System table Information about Attributes pbcatcol Columns Names, comments, headers, labels, case, initial value, and justification pbcatedt Edit styles Edit style names and definitions pbcatfmt Display formats Display format names and…
Logging in to your database for the first time – PB Docs 2017
Logging in to your database for the first time By default, PowerBuilder creates the extended attribute system tables the first time you connect to a database. To ensure that PowerBuilder creates the extended attribute system tables with the proper access rights to make them available to all users, the first person to connect to the database with…
Informix Interval datatype – PB Docs 2017
Informix Interval datatype The interval datatype is one value or a sequence of values that represent a component of time. The syntax is:
|
1 |
INTERVAL largest_qualifier TO smallest_qualifier |
PowerBuilder defaults to Day(3) TO Day. For more about interval datatypes, see your Informix documentation. Document get from Powerbuilder help Thank you for watching.
T-SQL enhancements – PB Docs 2017
T-SQL enhancements MERGE statement The MERGE Transact-SQL statement performs INSERT, UPDATE, or DELETE operations on a target table or view based on the results of a join with a source table. You can use MERGE statement in the ISQL painter and in PowerScript using dynamic SQL. For example
|
1 2 3 4 5 6 7 8 9 10 |
String mySQL mySQL = "MERGE INTO a USING b ON a.keycol = b.keycol " & Â Â + "WHEN MATCHED THEN "& Â Â + "UPDATE SET col1 = b.col1,col2 = b.col2 " & Â Â + "WHEN NOT MATCHED THEN " & Â Â + "INSERT (keycol, col1, col2, col3)" & Â Â + "VALUES (b.keycol, b.col1, b.col2, b.col3) " & Â Â + "WHEN SOURCE NOT MATCHED THEN " & Â Â + "DELETE;" EXECUTE IMMEDIATE :Mysql; |
Using the MERGE statement in ISQL…
Accessing Unicode data – PB Docs 2017
Accessing Unicode data PowerBuilder can connect, save, and retrieve data in ANSI/DBCS databases using the IN9 interface, but the IN9 interface does not support Unicode databases. The Informix I10 interface supports ANSI/DBCS and Unicode databases. The I10 native interface uses the Informix GLS (Global Language Support) API for global language support. The native interface uses three…
New database parameters – PB Docs 2017
New database parameters Provider parameter The Provider DBParm parameter for the SQL Native Client (SNC) interface allows you to select the SQL Server version that you want to connect to. You can set this parameter in script to SQLNCLI (for the SNC 9.0 driver that connect to SQL Server 2005), to SQLNCLI10 (for the SNC…
Maintaining shared database profiles – PB Docs 2017
Maintaining shared database profiles If you maintain the database profiles for PowerBuilder at your site, you might need to update shared database profiles from time to time and make these changes available to your users. Because shared database profiles can be accessed by multiple users running PowerBuilder, it is not a good idea to make changes to…
Informix DateTime datatype – PB Docs 2017
Informix DateTime datatype The DateTime datatype is a contiguous sequence of boxes. Each box represents a component of time that you want to record. The syntax is:
|
1 |
DATETIME largest_qualifier TO smallest_qualifier |
PowerBuilder defaults to Year TO Fraction(5). For a list of qualifiers, see your Informix documentation. To create your own variation of the DateTime datatype: In the Database painter, create…
Informix Time datatype – PB Docs 2017
Informix Time datatype The Informix database interfaces also support a time datatype. The time datatype is a subset of the DateTime datatype. The time datatype uses only the time qualifier boxes. Document get from Powerbuilder help Thank you for watching.
Components of an OLE DB connection – PB Docs 2017
Components of an OLE DB connection When you access an OLE DB data provider in PowerBuilder, your connection goes through several layers before reaching the data provider. It is important to understand that each layer represents a separate component of the connection, and that each component might come from a different vendor. Because OLE DB…