Hello everyone,
I wrote a function called CHKANI(ani varchar(50)) and it works pretty fine in
ij. Now I try to use it with the DB2 ODBC-Driver and it fails with ... is not
recognized as a function or procedure. The statement looks like this: SELECT
CHKANI('0123456') AS ANI, PHONE from
Marco Schilling [EMAIL PROTECTED] writes:
Hello everyone,
I wrote a function called CHKANI(ani varchar(50)) and it works
pretty fine in ij. Now I try to use it with the DB2 ODBC-Driver and
it fails with ... is not recognized as a function or
procedure. The statement looks like this: SELECT
Thank you, Knut, for your reply and your efforts to help me. It turns out
that the fields I thought contained null values actually contained empty
strings, so the NOT NULL constraints are working fine. ~Sisilla
Knut Anders Hatlen wrote:
Sisilla [EMAIL PROTECTED] writes:
Hello Again,
It
I have a need for columns of boolean data to indicate if items in my
database have (or do not have) certain attributes. These are all truly
yes/no values. For Derby what is the best approach for me to take (I have
next to zero database experience so I am not aware of any best practices)?
Thanks for the advice I was leaning towards the numeric solution but using 'T'
/ 'F' as a visual clue makes a lot of sense. After all until we do have a new
boolean data type that visual clue is all we have. I am already looking
forward to the next version:-)
Ian
- Original Message
Is there reason to think the next version may support Boolean data type?
If so then what about Java Objects?
Bayless
- Original Message -
From: Leslie Software [EMAIL PROTECTED]
To: Derby Discussion derby-user@db.apache.org
Sent: Thursday, December 07, 2006 8:07 AM
Subject: Re: Best
I'm not sure where that came from, however I'm sure its somewhere on the wish
list.
Since the boolean type has been around for a while, and its implemented in
other databases, its not out of the realm of being added.
With respect to java objects, what are they?
Note: that was a rhetorical
Actually I was just opening wishing but I checked the bug database and
found issue 499 https://issues.apache.org/jira/browse/DERBY-499. Looks
like a lot of work was done and it was almost in but had to backed out
http://issues.apache.org/jira/browse/DERBY-1029 because of a blocking
issue
Hi Ian,
Two issues block the introduction of a BOOLEAN datatype:
1) We need DRDA support in order to transport this type across our
network layer. I am cautiously optimistic that we will see this type
appear in the DRDA spec early in 2007. So, soon, this issue will not
block us.
2)
Knut Anders Hatlen [EMAIL PROTECTED] writes:
Marco Schilling [EMAIL PROTECTED] writes:
Hello everyone,
I wrote a function called CHKANI(ani varchar(50)) and it works
pretty fine in ij. Now I try to use it with the DB2 ODBC-Driver and
it fails with ... is not recognized as a
Rick Hillegas wrote:
Hi Ian,
Two issues block the introduction of a BOOLEAN datatype:
1) We need DRDA support in order to transport this type across our
network layer. I am cautiously optimistic that we will see this type
appear in the DRDA spec early in 2007. So, soon, this issue will not
11 matches
Mail list logo