Linux Datenbank

[Gast]

Guten Tag,

gibt es auch die Linux Datenbank komplett leer ?

Da die Datenbank, welche ich runtergeladen habe einige Musterdatensätze enthält.

MfG

Sebastian Wilk

[Gast]

Hi,

hab jetzt die leere DB von AvERP genommen und mit dem unten genannten Script bearbeitet.
Hat jemand mit dieser vorgehensweise Erfahrungen, ob die DB stabil läuft?

Gruss

Sebastian Wilk

Zum löschen der Funktionen kann folgendes Skript verwendet werden:

Code: Alles auswählen

/*******************************************************************************
 * Skript zum entfernen der UDF Funktionen aus der AvERP Datenbank
 *
 * Autor: Heiko Hänsel
 * Stand: 22.04.2005
 ******************************************************************************/
DROP EXTERNAL FUNCTION ABS;
DROP EXTERNAL FUNCTION ASCII_CHAR;
DROP EXTERNAL FUNCTION ASCII_VAL;
DROP EXTERNAL FUNCTION F_ADDMONTH;
DROP EXTERNAL FUNCTION F_ADDYEAR;
DROP EXTERNAL FUNCTION F_AGEINDAYS;
DROP EXTERNAL FUNCTION F_AGEINDAYSTHRESHOLD;
DROP EXTERNAL FUNCTION F_AGEINMONTHS;
DROP EXTERNAL FUNCTION F_AGEINMONTHSTHRESHOLD;
DROP EXTERNAL FUNCTION F_AGEINWEEKS;
DROP EXTERNAL FUNCTION F_AGEINWEEKSTHRESHOLD;
DROP EXTERNAL FUNCTION F_ANSILOWERCASE;
DROP EXTERNAL FUNCTION F_ANSIUPPERCASE;
DROP EXTERNAL FUNCTION F_BIGLRTRIM;
DROP EXTERNAL FUNCTION F_BIGSTRINGLENGTH;
DROP EXTERNAL FUNCTION F_BIGSUBSTR;
DROP EXTERNAL FUNCTION F_BLOBASPCHAR;
DROP EXTERNAL FUNCTION F_BLOBLEFT;
DROP EXTERNAL FUNCTION F_BLOBLINE;
DROP EXTERNAL FUNCTION F_BLOBMAXSEGMENTLENGTH;
DROP EXTERNAL FUNCTION F_BLOBMID;
DROP EXTERNAL FUNCTION F_BLOBRIGHT;
DROP EXTERNAL FUNCTION F_BLOBSEGMENTCOUNT;
DROP EXTERNAL FUNCTION F_BLOBSIZE;
DROP EXTERNAL FUNCTION F_CDOWLONG;
DROP EXTERNAL FUNCTION F_CDOWSHORT;
DROP EXTERNAL FUNCTION F_CHARACTER;
DROP EXTERNAL FUNCTION F_CLOSEDEBUGGEROUTPUT;
DROP EXTERNAL FUNCTION F_CMONTHLONG;
DROP EXTERNAL FUNCTION F_CMONTHSHORT;
DROP EXTERNAL FUNCTION F_CRLF;
DROP EXTERNAL FUNCTION F_DAYOFMONTH;
DROP EXTERNAL FUNCTION F_DAYOFWEEK;
DROP EXTERNAL FUNCTION F_DAYOFYEAR;
DROP EXTERNAL FUNCTION F_DEBUG;
DROP EXTERNAL FUNCTION F_DOLLARVAL;
DROP EXTERNAL FUNCTION F_DOUBLEABS;
DROP EXTERNAL FUNCTION F_EQUALDATE;
DROP EXTERNAL FUNCTION F_EQUALDATETIME;
DROP EXTERNAL FUNCTION F_EQUALFLOAT;
DROP EXTERNAL FUNCTION F_EQUALINTEGER;
DROP EXTERNAL FUNCTION F_EQUALSTRING;
DROP EXTERNAL FUNCTION F_EVALUATECYCLEEXPRESSION;
DROP EXTERNAL FUNCTION F_EVALUATEEXPRESSION;
DROP EXTERNAL FUNCTION F_FINDNTHWORD;
DROP EXTERNAL FUNCTION F_FINDWORD;
DROP EXTERNAL FUNCTION F_FINDWORDINDEX;
DROP EXTERNAL FUNCTION F_FIXEDPOINT;
DROP EXTERNAL FUNCTION F_GENERATEFORMATTEDNAME;
DROP EXTERNAL FUNCTION F_GENERATESNDXINDEX;
DROP EXTERNAL FUNCTION F_IBPASSWORD;
DROP EXTERNAL FUNCTION F_IBTEMPPATH;
DROP EXTERNAL FUNCTION F_ISDIVISIBLEBY;
DROP EXTERNAL FUNCTION F_LEFT;
DROP EXTERNAL FUNCTION F_LINEWRAP;
DROP EXTERNAL FUNCTION F_LRTRIM;
DROP EXTERNAL FUNCTION F_LTRIM;
DROP EXTERNAL FUNCTION F_MAXDATE;
DROP EXTERNAL FUNCTION F_MID;
DROP EXTERNAL FUNCTION F_MINDATE;
DROP EXTERNAL FUNCTION F_MODULO;
DROP EXTERNAL FUNCTION F_MONTH;
DROP EXTERNAL FUNCTION F_OSTERDATUM;
DROP EXTERNAL FUNCTION F_PADLEFT;
DROP EXTERNAL FUNCTION F_PADRIGHT;
DROP EXTERNAL FUNCTION F_PROPERCASE;
DROP EXTERNAL FUNCTION F_PROZENTE;
DROP EXTERNAL FUNCTION F_QUARTER;
DROP EXTERNAL FUNCTION F_REPLACESTRING;
DROP EXTERNAL FUNCTION F_RIGHT;
DROP EXTERNAL FUNCTION F_ROUNDFLOAT;
DROP EXTERNAL FUNCTION F_RTRIM;
DROP EXTERNAL FUNCTION F_SETDEBUGGEROUTPUT;
DROP EXTERNAL FUNCTION F_STRBLOB;
DROP EXTERNAL FUNCTION F_STRINGLENGTH;
DROP EXTERNAL FUNCTION F_STRIPDATE;
DROP EXTERNAL FUNCTION F_STRIPSTRING;
DROP EXTERNAL FUNCTION F_STRIPTIME;
DROP EXTERNAL FUNCTION F_SUBSTR;
DROP EXTERNAL FUNCTION F_TRUNCATE;
DROP EXTERNAL FUNCTION F_VALIDATECYCLEEXPRESSION;
DROP EXTERNAL FUNCTION F_VALIDATENAMEFORMAT;
DROP EXTERNAL FUNCTION F_VALIDATEREGULAREXPRESSION;
DROP EXTERNAL FUNCTION F_VALIDATESTRINGINRE;
DROP EXTERNAL FUNCTION F_WEEKOFYEAR;
DROP EXTERNAL FUNCTION F_WOY;
DROP EXTERNAL FUNCTION F_YEAR;
DROP EXTERNAL FUNCTION F_YEAROFYEAR;
DROP EXTERNAL FUNCTION F_ZAHLRUNDEN;
DROP EXTERNAL FUNCTION F_ZEITDIFFERENZ;
DROP EXTERNAL FUNCTION LOWER;
COMMIT WORK;
SHOW FUNCTIONS;

