Adding functions to an existing section in the file

If sections for your back-end DBMS already exist in PBODB110.INI, use the following procedure to add new functions.

To add functions to an existing section in PBODB110.INI:

Open PBODB110.INI in one of the following ways:
- Use the File Editor in DataWindow Designer. (For instructions, see the User’s Guide.)
- Use any text editor outside DataWindow Designer.

Locate the entry for your back-end DBMS in the DBMS Driver/DBMS Settings section of PBODB110.INI.

For example, here is thePBODB110.INI entry for SQL Anywhere:

;*********************************************

;DBMS Driver/DBMS Settings see comments at end

;of file

;*********************************************

...

[SQL Anywhere]

PBSyntax='WATCOM50_SYNTAX'

PBDateTime='STANDARD_DATETIME'

PBFunctions='ASA_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'

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’

Find the Functions section for your back-end DBMS in PBODB110.INI.

For example, here is the Functions section for SQL Anywhere:

;*********************************************

;Functions

;*********************************************

[ASA_FUNCTIONS]

AggrFuncs=avg(x),avg(distinct x),count(x),

   count(distinct x),count(*),list(x),

   list(distinct x),max(x),max(distinct x),

   min(x),min(distinct x),sum(x),sum(distinct x)

Functions=abs(x),acos(x),asin(x),atan(x),

   atan2(x,y),ceiling(x),cos(x),cot(x),degrees(x),

   exp(x),floor(x),log(x),log10(x),

   mod(dividend,divisor),pi(*),power(x,y),

   radians(x),rand(),rand(x),

   remainder(dividend,divisor),round(x,y),

   sign(x),sin(x),sqrt(x),tan(x),

   "truncate"(x,y),ascii(x),byte_length(x),

   byte_substr(x,y,z),char(x),char_length(x),

   charindex(x,y),difference(x,y)insertstr(x,y,z),

   lcase(x),left(x,y),length(x), locate(x,y,z),

   lower(x),ltrim(x),patindex('x',y),repeat(x,y),

   replicate(x,y),right(x,y),rtrim(x),

   similar(x,y),soundex(x),space(x),str(x,y,z),

   string(x,...),stuff(w,x,y,z),substr(x,y,z),

   trim(x),ucase(x),upper(x),date(x),

   dateformat(x,y),datename(x,y),day(x),

   dayname(x),days(x),dow(x),hour(x),hours(x),

   minute(x),minutes(x),minutes(x,y),month(x),

   monthname(x),months(x),months(x,y),now(*),

   quarter(x),second(x),seconds(x),seconds(x,y),

   today(*),weeks(x),weeks(x,y),year(x),years(x),

   years(x,y),ymd(x,y,z),dateadd(x,y,z),

   datediff(x,y,z),datename(x,y),datepart(x,y),

   getdate(),cast(x as y),convert(x,y,z),

   hextoint(x),inttohex(x),

   connection_property(x,...),datalength(x),

   db_id(x),db_name(x),db_property(x),

   next_connection(x),next_database(x),

   property(x),property_name(x),

   property_number(x),property_description(x),

   argn(x,y,...),coalesce(x,...),

   estimate(x,y,z),estimate_source(x,y,z),

   experience_estimate(x,y,z),ifnull(x,y,z),

   index_estimate(x,y,z),isnull(x,...),

   number(*),plan(x),traceback(*)

To add a new function, type a comma followed by the function name at the end of the appropriate function list, as follows:

Aggregate functions Add aggregate functions to the end of the AggrFuncs list.
All other functions Add all other functions to the end of the Functions list.

Case sensitivity If the back-end DBMS you are using is case sensitive, be sure to use the required case when you add the function name.

The following example shows a new function for SQL Anywhere added at the end of the Functions list:

;*********************************************

;Functions

;*********************************************

[ASA_FUNCTIONS]

AggrFuncs=avg(x),avg(distinct x),count(x),

   count(distinct x),count(*),list(x),

   list(distinct x),max(x),max(distinct x),

   min(x),min(distinct x),sum(x),sum(distinct x)

Functions=abs(x),acos(x),asin(x),atan(x),

   atan2(x,y),ceiling(x),cos(x),cot(x),degrees(x),

   exp(x),floor(x),log(x),log10(x),

   mod(dividend,divisor),pi(*),power(x,y),

   radians(x),rand(),rand(x),

...

   number(*),plan(x),traceback(*),newfunction()