Impl Class Reference

Inheritance diagram for Impl:

Collaboration diagram for Impl:

Static Public Member Functions
_.Library.String	CHARINDEX (_.Library.String ToFind, _.Library.String FindIn, _.Library.Integer StartAt)
_.Library.Integer	DATALENGTH (Item)
_.Library.Numeric	FLOOR (_.Library.String Number)
	Find (_.Library.String LookIn, _.Library.String LookFor, _.Library.Integer StartLook)
_.Library.String	IFNULL (_.Library.String Expr1, _.Library.String Expr2, _.Library.String Expr3)
_.Library.Boolean	IsStream (_.Library.String Value, StreamOref)
_.Library.Integer	LEN (_.Library.String Str)
_.Library.String	REPLACE (_.Library.String Expr, _.Library.String Old, _.Library.String New)
_.Library.String	ROUND (_.Library.Numeric Number, _.Library.Integer Length, _.Library.Integer Function)
_.Library.String	STUFF (_.Library.String SourceString, _.Library.Integer StartPos, _.Library.Integer ReplaceLength, _.Library.String ReplaceString)
_.Library.String	SUBSTRING (Item, Start, Length)
_.Library.Integer	ZBITWISEAND (A, B)
_.Library.Integer	ZBITWISEOR (A, B)
_.Library.Integer	ZBITWISEXOR (A, B)
_.Library.Integer	ZCONVERRFROMTSQL (A)
	ZFORMATMESSAGE (Message, Args)
_.Library.String	ZLIKETOCOSPATTERN (_.Library.String LikePattern, _.Library.String LikeEscape)
_.Library.String	ZLIKETOCOSPATTERNS (_.Library.String LikePattern, _.Library.String LikeEscape)
_.Library.Integer	ZPATINDEXFB (_.Library.String CosPattern, _.Library.String Expr)
_.Library.Integer	ZPATINDEXL (_.Library.String LiteralPart, _.Library.String Expr)
_.Library.Integer	ZPATINDEXLR (_.Library.String LiteralPart, _.Library.String CosPattern, _.Library.String Expr)
_.Library.Integer	ZPATINDEXPL (_.Library.String LiteralPart, _.Library.String Expr)
_.Library.Integer	ZPATINDEXPLR (_.Library.String LiteralPart, _.Library.String CosPattern, _.Library.String Expr)
_.Library.Integer	ZPATINDEXPN (_.Library.String CosPattern, _.Library.String Expr)
_.Library.Integer	ZPATINDEXU (_.Library.Integer UnderlineCount, _.Library.String Expr)
_.Library.Integer	ZPATINDEXUL (_.Library.Integer UnderlineCount, _.Library.String LiteralPart, _.Library.String Expr)
_.Library.Integer	ZPATINDEXULR (_.Library.Integer UnderlineCount, _.Library.String LiteralPart, _.Library.String CosPattern, _.Library.String Expr)
_.Library.Float	ZRAND (_.Library.Integer ScaleFactor)
_.Library.String	ZREMAMPM (Item)
_.Library.Integer	ZRPATINDEX (_.Library.String TsqlPattern, _.Library.String Expr)
_.Library.Integer	ZRPATINDEXPLP (_.Library.String TsqlInnerPattern, _.Library.String Expr)
_.Library.String	ZWITHDATETIME (_.Library.String Item)

Static Private Member Functions
_.Library.String	__AnalyseRangePattern (_.Library.String RangeText, _.Library.String LikeEscape)
_.Library.Integer	__CompareStringPos2 (_.Library.Integer N1, _.Library.Integer N2, _.Library.List Tags)
_.Library.Integer	__CompareStringPos3 (_.Library.Integer N1, _.Library.Integer N2, _.Library.Integer N3, _.Library.List Tags)
_.Library.String	__ExtractRangeText (_.Library.String LikePattern, _.Library.String LikeEscape, _.Library.Integer Pos)
_.Library.List	__ZLIKETOCOSPATTERNLIST (_.Library.String LikePattern, _.Library.String LikeEscape)

Additional Inherited Members
Public Member Functions inherited from RegisteredObject
_.Library.Status	OnAddToSaveSet (_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount)
	This callback method is invoked when the current object is added to the SaveSet,. More...
_.Library.Status	OnClose ()
	This callback method is invoked by the <METHOD>Close</METHOD> method to. More...
_.Library.Status	OnConstructClone (_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned)
	This callback method is invoked by the <METHOD>ConstructClone</METHOD> method to. More...
