What's New in SQL Anywhere Studio
  Upgrading Version 5 Applications
    Upgrading ODBC applications

Upgrade notes for PowerBuilder and InfoMaker users

Users of Sybase PowerBuilder and InfoMaker should make some changes in order to obtain full functionality with Adaptive Server Anywhere Version 9.

The pbodb80.ini file 

PowerBuilder and InfoMaker use a file named pbodb80.ini to hold ODBC data source information. The 80 in the file name may be different, depending on the version you have. For each ODBC driver it provides such things as DDL syntax, default DBParm options, valid function names and special data types.

If your pbodb80.ini file does not have a Adaptive Server Anywhere section, PowerBuilder and InfoMaker default to a core syntax. This limits the operations you can carry out using these tools. For example you cannot create, alter, or drop primary and foreign keys.

Upgrading your pbodb80.ini file 

To obtain complete functionality with PowerBuilder and InfoMaker, you need to upgrade your pbodb80.ini file.

To upgrade your pbodb80.ini file

1. Make a backup copy of your existing pbodb80.ini file.

2. Add an Adaptive Server Anywhere section to the working copy of the file containing the same information as the existing Sybase SQL Anywhere section:

   [Adaptive Server Anywhere]
   PBSyntax='WATCOM50_SYNTAX'
   PBDateTime='STANDARD_DATETIME'
   PBFunctions='WATCOM_FUNCTIONS'
   PBDefaultValues='autoincrement,current date,current time,current timestamp,timestamp,null,user'
   PBDefaultCreate='YES'
   PBDefaultAlter='YES'
   PBDefaultExpressions='YES'
   DelimitIdentifier='YES'
   PBDateTimeInvalidInSearch='NO'
   PBTimeInvalidInSearch='YES'
   PBQualifierIsOwner='NO'
   PBSpecialDataTypes='WATCOM_SPECIALDATATYPES'
   IdentifierQuoteChar='"'
   PBSystemOwner='sys,dbo,rs_systabgroup'
   PBUseProcOwner='YES'
   SQLSrvrTSName='YES'
   SQLSrvrTSQuote='YES'
   SQLSrvrTSDelimit='YES'
   ForeignKeyDeleteRule='Disallow if Dependent Rows Exist (RESTRICT),Delete any Dependent Rows (CASCADE),Set Dependent Columns to NULL (SET NULL)'
   TableListType='GLOBAL TEMPORARY'