Re: Best choice for column's data type to represent boolean data

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 b

Re: calling a function over odbc fails

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 recogn

Re: Best choice for column's data type to represent boolean data

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) DERBY-88

RE: Best choice for column's data type to represent boolean data

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 because of a blocking issue

Re: Best choice for column's data type to represent boolean data

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 que

Re: Best choice for column's data type to represent boolean data

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" Sent: Thursday, December 07, 2006 8:07 AM Subject: Re: Best choice for column's

Re: Best choice for column's data type to represent boolean data

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

RE: Best choice for column's data type to represent boolean data

> > 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

Re: java method called from a JSP cannot load ClientDriver

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,

Re: calling a function over odbc fails

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

calling a function over odbc fails

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 "AP