Hello all. I suspect this may be a bug, but how to test!
below is the following command I entered into IJ create table admin.GROSSESSE as select * from S1.GROSSESSE with no data; ERREUR 42X71 : Type de donnÚes 'BOOLEAN' non valide pour la colonne 'ECHO'. Just to demonstrate that the table S1.Grossesse exists I ran a describe... here is the result ij> describe S1.Grossesse; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& ------------------------------------------------------------------------------ QGROSSESSE |INTEGER |0 |10 |10 |NULL |NULL |NO OBS |VARCHAR |NULL|NULL|9 |NULL |18 |NO DDR |TIMESTAMP|9 |10 |29 |NULL |NULL |YES TERME |TIMESTAMP|9 |10 |29 |NULL |NULL |YES FECNORM |INTEGER |0 |10 |10 |NULL |NULL |YES FECINVIVO |INTEGER |0 |10 |10 |NULL |NULL |YES QANOMALIE |INTEGER |0 |10 |10 |NULL |NULL |YES DEXAM |TIMESTAMP|9 |10 |29 |NULL |NULL |YES ECHO |BOOLEAN |NULL|NULL|1 |NULL |NULL |YES AMNIO |BOOLEAN |NULL|NULL|1 |NULL |NULL |YES AFP |BOOLEAN |NULL|NULL|1 |NULL |NULL |YES AUTRE |BOOLEAN |NULL|NULL|1 |NULL |NULL |YES EXINFO |VARCHAR |NULL|NULL|255 |NULL |510 |YES NPREVAB |INTEGER |0 |10 |10 |NULL |NULL |YES MED |VARCHAR |NULL|NULL|255 |NULL |510 |YES SORTIE |INTEGER |0 |10 |10 |NULL |NULL |YES FACEVO |INTEGER |0 |10 |10 |NULL |NULL |YES FACDETAIL |LONG VAR&|NULL|NULL|32700 |NULL |NULL |YES GNOM |VARCHAR |NULL|NULL|100 |NULL |200 |YES GPNOM |VARCHAR |NULL|NULL|100 |NULL |200 |YES GADDR |VARCHAR |NULL|NULL|100 |NULL |200 |YES GTYPE |VARCHAR |NULL|NULL|50 |NULL |100 |YES GTEL |VARCHAR |NULL|NULL|14 |NULL |28 |YES GFAX |VARCHAR |NULL|NULL|14 |NULL |28 |YES And to confirm that the schema 'admin' really exists... ij> show tables in admin; TABLE_SCHEM |TABLE_NAME |REMARKS ------------------------------------------------------------------------ ADMIN |CAPSULE | ADMIN |CL_AINT | ADMIN |CL_ALD | ADMIN |CL_AP | ADMIN |CL_AUM | ADMIN |CL_BOOLYN | ADMIN |CL_CMAGE | ADMIN |CL_CMLOC | ADMIN |CL_CMTYP | ADMIN |CL_DSI | ADMIN |CL_HBIBE | ADMIN |CL_HBIDA | ADMIN |CL_HBIMA | ADMIN |CL_LONG | ADMIN |CL_MOTIF | ADMIN |CL_Q1A6 | ADMIN |CL_SEX | ADMIN |CL_STOMIE | ADMIN |CL_USER_TYPE | ADMIN |CM | ADMIN |DM | ADMIN |DVD | ADMIN |EQUIPE_INFO | ADMIN |EX | So the schema exists: So I did a quick test, creating a new table 'boolTest' create table app.boolTest (boolTest Boolean); 0 lignes insÚrÚes/mises Ó jour/supprimÚes describe app.boolTest; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& ------------------------------------------------------------------------------ BOOLTEST |BOOLEAN |NULL|NULL|1 |NULL |NULL |YES So the 'boolean' word definately works, just not in the instance of a create table as statement. Anyone got any ideas? David What else can I now do?
