Hello Phil, it should be possible to use VALUE as a column name, you just have to enclose it in double-quotes:
CREATE TABLE FOO(ID VARCHAR(32), "VALUE" TIMESTAMP) should work. In Oracle mode, there is no TIME or DATE type, there is just a TIMESTAMP type, which is named DATE -> use DATE as type for the Oracle mode to represent time stamps. Regards Alexander Schröder SAP DB, SAP Labs Berlin > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, July 18, 2005 2:42 PM > To: [email protected] > Subject: TIMESTAMP datatype in ORACLE mode > > > Hi, > > I have a test script consisting of the following SQL: > > create table Foo ( id varchar(32), value timestamp) > > When I run this from sqlcli in ORACLE mode, I get an error as below: > > [EMAIL PROTECTED] sqlcli -d *** -u ***,*** -S ORACLE -c \; -i test.sql > * -3002: POS(55) Invalid datatype SQLSTATE: 42000 > > Note that the second column name is "value" which is a > reserved word in standard > mode MaxDB, hence the use of ORACLE mode. The script is part > of a much larger > script and changing the name of columns called value is > unfortunately not > an option. > > A useful hack is that this does appear to work when using DB2 > mode so it's > possible that DB2 will save the day overall however, can you > tell me if > this is a bug in MaxDB or is it expected behaviour. If it's > expected behaviour, > is there an equivalent of timestamp for ORACLE mode? > > Thanks, > -phil > > > > > > I'm using Vodafone Mail - to get your free mobile email > account go to http://www.vodafone.ie > Use of Vodafone Mail is subject to Terms and Conditions > http://www.vodafone.ie/terms/website > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
