You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Jeremy Boynes <jb...@apache.org> on 2005/03/03 22:16:58 UTC

Re: DB2 mode vs. Cloudscape mode - where?

Bernt M. Johnsen wrote:
> Hi all!
> 
> In the Derby source, I find several comments referring to "DB2 mode"
> and "Cloudscape mode". 

Are there any other examples that you have found?
--
Jeremy

Re: DB2 mode vs. Cloudscape mode - where?

Posted by "Bernt M. Johnsen" <be...@sun.com>.
>>>>>>>>>>>> Jeremy Boynes wrote (2005-03-03 13:16:58):
> Bernt M. Johnsen wrote:
> >Hi all!
> >
> >In the Derby source, I find several comments referring to "DB2 mode"
> >and "Cloudscape mode". 
> 
> Are there any other examples that you have found?

A quick count gives:

./java/tools/org/apache/derby/impl/tools/dblook/DB_StoredProcedure.java:54:             // have to do this cast because DB2 mode doesn't allow equality
./java/engine/org/apache/derby/impl/sql/compile/InsertNode.java:329:             * RESOLVE: Enforce the limit only in DB2 mode for now. Too many tests need to be
./java/engine/org/apache/derby/impl/sql/compile/InsertNode.java:330:             * migrated to DB2 mode first.  Only now we would have expanded STAR (*) to all columns.
./java/engine/org/apache/derby/impl/sql/compile/TableElementList.java:290:                              but only in Cloudscape mode. SQL and DB2 require explict NOT NULL.
./java/engine/org/apache/derby/impl/sql/compile/TableElementList.java:305:              /* Can have only one autoincrement column in DB2 mode */
./java/engine/org/apache/derby/impl/sql/compile/TableElementList.java:898:       * table statement to NOT NULL in Cloudscape mode and raises an error in DB2 mode.
./java/engine/org/apache/derby/impl/sql/compile/TableElementList.java:930:       * a create table statement to NOT NULL (but only in Cloudscape mode).
./java/engine/org/apache/derby/iapi/types/SQLChar.java:1874:             * limits in both modes. We could do these checks in DB2 mode only, if needed, so
./java/engine/org/apache/derby/iapi/types/SQLBinary.java:894:            * limits in both modes. We could do these checks in DB2 mode only, if needed, so
./java/engine/org/apache/derby/iapi/types/DataTypeDescriptor.java:434:                  //Need normalize to be called on long varchar for bug 5592 where we need to enforce a lenght limit in db2 mode

> --
> Jeremy

-- 
Bernt Marius Johnsen, HA Data Management, Sun Microsystems, Norway
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTICE: This signature is neither personal, religious, literary,
ethnic, racial, offensive nor humorous.