2006.B.2

Einsatz von AvERP mit Linux als Server- und/oder Anwendungs-OS

Moderator: SYNERPY

Antworten
Christian Winkel
Beiträge: 110
Registriert: Mo Feb 07, 2005 10:45 pm

Beitrag von Christian Winkel »

Hallo

bei uns läuft die B2 auf einem Linuxserver inzwischen fehlerfrei.

Die nötigen Änderungen sind aber leider nicht richtig Dokumentiert.
Ich kann nach Rückkehr aus dem Urlaub (kommende Woche) aber gerne mal ein kleines HowTo posten.


gruss

Christian Winkel
sebastianwilk
Beiträge: 14
Registriert: So Jan 15, 2006 7:34 pm

Beitrag von sebastianwilk »

Wäre Super.

Danke
Christian Winkel
Beiträge: 110
Registriert: Mo Feb 07, 2005 10:45 pm

Beitrag von Christian Winkel »

Hallo

sorry, hat leider etwas länger gedauert.

Das sollte die UDF einbinden.

Code: Alles auswählen

DECLARE EXTERNAL FUNCTION F_SQRT
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Sqrt' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_POWER
DOUBLE PRECISION, DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Power' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_LNXP1
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_LnXP1' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_LOG10
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Log10' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_LOG2
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Log2' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_LOGN
DOUBLE PRECISION, DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_LogN' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_EQUALINTEGER
INTEGER, INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_EqualInteger' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_EQUALFLOAT
DOUBLE PRECISION, DOUBLE PRECISION
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_EqualFloat' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_ZAHLRUNDEN
DOUBLE PRECISION, INTEGER
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_ZahlRunden' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_PROZENTE
DOUBLE PRECISION, DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Prozente' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_ZEITDIFFERENZ
TIMESTAMP, TIMESTAMP, CSTRING(254)
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_ZeitDifferenz' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_PI
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Pi' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_DEGTORAD
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_DegToRad' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_RADTODEG
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_RadToDeg' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_COS
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Cos' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_SIN
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Sin' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_TAN
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Tan' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_COTAN
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_CoTan' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_HYPOT
DOUBLE PRECISION, DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Hypot' MODULE_NAME 'GrUDF';

/*------------------------------------------------------------------*/

DECLARE EXTERNAL FUNCTION F_NOT
INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_Not' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_AND
INTEGER, INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_And' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_OR
INTEGER, INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_Or' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_XOR
INTEGER, INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_Xor' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_SHL
INTEGER, INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_ShL' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_SHR
INTEGER, INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_ShR' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BLOBASPCHAR
BLOB
RETURNS CSTRING(32000) FREE_IT
ENTRY_POINT 'F_BlobAsPChar' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BLOBSIZE
BLOB
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_BlobSize' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_STRBLOB
CSTRING(32000),
BLOB
RETURNS PARAMETER 2
ENTRY_POINT 'F_StrBlob' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BLOBCAT
BLOB, BLOB, BLOB
RETURNS PARAMETER 3
ENTRY_POINT 'F_BlobCat' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BLOBCATSTR
BLOB, CSTRING(32767), BLOB
RETURNS PARAMETER 3
ENTRY_POINT 'F_BlobCatStr' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BLOBCOMP
BLOB, BLOB
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_BlobComp' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BLOBICOMP
BLOB, BLOB
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_BlobIComp' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BLOBUPPER
BLOB, BLOB
RETURNS PARAMETER 2
ENTRY_POINT 'F_BlobUpper' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BLOBWRAP
BLOB, INTEGER, BLOB
RETURNS PARAMETER 3
ENTRY_POINT 'F_BlobWrap' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BLOBISEMPTY
BLOB
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_BlobIsEmptyAfterTrim' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_REPLACESTRING
CSTRING(8196),
CSTRING(254),
CSTRING(254),
INTEGER,
INTEGER
RETURNS CSTRING(8196) FREE_IT
ENTRY_POINT 'F_ReplaceString' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BLOBLEFT
BLOB,
INTEGER
RETURNS CSTRING(32000) FREE_IT
ENTRY_POINT 'F_BlobLeft' MODULE_NAME 'GrUDF';