_.Library.Status	OnNew ()
	This callback method is invoked by the <METHOD>New</METHOD> method to. More...
_.Library.Status	OnValidateObject ()
	This callback method is invoked by the <METHOD>ValidateObject</METHOD> method to. More...
Static Public Attributes inherited from RegisteredObject
	CAPTION = None
	Optional name used by the Form Wizard for a class when generating forms. More...
	JAVATYPE = None
	The Java type to be used when exported.
	PROPERTYVALIDATION = None
	This parameter controls the default validation behavior for the object. More...

Detailed Description

Implementation of TSQL scalar and other functions not supported by SQL

Member Function Documentation

__AnalyseRangePattern()

_.Library.String __AnalyseRangePattern ( _.Library.String  RangeText, _.Library.String  LikeEscape  )

staticprivate

Given RangeText with what appeared between [..] with the escapes for LikeEscape and "-" intact

Return a COS pattern fragment which matches the range

CHARINDEX()

_.Library.String CHARINDEX ( _.Library.String  ToFind, _.Library.String  FindIn, _.Library.Integer  StartAt  )

static

Implement CHARINDEX(tofind,findin[,startat])

__CompareStringPos2()

_.Library.Integer __CompareStringPos2 ( _.Library.Integer  N1, _.Library.Integer  N2, _.Library.List  Tags  )

staticprivate

N1-N2 are COS string positions, 1-based and 0 means not found

If one of the positions is undisputedly earlier its tag is returned

otherwise return 0

__CompareStringPos3()

_.Library.Integer __CompareStringPos3 ( _.Library.Integer  N1, _.Library.Integer  N2, _.Library.Integer  N3, _.Library.List  Tags  )

staticprivate

N1-N3 are COS string positions, 1-based and 0 means not found

If one of the positions is undisputedly earliest of the three its tag is returned

otherwise return 0

DATALENGTH()

_.Library.Integer DATALENGTH (   Item )

static

Implement DATALENGTH(item)

__ExtractRangeText()

_.Library.String __ExtractRangeText ( _.Library.String  LikePattern, _.Library.String  LikeEscape, _.Library.Integer  Pos  )

staticprivate

Given the position just after the "["

Return with the position just after the "]" - or after the end of the string if there is no "]"

Return the raw range text (with relevant escapes for "-" and the escape character itself still in place)

FLOOR()

_.Library.Numeric FLOOR ( _.Library.String  Number )

static

Implement FLOOR for COS context

Find()

Find ( _.Library.String  LookIn, _.Library.String  LookFor, _.Library.Integer  StartLook  )

static

Look for LookIn in LookFor starting at StartLook (defaults to 1)

If the string isn't found then 0 is returned

If the string is found then the 1-based offset to the start of LookFor in LookIn is returned

IFNULL()

_.Library.String IFNULL ( _.Library.String  Expr1, _.Library.String  Expr2, _.Library.String  Expr3  )

static

Implement IFNULL(expr1,expr2[,expr3])

IsStream()

_.Library.Boolean IsStream ( _.Library.String  Value,   StreamOref  )

static

Is the given value a stream id?

- if so: return 1 and set StreamOref

- otherwise: return 0 and set StreamOref to $$$NULLOREF

LEN()

_.Library.Integer LEN ( _.Library.String  Str )

static

Implement LEN for COS context

REPLACE()

_.Library.String REPLACE ( _.Library.String  Expr, _.Library.String  Old, _.Library.String  New  )

static

Implement REPLACE(expr,old,new)

ROUND()

_.Library.String ROUND ( _.Library.Numeric  Number, _.Library.Integer  Length, _.Library.Integer  Function  )

static

Implement ROUND(number,length,function)

STUFF()

_.Library.String STUFF ( _.Library.String  SourceString, _.Library.Integer  StartPos, _.Library.Integer  ReplaceLength, _.Library.String  ReplaceString  )

static

Implement STUFF(sourcestring,startpos,replacelength,replacestring)

SUBSTRING()

_.Library.String SUBSTRING (   Item,   Start,   Length  )

static

Implement SUBSTRING(item, start, length)

ZBITWISEAND()

_.Library.Integer ZBITWISEAND (   A,   B  )

static

Implement bitwiseAND

ZBITWISEOR()

_.Library.Integer ZBITWISEOR (   A,   B  )

static

Implement bitwiseOR