Folgende Ausgabe sollte beim Ausführen des Skriptes erscheinen:

Code: Alles auswählen

There are no user-defined functions in this database

Das bedeutet, alle Funktionen sind gelöscht.

Nun kann das folgende modifizierte Skript für die Registrierung der Funktionen aus der GrUDF Bibliothek ausgeführt werden:

Code: Alles auswählen

/* GrUDF - UDF for Interbase 6.x and Firebird 1.x
           designed for Delphi and Kylix

  Author...:  Torsten Grundke und Ergänzungen von Gerd Kroll
  E-mail...:  tgrundke@freenet.de
              gerd.kroll@tiscali.de

  This library is Open-Source!
  letzter Stand: 26.04.2004 Gerd Kroll  */

/*******************************************************************************
/* Änderungen:
	 22.04.2005 Heiko Hänsel
	 	Name der Funktion von F_ABS in ABS geändert, das sonst Fehler in der
	 	Bestelltansaktion.
*******************************************************************************/

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 'GrUDF';

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 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_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';

COMMIT WORK;

AvERP sollte nun wieder einwandfrei starten.

Gruß
Heiko

[gnom]

Hallo Sebastian,

ich habe AvERP auf Linux nur einmal zum Testen installiert, über die Stabilität im Produktivbetrieb kann ich nichts sagen.
Ich glaube "festus01" nutzt AvERP inteniv unter Linux.

