Hi Alexander, Florian, Thanks for your (very prompt) suggestions, I've quoted the column name and it works fine.
Regards, -phil >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: maxdb@lists.mysql.com >> 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] >> 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]
