com.knowgate.dataobjs
Class DBBind.Functions

java.lang.Object
  com.knowgate.dataobjs.DBBind.Functions

Enclosing class:

DBBind

public static class DBBind.Functions

extends java.lang.Object

Aliases for common SQL functions in different database dialects.

Version:

1.2

Field Summary

static java.lang.String	CHR Get character from ASCII code
static java.lang.String	CONCAT String concatenation
static java.lang.String	GETDATE Get System Date
static int	iDBMS
static java.lang.String	ILIKE Case-insensitve LIKE operator (PostgreSQL only)
static java.lang.String	ISNULL ISNULL(value, default)
static java.lang.String	LENGTH Get string length
static java.lang.String	LOWER Transform String to lowercase
static java.lang.String	UPPER Transform String to uppercase

Constructor Summary

DBBind.Functions()

Method Summary

static java.lang.String

toChar(java.lang.Object oData, int iLength)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ISNULL

public static java.lang.String ISNULL

ISNULL(value, default)

Get value or default if value is null

CONCAT

public static java.lang.String CONCAT

String concatenation

Str1 CONCAT Str2

GETDATE

public static java.lang.String GETDATE

Get System Date

LOWER

public static java.lang.String LOWER

Transform String to lowercase

LOWER(str)

UPPER

public static java.lang.String UPPER

Transform String to uppercase

UPPER(str)

LENGTH

public static java.lang.String LENGTH

Get string length

LENGTH(str)

CHR

public static java.lang.String CHR

Get character from ASCII code

CHAR([0..255])

ILIKE

public static java.lang.String ILIKE

Case-insensitve LIKE operator (PostgreSQL only)

iDBMS

public static int iDBMS

Constructor Detail

DBBind.Functions

public DBBind.Functions()

Method Detail

toChar

public static java.lang.String toChar(java.lang.Object oData,
                                      int iLength)
                               throws java.lang.UnsupportedOperationException

Throws:

java.lang.UnsupportedOperationException