
DB2 Everyplace Functions

 Functions supported
 Functions supported
 AVG(expression)
 AVG(expression)
 SUM(expression)
 SUM(expression)
 MIN(expression)
 MIN(expression)
 MAX (expression)
 MAX (expression)
 COUNT(expression)
 COUNT(expression)
 CONCAT(expression,expression)
 CONCAT(expression,expression)
 MOD(expression,expression)
 MOD(expression,expression)
 LENGTH(expression)
 LENGTH(expression)
 RTRIM(expression)
 RTRIM(expression)

 expression can be
 expression can be
 a literal like *
 a literal like *
 column name , function , special register
 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  | 
| 
 | Sync Server and is delivered as | 
| 
 | workgroup edition | 
Data Sources
Page 