Viele Grüße
Heiko Hänsel

[festus01]

Hallo Heiko, hallo Sebastian

Hallo Sebastian,

...

Ich glaube "festus01" nutzt AvERP inteniv unter Linux.

Viele Grüße
Heiko Hänsel

Ja, das ist richtig und ich kann sagen das die Datenbank sehr gut unter Linux läuft. Ich habe da noch nie einen Absturz (was ist das ) oder sonstiges Fehlverhalten feststellen können.

Allerdings sollte auf dem Server die CS-Version und nicht die SS-Version installiert werden. Bei der SS-Version macht Firebird bei mehreren Benutzern ab und zu mal einen Reset, der bewirkt das alle angemeldeten User abgemeldet werden. Dieses Verhalten konnte ich bei der CS-Version noch nicht feststellen.

[Gast]

Hallo Festus,

hast du die Datenbank mit dem oben genannten Skript bearbeitet, oder verwendest du die Linux Demo DB, oder vielleicht was anderes ?

Gruss

Sebastian

[festus01]

Hallo Sebastian,

...

hast du die Datenbank mit dem oben genannten Skript bearbeitet, oder verwendest du die Linux Demo DB, oder vielleicht was anderes ?

Gruss

Sebastian

nein, ich habe hier die A1 Version auf dem Linuxserver laufen. Ich hatte da auch am Anfang einige Probleme zu bewältigen bevor es dann richtig lief.

Also ich hatte mir die Version A1 heruntergeladen und erst einmal local mit dem Interbaseserver darauf zugegriffen (mit IBExpert).
Dann habe ich einfach die UDFs auf die GRUDF Bibliothek umgebogen und ein Backup gefahren.
Danach ein Restore auf dem Linuxserver und die Sache war OK (so dachte ich).

Es gibt da nur einige UDFs die in der GRUDF nicht vorhanden sind. Diese UDFs habe ich einfach aus der Datenbank gelöscht.
Laut SynERPy sollte auch niemals auf eine UDF zugegriffen werden die nicht in der GRUDF deklariert ist.
Leider hat sich das dann mit der Version A3 geändert und deshalb muss man sich noch die IBUDF für Linux besorgen in der die anderen UDFs deklariert sind.
So ausgerüstet dürfte es dann kein Problem sein die Datenbank unter Linux zum Laufen zu bringen.

[ctheuring]

Hallo Festus,

hast du die Datenbank mit dem oben genannten Skript bearbeitet, oder verwendest du die Linux Demo DB, oder vielleicht was anderes ?

Gruss

Sebastian

Hallo,

wir haben die FreeAdhocUDF gemacht, die kompatibel zur FreeUDFLib UND GrUDF ist (und alles für AvERP notwendige enthält) und unter "allem kreuz und quer läuft" (Backup Windows InterBase6, Restore Linux FireBird1.5 etc.)
Wir haben AvERP damit laufen.
Wenn Interesse, bitte eMail info@adhoc-data.de
(oder bei IBExpert runterladen)

Christoph