Re: Create Table Enum keyword

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Be sure to look at what enum() means in MySQL - in this case, it IS a 
set of string literals. But enum means other things, as in C/C++, so I 
always want to be sure.

Regards
Vern

Lim Hock-Chai wrote:
> Thanks Chuck.  I've changed the "status" field to be varchar(25), will
> check into check constraint late.
>
>  
>
> "CRPence" <CRPbottle@xxxxxxxxx> wrote in message
> news:<mailman.12857.1245254319.23468.midrange-l@xxxxxxxxxxxx>...
>   
> >    Replace ENUM [an unsupported data type for the DB2 for i SQL] 
> > with either a CHECK CONSTRAINT listing the values IN(), or a FOREIGN 
> > KEY CONSTRAINT to REFERENCE the table with those values.
> >
> > Regards, Chuck
> >
> > Lim Hock-Chai wrote:
> >     
> > > Below is a create table statement that is generated by mySQL
> > > "show create table" command:
> > >
> > > CREATE TABLE `bad_pages` (
> > >   `pdf_file` varchar(128) NOT NULL default '',
> > >   `bad_pages` text NOT NULL,
> > >   `status` enum('InProgress','Completed','InComplete')
> > >        NOT NULL default 'InProgress',
> > >   `bad_page_count` int(10) NOT NULL default '0',
> > >   `date` date NOT NULL default '0000-00-00',
> > >   PRIMARY KEY  (`pdf_file`)
> > >
> > > When I try to create this same table on iseries, I got the error
> > > on the enum keyword.  Is that means that iseries does not support
> > > the enum keyword?  If so, is there an equivalent for this?
> > >