IBM 7.2.1 manual DB2 Everyplace Functions, Sync Server Design Overview, Functions supported

Page 14

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

Image 14
Contents DB2 Everyplace AgendaIBM Mobile solutions-- technical overview Things to think aboutIBM DB2 Family IBM Pervasive Computing Vision DB2 Everyplace WHY?? DB2 Everyplace Sync connection optionsBusiness applications ISVs and partners Field Force Automation Gas de FranceAsset Tracking Application DB2E database DB2E sync server Healthcare AsatteAsset Tracking Essential Systems UDB on Palm On LinuxRetail/Sales Force Automation NetSetGo Retail/Easy of Use Penn StateSystem Monitoring/Embedded X-Serwis DB2 EveryplaceDB2 Everyplace Solution DB2 Everyplace ArchitectureDB2 Everyplace Characteristics DB2 Everyplace SQLCreate table Orders CHARACTERSmallint VARCHARSmallint BLOBSmallintFunctions supported DB2 Everyplace FunctionsSync Server Design Overview Expression can beMobile device administration center Mdac is the tool to define all these object propertiesRobust Development environment Commercial Development tools contdEnd References/resourcesPackaging & Pricing Enterprise Edition