DECLARE EXTERNAL FUNCTION F_COPY
CSTRING(254), INTEGER, INTEGER
RETURNS CSTRING(254)
ENTRY_POINT 'F_Copy' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MID
CSTRING(254), INTEGER, INTEGER
RETURNS CSTRING(254)
ENTRY_POINT 'F_Mid' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_STROFCHAR
CSTRING(1), INTEGER
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_StrOfChar' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_SPACE
INTEGER
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_Space' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_DIGITS
CSTRING(254)
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_Digits' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_LEFT
CSTRING(254), INTEGER
RETURNS CSTRING(254)
ENTRY_POINT 'F_Left' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_RIGHT
CSTRING(254), INTEGER
RETURNS CSTRING(254)
ENTRY_POINT 'F_Right' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_LTRIM
CSTRING(254)
RETURNS CSTRING(254)
ENTRY_POINT 'F_LTrim' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_RTRIM
CSTRING(254)
RETURNS CSTRING(254)
ENTRY_POINT 'F_RTrim' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_LRTRIM
CSTRING(254)
RETURNS CSTRING(254)
ENTRY_POINT 'F_Trim' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_CHR
SMALLINT
RETURNS CSTRING(1) FREE_IT
ENTRY_POINT 'F_Chr' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_ASCII
CSTRING(1)
RETURNS SMALLINT BY VALUE
ENTRY_POINT 'F_AscII' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_COLLATEBR
CSTRING(254)
RETURNS CSTRING(254)
ENTRY_POINT 'F_CollateBr' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_INTTOHEX
INTEGER, INTEGER
RETURNS CSTRING(20) FREE_IT
ENTRY_POINT 'F_IntToHex' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_HEXTOINT
CSTRING(20)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_HexToInt' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_CRLF
RETURNS CSTRING(2) FREE_IT
ENTRY_POINT 'F_CRLF' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_EQUALSTRING
CSTRING(254), CSTRING(254)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_EqualString' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_FINDWORD
CSTRING(8196),
INTEGER
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_FindWord' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_PADLEFT
CSTRING(254),
CSTRING(10),
INTEGER
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_PadLeft' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_PADRIGHT
CSTRING(254),
CSTRING(10),
INTEGER
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_PadRight' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_PROPERCASE
CSTRING(254)
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_ProperCase' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_STRIPSTRING
CSTRING(254),
CSTRING(254)
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_StripString' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_STRINGLENGTH
CSTRING(254)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_StringLength' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BIGSTRINGLENGTH
CSTRING(1024)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_StringLength' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_SUBSTR
CSTRING(254),
CSTRING(254)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_SubStr' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_BIGSUBSTR
CSTRING(1024),
CSTRING(1024)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_SubStr' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_DAYOFMONTH
TIMESTAMP
RETURNS SMALLINT BY VALUE
ENTRY_POINT 'F_Day' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MONTH
TIMESTAMP
RETURNS SMALLINT BY VALUE
ENTRY_POINT 'F_Month' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_YEAR
TIMESTAMP
RETURNS SMALLINT BY VALUE
ENTRY_POINT 'F_Year' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_HOUR
TIMESTAMP
RETURNS SMALLINT BY VALUE
ENTRY_POINT 'F_Hour' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MINUTE
TIMESTAMP
RETURNS SMALLINT BY VALUE
ENTRY_POINT 'F_Minute' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_SECOND
TIMESTAMP
RETURNS SMALLINT BY VALUE
ENTRY_POINT 'F_Second' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_ENCODEDATE
TIMESTAMP, SMALLINT, SMALLINT, SMALLINT
RETURNS PARAMETER 1
ENTRY_POINT 'F_EncodeDate' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_ENCODETIME
TIMESTAMP, SMALLINT, SMALLINT, SMALLINT
RETURNS PARAMETER 1
ENTRY_POINT 'F_EncodeTime' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_ENCODETIMESTAMP
TIMESTAMP, SMALLINT, SMALLINT, SMALLINT, SMALLINT, SMALLINT, SMALLINT
RETURNS PARAMETER 1
ENTRY_POINT 'F_EncodeTimeStamp' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_DAYSPAN
TIMESTAMP, TIMESTAMP
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_DaySpan' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MONTHSPAN
TIMESTAMP, TIMESTAMP
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_MonthSpan' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_YEARSPAN
TIMESTAMP, TIMESTAMP
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_YearSpan' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_WEEKSPAN
TIMESTAMP, TIMESTAMP
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_WeekSpan' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_SECONDSPAN
TIMESTAMP, TIMESTAMP
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_SecondSpan' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MINUTESPAN
TIMESTAMP, TIMESTAMP
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_MinuteSpan' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_HOURSPAN
TIMESTAMP, TIMESTAMP
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_HourSpan' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_DAYSBETWEEN
TIMESTAMP, TIMESTAMP
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_DaysBetween' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_AGEINMONTHS
TIMESTAMP, TIMESTAMP
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_MonthsBetween' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_YEARSBETWEEN
TIMESTAMP, TIMESTAMP
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_YearsBetween' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_WEEKSBETWEEN
TIMESTAMP, TIMESTAMP
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_WeeksBetween' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_SECONDSBETWEEN
TIMESTAMP, TIMESTAMP
RETURNS NUMERIC(18,0) BY VALUE
ENTRY_POINT 'F_SecondsBetween' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MINUTESBETWEEN
TIMESTAMP, TIMESTAMP
RETURNS NUMERIC(18,0) BY VALUE
ENTRY_POINT 'F_MinutesBetween' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_HOURSBETWEEN
TIMESTAMP, TIMESTAMP
RETURNS NUMERIC(18,0) BY VALUE
ENTRY_POINT 'F_HoursBetween' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_ADDMONTH
TIMESTAMP, TIMESTAMP, INTEGER
RETURNS PARAMETER 1
ENTRY_POINT 'F_IncMonth' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_ANSIUPPERCASE
CSTRING(254)
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_AnsiCaseUpper' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_ANSILOWERCASE
CSTRING(254)
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_AnsiCaseLower' MODULE_NAME 'GrUDF';