ZBITWISEXOR()

_.Library.Integer ZBITWISEXOR (   A,   B  )

static

Implement bitwiseXOR

ZCONVERRFROMTSQL()

_.Library.Integer ZCONVERRFROMTSQL (   A )

static

Translate a TSQL error code to a SQLCODE

ZFORMATMESSAGE()

ZFORMATMESSAGE (   Message,   Args  )

static

Format a RAISERROR message with the given arguments

ZLIKETOCOSPATTERN()

_.Library.String ZLIKETOCOSPATTERN ( _.Library.String  LikePattern, _.Library.String  LikeEscape  )

static

Given a LIKE pattern and optional LIKE ESCAPE, return the corresponding COS pattern (non-SQL strings)

__ZLIKETOCOSPATTERNLIST()

_.Library.List __ZLIKETOCOSPATTERNLIST ( _.Library.String  LikePattern, _.Library.String  LikeEscape  )

staticprivate

Given a LIKE pattern and optional LIKE ESCAPE, return a list of top-level COS pattern elements

ZLIKETOCOSPATTERNS()

_.Library.String ZLIKETOCOSPATTERNS ( _.Library.String  LikePattern, _.Library.String  LikeEscape  )

static

Given a LIKE pattern and optional LIKE ESCAPE, return the corresponding COS pattern (SQL strings)

ZPATINDEXFB()

_.Library.Integer ZPATINDEXFB ( _.Library.String  CosPattern, _.Library.String  Expr  )

static

PATINDEX for anything that isn't covered above (FB=fallback) - returns 0/1

- will not give the correct result for a pattern beginning with "%"

ZPATINDEXL()

_.Library.Integer ZPATINDEXL ( _.Library.String  LiteralPart, _.Library.String  Expr  )

static

PATINDEX for: literal - returns 0/1

ZPATINDEXLR()

_.Library.Integer ZPATINDEXLR ( _.Library.String  LiteralPart, _.Library.String  CosPattern, _.Library.String  Expr  )

static

PATINDEX for: literal rest - returns 0/1

ZPATINDEXPL()

_.Library.Integer ZPATINDEXPL ( _.Library.String  LiteralPart, _.Library.String  Expr  )

static

PATINDEX for: percent literal - returns 0/position of literal

ZPATINDEXPLR()

_.Library.Integer ZPATINDEXPLR ( _.Library.String  LiteralPart, _.Library.String  CosPattern, _.Library.String  Expr  )

static

PATINDEX for: percent literal rest - 0/returns position of literal

ZPATINDEXPN()

_.Library.Integer ZPATINDEXPN ( _.Library.String  CosPattern, _.Library.String  Expr  )

static

PATINDEX for: percent non-literal - returns 0/position of non-literal

ZPATINDEXU()

_.Library.Integer ZPATINDEXU ( _.Library.Integer  UnderlineCount, _.Library.String  Expr  )

static

PATINDEX for: underline(s) - returns 0/1

ZPATINDEXUL()

_.Library.Integer ZPATINDEXUL ( _.Library.Integer  UnderlineCount, _.Library.String  LiteralPart, _.Library.String  Expr  )

static

PATINDEX for: underline(s) literal - returns 0/1

ZPATINDEXULR()

_.Library.Integer ZPATINDEXULR ( _.Library.Integer  UnderlineCount, _.Library.String  LiteralPart, _.Library.String  CosPattern, _.Library.String  Expr  )

static

PATINDEX for: underline(s) literal rest - returns 0/1

ZRAND()

_.Library.Float ZRAND ( _.Library.Integer  ScaleFactor )

static

Implement ZRAND(scalefactor)

ZREMAMPM()

_.Library.String ZREMAMPM (   Item )

static

Implement ZREMAMPM(item) to remove the "AM" or "PM" if necessary

ZRPATINDEX()

_.Library.Integer ZRPATINDEX ( _.Library.String  TsqlPattern, _.Library.String  Expr  )

static

PATINDEX for non-literal patterns

ZRPATINDEXPLP()

_.Library.Integer ZRPATINDEXPLP ( _.Library.String  TsqlInnerPattern, _.Library.String  Expr  )

static

PATINDEX for "%"+XXX+"%" patterns

ZWITHDATETIME()

_.Library.String ZWITHDATETIME ( _.Library.String  Item )

static

Implement ZWITHDATETIME(item) to append a date of 1/1/1900 and/or a time of midnight to the item if necessary