DB2 Everyplace Functions

Functions supported

AVG(expression)

SUM(expression)

MIN(expression)

MAX (expression)

COUNT(expression)

CONCAT(expression,expression)

MOD(expression,expression)

LENGTH(expression)

RTRIM(expression)

expression can be

a literal like *

column name , function , special register

Sync Server Design Overview

IBM Sync GUI

 

Sync

 

Engine DB2 adapter

HTTP

Mobile Devices

Administration Center

DB2

Family

API

 

Sync

 

 

File adapter

WAP

SyncML

 

 

Engine

 

 

 

 

servlet

SyncML

DProp adapter

Agent adapter

Bluetooth

PIM adapter

Adapter Transport

API API

Java

ynchronizer Agent adapter using

WBXML

JDBC adapter

 

Adapter

API

Informix

DB

Server

Devices

Synchronization

Palm OS,

Server

Win CE,Win32,Pocket PC

Windows NT/2000

EPOC, SymbianOS

AIX,Linux,Solaris

Neutrino, embedded Linux

NB: DB2 UDB is a pre-req for

 

Sync Server and is delivered as

 

workgroup edition

Data Sources

Page 27-28

Page 14
Image 14
IBM 7.2.1 manual DB2 Everyplace Functions, Sync Server Design Overview, Functions supported, Expression can be