/* gleiche wie F_ANSILOWERCASE, als Übergangslösung 
DECLARE EXTERNAL FUNCTION LOWER
CSTRING(254)
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'F_AnsiCaseLower' MODULE_NAME 'GrUDF2'; */

DECLARE EXTERNAL FUNCTION F_ADDYEAR
TIMESTAMP, TIMESTAMP, INTEGER
RETURNS PARAMETER 1
ENTRY_POINT 'F_IncYear' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MONTHSTART
TIMESTAMP, SMALLINT, SMALLINT
RETURNS PARAMETER 1
ENTRY_POINT 'F_MonthStart' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MONTHEND
TIMESTAMP, SMALLINT, SMALLINT
RETURNS PARAMETER 1
ENTRY_POINT 'F_MonthEnd' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_LASTDAY
SMALLINT, SMALLINT
RETURNS SMALLINT BY VALUE
ENTRY_POINT 'F_LastDay' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_DAYFRAC
TIMESTAMP
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_DayFrac' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_DAYOFWEEK
TIMESTAMP
RETURNS SMALLINT BY VALUE
ENTRY_POINT 'F_DayOfWeek' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_DAYOFYEAR
TIMESTAMP
RETURNS SMALLINT BY VALUE
ENTRY_POINT 'F_DayOfYear' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_CDOWLONG
TIMESTAMP
RETURNS CSTRING(10) FREE_IT
ENTRY_POINT 'F_CDOWLong' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_CDOWSHORT
TIMESTAMP
RETURNS CSTRING(4) FREE_IT
ENTRY_POINT 'F_CDOWShort' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_CMONTHLONG
TIMESTAMP
RETURNS CSTRING(10) FREE_IT
ENTRY_POINT 'F_CMonthLong' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_CMONTHSHORT
TIMESTAMP
RETURNS CSTRING(4) FREE_IT
ENTRY_POINT 'F_CMonthShort' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_OSTERDATUM
TIMESTAMP,
INTEGER
RETURNS PARAMETER 1
ENTRY_POINT 'F_Ostern' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_WEEKOFYEAR
TIMESTAMP
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_WeekOfYear' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_EQUALDATE
TIMESTAMP,
TIMESTAMP
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_EqualDate' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_EQUALDATETIME
TIMESTAMP,
TIMESTAMP
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_EqualDateTime' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_DOUBLE
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Double' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_FRAC
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Frac' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_INT
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Int' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_TRUNCATE
DOUBLE PRECISION
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_Trunc' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_TRUNCDEC
DOUBLE PRECISION, SMALLINT
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_TruncDec' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_CEIL
DOUBLE PRECISION
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_Ceil' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_FLOOR
DOUBLE PRECISION
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_Floor' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MAX
DOUBLE PRECISION, DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Max' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MIN
DOUBLE PRECISION, DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Min' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_ABS
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Abs' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_DIV
INTEGER, INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_Div' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_MODULO
INTEGER, INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_Mod' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_EXP
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'F_Exp' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_FACTORIAL
INTEGER
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_Factorial' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_AGEINDAYS
TIMESTAMP, TIMESTAMP
RETURNS INTEGER BY VALUE
ENTRY_POINT 'F_DaysBetween' MODULE_NAME 'GrUDF';

DECLARE EXTERNAL FUNCTION F_CHARACTER
    SMALLINT
RETURNS CSTRING(2) FREE_IT
ENTRY_POINT 'F_Chr' MODULE_NAME 'GrUDF'


Der Code bindet die GrUDF ein, welche aber identisch mit der Averp UDF ist. Wenn gewünscht einfach GrUDF durch AvERPUDF ersetzten.

gruss


Christian
Antworten