db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Rayl <er...@bellsouth.net>
Subject Re: Migrating, not an too SQL knowledgeable...
Date Wed, 29 Sep 2004 22:28:56 GMT
Joachim,

>
>I have found that an undeclared VARCHAR is not accepted, so I will
>replace those with VARCHAR(50), but there are other stuff, which I
>don't even know what they are doing in HSQLDB, like this column phrase
>for example: "BATCHTRADEVOLUMEBUY VARCHAR(255),AK_INTERNALBATCHID
>INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL
>PRIMARY KEY)"
>  
>

AK_INTERNALBATCHID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)

would become:

AK_INTERNALBATCHID INTEGER GENERATED ALWAYS AS IDENTITY(START WITH 0)



Ed



Mime
View raw message