R. Vajsar wrote:
>
> Oh yes. I'm only looking for relationship between primary key, SYSKEY
and
> error 4005 ("check if the table mentioned has a user-defined primary
key
> (then SYSKEY will NOT exist) or not"). If a view hasn't index, then
SYSKEY
> doesn't exist and error 4005 in this case is a fe
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
FROM
LA
Oh yes. I'm only looking for relationship between primary key, SYSKEY and error 4005
("check if the table mentioned has a user-defined primary key (then SYSKEY will NOT
exist) or not"). If a view hasn't index, then SYSKEY doesn't exist and error 4005 in
this case is a feature?
The primary probl
Hello,
The Synchronization Manager is designed to work with two or more MaxDBs and
additionally with MySQL and MinDB. It does not depend on MinDB.
If you work with MaxDB you can synchronize from master to client and vice versa
with conflict resolution.
If you use MySQL and MinDB as clients you
Alexey Gaidukov wrote :
>
>drop FUNCTION AGE_YEARS
>//
>CREATE FUNCTION AGE_YEARS(date1 date, birthday date) returns
>smallint AS
>VAR
>y smallint;
>m smallint;
>BEGIN
>SET y = year(date1)-year(birthday);
>SET m = month(date1)-month(birthday);
>if m=0 then
>SET y=y+s
[EMAIL PROTECTED] wrote:
> Zabach, Elke пишет:
>
> >[EMAIL PROTECTED] wrote:
> >
> >
> >>Hello, I'm use MaxDB Version: '7.6.00.10 Build 010-121-096-895' for
> >>
> >>
> >LINUX
> >
> >
> >>I have two views ('view 1', 'view 2')
> >>
> >>'view 1' and 'view 2' are at mostly identical (diffe
Hello, I'm use MaxDB Version: '7.6.00.10 Build 010-121-096-895' for LINUX
I have two procedures ('proc 1', 'proc 2'). . 'proc 1' and 'proc 2' are
at mostly identical (difference is only in ' FETCH INTO :sex; ' and
'INTO :sex' ) they should have the same result..
'proc 2' returns char 'M' (i
Thanks a lot for the very quick response.
Regards,
Silke
-Ursprüngliche Nachricht-
Von: Koetter, Thomas Theodor [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 7. Juli 2005 09:50
An: Arnswald, Silke; maxdb@lists.mysql.com
Betreff: RE: MaxDb and 64Bit Xeon
Hello
> -Origina
drop FUNCTION AGE_YEARS
//
CREATE FUNCTION AGE_YEARS(date1 date, birthday date) returns smallint AS
VAR
y smallint;
m smallint;
BEGIN
SET y = year(date1)-year(birthday);
SET m = month(date1)-month(birthday);
if m=0 then
SET y=y+sign(dayofmonth(date1)-dayofmonth(birthday));
Hello
> -Original Message-
> From: Arnswald, Silke [mailto:[EMAIL PROTECTED]
> Sent: Donnerstag, 7. Juli 2005 08:07
> To: maxdb@lists.mysql.com
> Subject: MaxDb and 64Bit Xeon
>
> Hello,
>
> we plan buy a Dell Server with 64-Bit Xeon processor running
> Linux (Suse or Redhat).
> Can w
10 matches
Mail list logo
