Hi,
that is the old 'problem'.
During select which does not result in a copied (physically stored) resultset,
a check is made whether at least one record will fulfill the expected
restrictions.
During this check, the resultrecord is prepared, the qualification handled AND
your funct
Hi Alexander,
In fact using FOR REUSE in a SELECT that calls the function, makes it
work normally. Also using the function in an INSERT statement yields
the expected result.
Thank you,
Martin
--
Dinamica - RADical J2EE framework
open source, easy and powerful
http://www.martincordova.com
On 3
Hello Martin,
can you try to execute the SELECT that triggers the function with a FOR REUSE
added? Does it
change anything?
Alexander Schröder
MaxDB & liveCache
SAP AG
Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher
incremented by 2!!!
I am missing something, any help will be appreciated.
I am using MaxDB 7.6.0.34 on WinXP SP1.
The code:
CREATE FUNCTION XXX.getNumCorrespE (dependencia_id INTEGER) RETURNS VARCHAR AS
VAR ano INTEGER; cnum INTEGER; retval VARCHAR(20);
TRY
SET ano = 0;
SET cnum = 0
write a new function that I add to php extension.
Function called *maxdb_clear_error*, which cleans the errno property.
*diff php_maxdb.h ../maxdb.src/php_maxdb.h
*355d354
< PHP_FUNCTION(maxdb_clear_error);
* diff php_maxdb.c ../maxdb.src/php_maxdb.c
*343d342
< PHP_FALIAS(clear
t test_a (a, b) values (3, 1)
> //
> drop table test_b
> //
> create table test_b
> (
> a int not null,
> b int not null
> )
> //
> insert test_b (a, b) values (1, 1)
> //
> insert test_b (a, b) values (2, 1)
> //
> insert test_b (a, b) values
)
//
insert test_b (a, b) values (3, 1)
//
DROP FUNCTION DBADMIN.getTest
//
CREATE FUNCTION DBADMIN.getTest
( aINT
)
RETURNS INT
AS
VARidINTEGER;
BEGIN
TRY
SELECT b
FROM
dbadmin.test_a
ND CODESTR='9' THEN SET CODESTR1= '0' ;
> IF PREVSTR2<>NULLCOMP AND CODESTR2 AND CODESTR='Z' THEN SET CODESTR1= 'A' ;
> IF CODESTR1 BETWEEN '0' AND '9' THEN SET
> NUMCOD = CODESTR1 & NUMCOD ;
>
R1 FROM SA.SYSMAPCHAR
WHERE DECCODE = (SELECT DECCODE FROM SA.SYSMAPCHAR
WHERE ASCVAL=:CODESTR) + 1;
IF PREVSTR2<>NULLCOMP AND CODESTR2 NULLCOMP AND CODESTR2 NULLCOMP AND CODESTR2 0 AND NUM(NUMCOD) = 0 THEN
SET NEWCODE = ALPHACOD &
SUBSTR(NUMCOD,1,LENGTH(NUMCOD)-1) & '1' ;
I have this definition (in 7.6.0.27, reduced to the bare minimum):
CREATE TABLE dba.testtable (id INTEGER PRIMARY KEY, test INTEGER)
//
INSERT INTO dba.testtable VALUES (1, 1)
//
CREATE FUNCTION dba.testfunc RETURNS INTEGER AS
VAR i INTEGER;
UPDATE dba.testtable SET test = test
Hello Michael,
To get information about your created functions execute "select * from
domain.functions".
Regards
Wolfgang
-Original Message-
From: Michael Neuber [mailto:[EMAIL PROTECTED]
Sent: Montag, 10. Juli 2006 10:36
To: maxdb@lists.mysql.com
Subject: SQLStudio: N
HiHo,
can anybody lead me to right piece of information
how to display Stored Functions in SQL Studio,
and, if this is not possible (why?), how to figure out
how MaxDB (Vs 7.5, 7.6) stored a partiocular function created
with the CREATE FUNCTION command,
or how many functions are stored ?
I
-
CALL BILLING(920,1124,802,0,'pc3.nettle.ru','212.17.4.86','no
referer',0,'anonymous',1,1,3,:out)
Everthing work; We use PHP-ODBC. ODBC can't get result from "CALL
BILLING(920,
maxdb [mailto:[EMAIL PROTECTED] wrote:
> Hi,
>
> I was mistake and take name filed parameter on arg #3 instead
> of arg #1 in
> replace database function. As result the next select was
> cause database
> crash.
>
> select id, replace('\"','&#
Hi,
I was mistake and take name filed parameter on arg #3 instead of arg #1 in
replace database function. As result the next select was cause database
crash.
select id, replace('\"','', name ) from test
Table 'test' was have field 'name' - varchar(
Andreas Goldstein wrote :
>> --- Ursprüngliche Nachricht ---
>> Von: "Anhaus, Thomas" <[EMAIL PROTECTED]>
>> An: "Andreas Goldstein" <[EMAIL PROTECTED]>,
>>
>> Betreff: AW: [FSID] How to drop a public function?
>> D
> --- Ursprüngliche Nachricht ---
> Von: "Anhaus, Thomas" <[EMAIL PROTECTED]>
> An: "Andreas Goldstein" <[EMAIL PROTECTED]>,
>
> Betreff: AW: [FSID] How to drop a public function?
> Datum: Tue, 20 Sep 2005 10:50:16 +0200
>
> Andreas Goldst
Andreas Goldstein wrote :
>
>Hi Listmembers,
>
>I defined a public function on my 7.6.00.12-Windows MaxDB. Now
>I would lik
>to change the function, but I can not drop the old version :(
>
>
>
>Here is what I did in more detail:
>
>Logged into the DB-instanc
Hi Listmembers,
I defined a public function on my 7.6.00.12-Windows MaxDB. Now I would lik
to change the function, but I can not drop the old version :(
Here is what I did in more detail:
Logged into the DB-instance as DBAdmin
CREATE PUBLIC FUNCTION KDSUMME ...
Worked well
Now I would like
2005/9/7, Xavier CAMIER <[EMAIL PROTECTED]>:
> Good morning,
>
> Curiosity is a bad habit but here are the explanations ;-)
>
> - The app users can create new records.
> - The records are made of a Code, a Description, a Price and a Group.
> - The Code is mask free but if the user wants to adopt
do it
programmatically and I'm still confident with MaxDB :-)
Kind regards
Xav
Zabach, Elke a écrit :
Xavier CAMIER wrote:
Good morning,
I'd need a random function to choose a line sample of a table. In
searching into the mailing I found that "Eric Jain" unsucessfuly
Xavier CAMIER wrote:
>
> Good morning,
>
> I'd need a random function to choose a line sample of a table. In
> searching into the mailing I found that "Eric Jain" unsucessfuly asked
> such a question on August 2002. Is there something new since ?
>
>
Xav wrote:
> I'd need a random function to choose a line sample of a table. In
> searching into the mailing I found that "Eric Jain"
> unsucessfuly asked
> such a question on August 2002. Is there something new since ?
What exactly do you want to accomplish?
Is it
Good morning,
I'd need a random function to choose a line sample of a table. In
searching into the mailing I found that "Eric Jain" unsucessfuly asked
such a question on August 2002. Is there something new since ?
Kind regards
Xav
--
MaxDB Discussion Mailing List
For list
function
doesn't return anything. If I remove the Try...Catch statement
(including the loop it contains) the function works as expected
Could someone help me to understand what my mistake with this
Try...Catch block is ?
When I create a stored procedure( REMPLACEFONCTIONPROC ). It works.
Than
Hello,
Here is a test function which should help me do understand some MaxDB
basics. There is an IN parameter which should be returned at the end of
the process. But it doesn't work as expected.
According to my tests :
- Each Try...Catch... statement is executed as values are inserted
Vincent Robidet wrote :
>
>MaxDB 7.6.0.12
>SqlStudio 7.6.0.12
>
>Hello,
>
>I can't explain why the function Remplacefonctions68 returns
>'youpi' and
>the function remplacefonctions69 returns nothing.
>Could someone help me ?
>
>Thanks in advan
MaxDB 7.6.0.12
SqlStudio 7.6.0.12
Hello,
I can't explain why the function Remplacefonctions68 returns 'youpi' and
the function remplacefonctions69 returns nothing.
Could someone help me ?
Thanks in advance
Best regards
Vincent Robidet
CREATE FUNCTION REMPLACEFONCTIONS69(
Zabach, Elke wrote:
hello!
>>i'm looking for an SQL function that returns the position of a character
>>or substring in a string (indexof(), strstr() or the like) and was
>>rather surprised that there is nothing in the docs (or i just can't find
>>it).
>
Raimund Jacob wrote:
>
> hello list!
>
> i'm looking for an SQL function that returns the position of a character
> or substring in a string (indexof(), strstr() or the like) and was
> rather surprised that there is nothing in the docs (or i just can't find
> it)
hello list!
i'm looking for an SQL function that returns the position of a character
or substring in a string (indexof(), strstr() or the like) and was
rather surprised that there is nothing in the docs (or i just can't find
it).
is there such a function (in 7.5) ?
my actual goal is
Rusanov wrote :
>
>Hello, I'm use MaxDB Version: '7.6.00.10 Build
>010-121-096-895' for LINUX
>
>
>I try create function CREATE FUNCTION LAB.AgeInInterval
>
>
>
> Error ---
>Auto Commit: On, SQL Mode: Internal, Isola
Rusanov wrote :
>
>Test this is example
>
>CREATE TABLE TEST
>(
>nINT NOT NULL,
>vVARCHAR(1) NOT NULL
>)
>
>INSERT TEST (n, v) VALUES (1, '1')
>
>CREATE FUNCTION LAB.func_test1
>( n INT
>)
>
>RETURN
Try test simple example
'LAB' is my schema
DROP FUNCTION LAB.test1
//
CREATE FUNCTION LAB.test1
RETURNS smallint
AS
BEGIN
return 1;
END;
//
DROP FUNCTION LAB.test2
//
CREATE FUNCTION LAB.test2
RETURNS smallint
AS
VAR a smallint;
BEGIN
IF LAB.test1() = 1 THEN
Hello, I'm use MaxDB Version: '7.6.00.10 Build 010-121-096-895' for LINUX
I try create function CREATE FUNCTION LAB.AgeInInterval
Error ---
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-4030 POS(1) Unknown sche
Test this is example
CREATE TABLE TEST
(
nINT NOT NULL,
vVARCHAR(1) NOT NULL
)
INSERT TEST (n, v) VALUES (1, '1')
CREATE FUNCTION LAB.func_test1
( n INT
)
RETURNS VARCHAR
AS
VARvVARCHAR(1);
BEGIN
SELECT v
INTO :v
:sex' ) they should have the same result..
'proc 2' returns char 'M' (it is succeded result), but 'proc 1' has no
result and doesn't throw exception.
I call function in select 'select LAB.getPatientSex(2400) from dual'
'proc 1':
CRE
chroeder, Alexander пишет:
You should explizitely specify the length, i.e.
CREATE DBPROC test(IN p VARCHAR(10)) AS
BEGIN
INSERT INTO table(field)
VALUES (substr(:p,3,1));
END;
otherwise 1 is assumed as length, which renders your substr function call
invalid.
See
http://dev.
You should explizitely specify the length, i.e.
CREATE DBPROC test(IN p VARCHAR(10)) AS
BEGIN
INSERT INTO table(field)
VALUES (substr(:p,3,1));
END;
otherwise 1 is assumed as length, which renders your substr function call
invalid.
See
http://dev.mysql.com/doc/maxdb/en/03
I'm using MaxDB 7.6.00.10
--- Begin Message ---
CREATE DBPROC test(IN p varchar) AS
BEGIN
INSERT INTO table(field)
VALUES (substr(:p,3,1));
END;
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-3046 POS(319) Invalid char position in string function
C
CREATE DBPROC test(IN p varchar) AS
BEGIN
INSERT INTO table(field)
VALUES (substr(:p,3,1));
END;
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-3046 POS(319) Invalid char position in string function
CREATE DBPROC test(IN p varchar) AS
VAR
pp varchar
Thanks! elke
From: "Zabach, Elke" <[EMAIL PROTECTED]>
To: "? ?" <[EMAIL PROTECTED]>,
Subject: AW: string function
Date: Wed, 22 Jun 2005 11:07:29 +0200
[EMAIL PROTECTED] wrote
>
> How can i get the start-position of string "s1" in string "s
[EMAIL PROTECTED] wrote
>
> How can i get the start-position of string "s1" in string "s2".
> e.g. S1 = name
> S2 = myname.
> start-position is 2.(Begin position is zero)
>
As the reference-manual tells us:
http://dev.mysql.com/doc/maxdb/en/cd/c300ebb9b011d2a97100a0c9449261/frameset.htm
How can i get the start-position of string "s1" in string "s2".
e.g. S1 = name
S2 = myname.
start-position is 2.(Begin position is zero)
_
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--
MaxDB Discussion Ma
Alexey Gaidukov wrote :
>
>Thank you for answer.
>
>I have one more question. I have two RESOURCE USERS: GIS and REG.
>
> From GIS user:
>
>CREATE FUNCTION GIS.TEST(..) RETURN BOOLEAN AS
>
>GRANT EXECUTE ON TEST TO REG
>
> From REG user the following comp
Thank you for answer.
I have one more question. I have two RESOURCE USERS: GIS and REG.
From GIS user:
CREATE FUNCTION GIS.TEST(..) RETURN BOOLEAN AS
GRANT EXECUTE ON TEST TO REG
From REG user the following compiles WITHOUT errors
CREATE DBPROC REG.PROC(IN p integer)
RETURNS CURSOR AS
Alexey Gaidukov wrote :
>Gesendet: Dienstag, 21. Juni 2005 12:57
>An: maxdb@lists.mysql.com
>Betreff: Can't create function with varchar argument
>
>
>I'm using 7.6.00.10.
>
>
>CREATE FUNCTION GIS.GET_TARIF (
>p_resid varchar,
>p_date date) re
I'm using 7.6.00.10.
CREATE FUNCTION GIS.GET_TARIF (
p_resid varchar,
p_date date) returns FIXED(20,2) AS
VAR
f FIXED(20,2);
BEGIN
select tarif into :f from gis.fullrestype where resid=:p_resid;
return f;
END;
Auto Commit: On, SQL Mode: Internal, Isolation Level: Comm
: Mittwoch, 1. Juni 2005 10:02
To: maxdb@lists.mysql.com
Subject: Webdav, Server Crash
Good morning,
Yet an another post about Webdav :-) We are trying to find url of files
stored
into a webdav server to give the user an human readable file path. We
created
that function to do it :
CREATE FUNCTION
Alexei Novakov wrote:
> --- Jey Razack <[EMAIL PROTECTED]> wrote:
>> DB Version : 7.5.00.24
>> OS Redhat 2.4.22-1.2199 i686 athlon i386 GNU/Linux
>>
>> Immediately after data insert (COMMIT after each
>> insert), the 'COUNT' function on a table (
Hi Jey
--- Jey Razack <[EMAIL PROTECTED]> wrote:
> DB Version : 7.5.00.24
> OS Redhat 2.4.22-1.2199 i686 athlon i386 GNU/Linux
>
> Immediately after data insert (COMMIT after each
> insert), the 'COUNT' function on a table (2.3
> million records)
> ge
Jey Razack wrote:
> DB Version : 7.5.00.24
> OS Redhat 2.4.22-1.2199 i686 athlon i386 GNU/Linux
>
> Immediately after data insert (COMMIT after each insert), the
> 'COUNT' function on a table (2.3 million records)
> generates wrong result (higher than the actu
DB Version : 7.5.00.24
OS Redhat 2.4.22-1.2199 i686 athlon i386 GNU/Linux
Immediately after data insert (COMMIT after each insert), the 'COUNT' function
on a table (2.3 million records)
generates wrong result (higher than the actual).
Select fld1,count(*) from t1 Where ... group b
John Singleton wrote:
>
> Hello all,
>
> Quick question: Should this work?
>
> >select LOG(2, 65536) from dual
>
> Whenever I execute this I get:
>
> * -5016: Missing delimiter: ) SQLSTATE: 42000
>
> Am I doing something wrong? I have to be missing something...
>
Sometimes I hate JDBC/ODBC
Hello all,
Quick question: Should this work?
>select LOG(2, 65536) from dual
Whenever I execute this I get:
* -5016: Missing delimiter: ) SQLSTATE: 42000
Am I doing something wrong? I have to be missing something...
Thanks!
JLS
PS: I'm using 7.5.00.19...
--
MaxDB Discussion Mailing List
F
There are a number of repetitive actions to be taken on result tables in
different stored procedures.
I wanted to create a function to which I can pass a reference to a
result table name.
The result table is created in the calling stored procedure with
"declare cursor for select for
Hi Thomas,
I knew, I had forgotten something... we are currently using
MaxDB 7.5.00.23 on Linux
Another weired thing:
I can create a Function using "create public function foo", I can use it
and I can delete it with "drop public function foo". But after dropping
it, I cant re
Hi there,
hopefully someone can help me:
after creating a function as:
create public function TESTFUNC2 (FALLNR fixed(16)) RETURNS CHAR(1) AS IF
FALLNR < 999 then return 'S'; if FALLNR < 99 then
return 'A'
else return 'T';
I am unable t
Hallo,
> -Ursprüngliche Nachricht-
> Von: Josu [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 7. Februar 2005 16:52
> An: Zabach, Elke
> Betreff: Re: AW: question about ALPHA and SOUNDEX function
>
> ALPHA issue:
>
> We have an unicode database but the colum
ALPHA () is of no use.
>
> And other issue . we haven't found what is the soundex function
> used and how to customize it because we are spanish speakers! We try
> to use sounds and soundex to accomplish:
>
> Input "Niza" (Nice in spanish) -> Give result
)
It results in an error with the datetype in alpha(->keyword<-), it
seems that it doesnt accept literals¿?
And other issue . we haven't found what is the soundex function
used and how to customize it because we are spanish speakers! We try
to use sounds and soundex to accomplish:
In
Hi,
why does this
CREATE FUNCTION normal_like (s1 varchar, s2 varchar) RETURNS BOOLEAN AS
SET s1 = LOWER(s1);
SET s2 = LOWER(s2);
IF LENGTH(s1) > LENGTH(REPLACE(s1, s2)) THEN RETURN TRUE
ELSE RETURN FALSE;
//
SELECT normal_like('abc', 'b') FROM sysdba.dual
fail with the er
Dezember 2004 11:06
To: [EMAIL PROTECTED]
Subject: PHP function maxdb_options: Parameter mismatch
Hi,
Using this function as described in
http://dev.mysql.com/doc/maxdb/pdf/php_presentation.pdf:
maxdb_options($link, MAXDB_UNICODE, TRUE);
fails:
Warning: maxdb_options() expects exactly 2 par
Hi,
Using this function as described in
http://dev.mysql.com/doc/maxdb/pdf/php_presentation.pdf:
maxdb_options($link, MAXDB_UNICODE, TRUE);
fails:
Warning: maxdb_options() expects exactly 2 parameters, 3 given in ..
By looking in the source (php_maxdb.c) i found out, that this function
Can the help-page / document authors please re-visit the pages concerning
the creation of stored procedures/functions?
The pages are too light on detail, and phrases such as "..control structures
are also available for the application programmer. You can program loops or
branches..." (in page
htt
Filip Sergeys wrote:
>
> Hello,
>
> When evaluating a math formula stored in a cell and convert the result
> back into a string, The returnvalue is strange
> Example:
> stored in the cell 7+7
>
> SELECT num(substr(nbreplace,1,1)) + num(substr(nbreplace,3,1))
> result: 4
>
> SELECT chr(num(sub
Forgot to mention:
Maxdb version: 7.5.00.14
OS: linux
On Mon, 2004-07-26 at 12:49, Filip Sergeys wrote:
> Hello,
>
> When evaluating a math formula stored in a cell and convert the result
> back into a string, The returnvalue is strange
> Example:
> stored in the cell 7+7
>
> SELECT num(substr
Hello,
When evaluating a math formula stored in a cell and convert the result
back into a string, The returnvalue is strange
Example:
stored in the cell 7+7
SELECT num(substr(nbreplace,1,1)) + num(substr(nbreplace,3,1))
result: 4
SELECT chr(num(substr(nbreplace,1,1)) + num(substr(nbreplace,3,1
.
The function Translate_dictionary_key is the following
CREATE FUNCTION TRANSLATE_DICTIONARY_KEY(KEY CHAR(100), LANGUAGE FIXED(6,0),
DEFAULT_WORD CHAR(100)) RETURNS VARCHAR AS
VAR RES VARCHAR(4000);
TRY
SET RES = DEFAULT_WORD;
SELECT N_WORD
INTO :RES
FROM PSF.DICTIONARY
WHERE
Matteo Gattoni wrote:
> HI,
> I'm still trying to fetch datas in a recursive function. Waiting for
> your responses to my latest email (that follows), I've tried changing the
> structure of my algorithm.
> Now I use a function that is called in an update st
Matteo Gattoni wrote:
>
> HI,
> the problem 'General error;-915 POS(375) No more
> memory:CAT_CACHE_SUPPLY.' is due to the recursive call of the function.
> Deleting it from the body of the function, in this way
>
> DROP FUNCTION FIX_TREE_D
> //
> CREATE
HI,
the problem 'General error;-915 POS(375) No more memory:CAT_CACHE_SUPPLY.' is due to
the recursive call of the function.
Deleting it from the body of the function, in this way
DROP FUNCTION FIX_TREE_D
//
CREATE FUNCTION FIX_TREE_D( father fixed(9,0), child fixed, prefix CHA
HI,
I'm still trying to fetch datas in a recursive function. Waiting for your responses
to my latest email (that follows), I've tried changing the structure of my algorithm.
Now I use a function that is called in an update statement like:
UPDATE PSF.ACTIVITY_RELATIONSHIP set C
Labs Berlin
> -Original Message-
> From: Matteo Gattoni [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 22, 2004 3:31 PM
> To: [EMAIL PROTECTED]
> Subject: ORDER BY in FUNCTION
>
>
> HI,
> I use a select statement in a function; everything goes if
>
HI,
I use a select statement in a function; everything goes if the select statement
doesn't contain an ORDER BY clause.
The error returned is always
Syntax error or access violation;-3014 POS(357) Invalid end of SQL statement.
If I create a Cursor using the same select Statement, it goes
It works on 7.5.01 alpha...
I had problem using 7.5.00
thanks anyway
joannes
- Original Message -
From: Joannes Capitanio
To: [EMAIL PROTECTED]
Sent: Saturday, June 12, 2004 11:55 AM
Subject: Function parameters value after another function call
Hi,
We wrote the
Matteo Gattoni wrote:
>
> Hello,
> I'm using MaxDb version 7.5.01.00.
> I have a function TO_CHAR2 owned by user PPORTAL that receives a float and
> give me back a char value.
>
> The function is created like this in Oracle mode (the grant in Internal
> mode beca
Using the same function, in a more complex sql statement, I receive the error
General error;-602 System error: Move error.
The query is the following. The function is used only in first subquery
SELECT
(SELECT pportaL.TO_CHAR2(Max(TO_NUMBER(K_KEY) +1)) FROM REGISTRY_TREE),
'app
Hello,
I'm using MaxDb version 7.5.01.00.
I have a function TO_CHAR2 owned by user PPORTAL that receives a float and give me
back a char value.
The function is created like this in Oracle mode (the grant in Internal mode because
they don't work in oracle mode)
DROP FUNCTION TO_CHAR2
Hi,
We wrote the following function like an entry point for a particular user's permission
function:
Here's the source of the function...
CREATE FUNCTION HASPERMONMENU (
MENUENTRYID CHAR(50),
GRANTEDCOMPANYID FIXED(9,0),
GRANTEDHUMANRESOURCEID FIXED(9,0),
GRANTE
> -Ursprüngliche Nachricht-
> Von: Gianluca Sensidoni [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 3. Juni 2004 11:33
> An: [EMAIL PROTECTED]
> Betreff: to_date function - Oracle to MaxDB
>
> Hi to all
> We are working for a porting from Oracle to MaxDB. In
I mean something like this:
CREATE FUNCTION TEST(VAL INT) RETURNS NUMBER AS
BEGIN
IF VAL < 5 THEN RETURN TEST(VAL+1)
ELSE RETURN VAL;
END;
it's just an example of course...
thanks in advance
joannes
- Original Message -
From: "Zabach, Elke" <[EMAIL PROT
Joannes Capitanio wrote:
>
> Is it possible to create recursive function inside maxdb?
>
What do you mean with 'recursive function' ?
Are we talking about recursive selects as described here?
http://dev.mysql.com/doc/maxdb/en/a7/41ee26605911d3a98800a0c9449261/frameset.htm
E
Is it possible to create recursive function inside maxdb?
thanks in advance
joannes
Hi to all
We are working for a porting from Oracle to MaxDB. Inside our project there are a lot
of query with data comparison through the to_date function and we use the DD/MM/
date format, on the contrary MaxDB uses the ISO format -MM-DD.
We don't want to change the date format a
"sqlprc()" to extract
> precision and scale
> from NUMBER datatype.
Hi,
A trace back will be helpful. To prevent you to made a complete debug build you can
include the
actual implementation of the sqlprc function into your cpc program and compile it with
debugging switched on
Hello,
I migrated an oracle application to maxdb7.5.0.11 for solaris(64bit) and
compiled under ORACLE MODE.
i got a "bus error" when using "sqlprc()" to extract precision and scale
from NUMBER datatype.
Anybody help me?
_
免费下载 MSN
news wrote:
>
>
> Hello, all.
>
> I'm having trouble with a brand new instance of 7.5.0.8.
> The DAYNAME
> function always returns null (e.g. SELECT DAYNAME(DATE) FROM
> SYSDBA.DUAL).
> This has not happened with other instances we've created with
Hello, all.
I'm having trouble with a brand new instance of 7.5.0.8. The DAYNAME
function always returns null (e.g. SELECT DAYNAME(DATE) FROM SYSDBA.DUAL).
This has not happened with other instances we've created with this version.
Does anyone know how I can track this down
; Hmmm ! instance crashes at early tries...
>
> For now I tried some insert using this dbfunction:
>
> INSERT INTO TABLENAME
> VALUES
> ((SELECT FUNC_IDSOCIETE ('val1', 'val2') FROM DUAL), other values...)
>
> and error message is: 'unknown table
news [mailto:[EMAIL PROTECTED] Behalf Of Kostadin
> Bajalcaliev wrote:
> Sent: Freitag, 27. Februar 2004 01:30
> To: [EMAIL PROTECTED]
> Subject: GRANT EXECUTE ON FUNCTION
>
>
> I want to use functions in MaxDB, but it is not clear how to
> grant execute
> privil
I want to use functions in MaxDB, but it is not clear how to grant execute
privilege.
For example a simple next_num function can be created as
CREATE FUNCTION NEXT_NUM (N INTEGER) RETURNS INTEGER AS
RETURN N + 1;
But
GRANT EXECUTE ON NEXT_NUM TO PUBLIC
--->
General error;-4016 POS
you know, that I've noticed
> >SAP DB is acting really strange when non-existing function
> >is used in SELECT clause.
> >For example:
> >SELECT SILLY_NAME_OF_FUNCTION(MY_COLUMN) FROM MY_TABLE,
> >returns all rows from MY_TABLE for column MY_COLUMN.
> >IM
Marcin wrote :
>Hello,
>I just would like to let you know, that I've noticed
>SAP DB is acting really strange when non-existing function
>is used in SELECT clause.
>For example:
>SELECT SILLY_NAME_OF_FUNCTION(MY_COLUMN) FROM MY_TABLE,
>returns all rows from MY_TABLE f
news wrote:
>
> Hello,
> I just would like to let you know, that I've noticed
> SAP DB is acting really strange when non-existing function
> is used in SELECT clause.
> For example:
> SELECT SILLY_NAME_OF_FUNCTION(MY_COLUMN) FROM MY_TABLE,
> returns all rows from
Hello,
I just would like to let you know, that I've noticed
SAP DB is acting really strange when non-existing function
is used in SELECT clause.
For example:
SELECT SILLY_NAME_OF_FUNCTION(MY_COLUMN) FROM MY_TABLE,
returns all rows from MY_TABLE for column MY_COLUMN.
IMHO some error that the
Yes, I in accord with you $2K for support on that database is
wonderfull.
Suggestions:
1) Work with the community, not against us. Sell support in reasonable
prices (I think they are not so bad today - I need to re-check), and
don't charge for theese unstable builds.
2) Put the features all of u
ginal Message-
From: Edson Carlos Ericksson Richter
[mailto:[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 12:25 PM
To: MaxDB
Subject: Re: Support for older releases (was: really need long varchar
search function ...)
Look you all, the idea is forcing all to buy licences from MySQL. Just
dro
Look you all, the idea is forcing all to buy licences from MySQL. Just
drop out this idea.
People want buy real support for the version they want to run. I'll
never upgrade to instable 7.5 version (event with all the known problems
7.4 has today). 7.5 (AFAIK) hasn't a changes list avaliable to us.
Le vendredi 23 janvier 2004, Dittmar, Daniel a écrit...
bonjour,
> We generally do support older releases for a long time. But MySQL AB is starting to
> build a business around MaxDB, and this would be more difficult if there is still
> the competition of SAP DB, which places less restr
1 - 100 of 119 matches
Mail list logo
