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]
