[prev in list] [next in list] [prev in thread] [next in thread]
List: solid
Subject: RE: Questions
From: "Semion Simkin" <ssimkin () nortelnetworks ! com>
Date: 2001-05-01 20:42:11
[Download RAW message or body]
As you can see from Timo's response, the SQLERRNUM
variable should be available within a stored procedure
Unfortunately this is NOT the case in SOLID Server v.02.30.0026
I'm currently running
Does anyone know the correct name of the variable
I can use in stored procedure to check the numeric
SQL error code?
Thanks,
Semion Simkin
Nortel Networks
-----Original Message-----
From: Timo Hotti [mailto:timo.hotti@solidtech.com]
Sent: Friday, April 27, 2001 4:50 PM
To: solid-list@solidtech.com
Subject: Re: Questions
Semion,
On 4/27/2001 10:22:19 AM, "Semion Simkin" wrote:
>1) Does anyone know whether I can add a column to an
> existing table and make it a Foreign Key to another table
> without dropping the original table? Is their a way in SOLID
> to disable/enable RI constraints?
In Solid, keys cannot be altered. Neither can existing keys be dropped or
disabled. This applies to both primary and foreign keys.
>2) SOLID doesn't recognize SQLERRCODE variable within
> a stored procedure despite the fact it's mentioned in the
> Programmers Guide.
> Does anyone know how I can check for specific sql error code
> within stored procedure?
Our documentation has a bug here. The correct variable name is SQLERRNUM.
Regards,
Timo
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.59">
<TITLE>RE: Questions</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>As you can see from Timo's response, the SQLERRNUM</FONT>
<BR><FONT SIZE=2>variable should be available within a stored procedure</FONT>
</P>
<P><FONT SIZE=2>Unfortunately this is NOT the case in SOLID Server \
v.02.30.0026</FONT> <BR><FONT SIZE=2>I'm currently running</FONT>
</P>
<P><FONT SIZE=2>Does anyone know the correct name of the variable</FONT>
<BR><FONT SIZE=2>I can use in stored procedure to check the numeric</FONT>
<BR><FONT SIZE=2>SQL error code?</FONT>
</P>
<P><FONT SIZE=2>Thanks,</FONT>
<BR><FONT SIZE=2>Semion Simkin</FONT>
<BR><FONT SIZE=2>Nortel Networks</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Timo Hotti [<A \
HREF="mailto:timo.hotti@solidtech.com">mailto:timo.hotti@solidtech.com</A>]</FONT> \
<BR><FONT SIZE=2>Sent: Friday, April 27, 2001 4:50 PM</FONT> <BR><FONT SIZE=2>To: \
solid-list@solidtech.com</FONT> <BR><FONT SIZE=2>Subject: Re: Questions</FONT>
</P>
<BR>
<P><FONT SIZE=2>Semion,</FONT>
</P>
<P><FONT SIZE=2>On 4/27/2001 10:22:19 AM, "Semion Simkin" \
wrote:</FONT> <BR><FONT SIZE=2>>1) Does anyone know whether I can add a column to \
an</FONT> <BR><FONT SIZE=2>> existing table and make it a \
Foreign Key to another table</FONT> <BR><FONT SIZE=2>> without \
dropping the original table? Is their a way in SOLID</FONT> <BR><FONT \
SIZE=2>> to disable/enable RI constraints?</FONT> <BR><FONT \
SIZE=2>In Solid, keys cannot be altered. Neither can existing keys be dropped \
or</FONT> <BR><FONT SIZE=2>disabled. This applies to both primary and foreign \
keys.</FONT> </P>
<P><FONT SIZE=2>>2) SOLID doesn't recognize SQLERRCODE variable within</FONT>
<BR><FONT SIZE=2>> a stored procedure despite the fact it's \
mentioned in the</FONT> <BR><FONT SIZE=2>> Programmers \
Guide.</FONT> <BR><FONT SIZE=2>> Does anyone know how I can \
check for specific sql error code</FONT> <BR><FONT SIZE=2>> \
within stored procedure?</FONT> <BR><FONT SIZE=2>Our documentation has a bug here. \
The correct variable name is SQLERRNUM.</FONT> </P>
<P><FONT SIZE=2>Regards,</FONT>
</P>
<P><FONT SIZE=2>Timo</FONT>
</P>
<BR>
</BODY>
</HTML>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic