| <?xml version="1.0" encoding="ASCII"?> |
| |
| <!--/*******************************************************************************--> |
| <!-- * Copyright (c) 2008 SAP AG--> |
| <!-- * All rights reserved. This program and the accompanying materials--> |
| <!-- * are made available under the terms of the Eclipse Public License v1.0--> |
| <!-- * which accompanies this distribution, and is available at--> |
| <!-- * http://www.eclipse.org/legal/epl-v10.html--> |
| <!-- *--> |
| <!-- * Contributors:--> |
| <!-- * Dimiter Dimitrov; Wolfgang Auer - initial API and implementation--> |
| <!-- *******************************************************************************--> |
| |
| <DBDefinition:DatabaseVendorDefinition xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:DBDefinition="http:///org/eclipse/datatools/modelbase/dbdefinition/dbdefinition.ecore" vendor="MaxDB" version="7.6" maximumIdentifierLength="32" joinSupported="true" tablespacesSupported="false" maximumCommentLength="2147475647" sequenceSupported="true" aliasSupported="true" synonymSupported="true" domainSupported="true" SQLStatementSupported="true" sqlUDFSupported="true"> |
| <predefinedDataTypeDefinitions xmi:id="CHARACTER_1" lengthSupported="true" keyConstraintSupported="true" multipleColumnsSupported="true" maximumLength="4000" jdbcEnumType="1" javaClassName="java.lang.String" defaultLength="1" displayName="CHAR({0}) UNICODE" displayNameSupported="true"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>CHAR() UNICODE</name> |
| <name>CHAR</name> |
| <name>CHARACTER</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="CHARACTER_2" lengthSupported="true" keyConstraintSupported="true" multipleColumnsSupported="true" maximumLength="8000" jdbcEnumType="1" javaClassName="java.lang.String" defaultLength="1" displayName="CHAR({0}) ASCII" displayNameSupported="true"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>CHAR() ASCII</name> |
| <name>CHAR</name> |
| <name>CHARACTER</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="CHARACTER_VARYING_1" lengthSupported="true" keyConstraintSupported="true" multipleColumnsSupported="true" maximumLength="4000" primitiveType="CHARACTER_VARYING" jdbcEnumType="12" javaClassName="java.lang.String" defaultLength="1" displayName="VARCHAR({0}) UNICODE" displayNameSupported="true"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>VARCHAR() UNICODE</name> |
| <name>VARCHAR</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="CHARACTER_VARYING_2" lengthSupported="true" keyConstraintSupported="true" multipleColumnsSupported="true" maximumLength="8000" primitiveType="CHARACTER_VARYING" jdbcEnumType="12" javaClassName="java.lang.String" defaultLength="1" displayName="VARCHAR({0}) ASCII" displayNameSupported="true"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>VARCHAR() ASCII</name> |
| <name>VARCHAR</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="CHARACTER_LARGE_OBJECT_3" multipleColumnsSupported="true" primitiveType="CHARACTER_LARGE_OBJECT" jdbcEnumType="2005" javaClassName="java.lang.String" orderingSupported="false" groupingSupported="false"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <name>LONG UNICODE</name> |
| <name>CLOB UNICODE</name> |
| <name>CLOB</name> |
| <name>LONG</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="CHARACTER_LARGE_OBJECT_2" multipleColumnsSupported="true" primitiveType="CHARACTER_LARGE_OBJECT" jdbcEnumType="-1" javaClassName="java.lang.String" orderingSupported="false" groupingSupported="false"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <name>LONG UNICODE</name> |
| <name>CLOB UNICODE</name> |
| <name>CLOB</name> |
| <name>LONG</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="BINARY_VARYING_2" multipleColumnsSupported="true" primitiveType="BINARY_VARYING" jdbcEnumType="-4" javaClassName="byte[]" orderingSupported="false" groupingSupported="false"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <name>LONG BYTE</name> |
| <name>BLOB</name> |
| <name>LONG RAW</name> |
| <name>LONGFILE</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="BINARY_LARGE_OBJECT_1" multipleColumnsSupported="true" primitiveType="BINARY_LARGE_OBJECT" jdbcEnumType="2004" javaClassName="byte[]" orderingSupported="false" groupingSupported="false"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <name>LONG BYTE</name> |
| <name>BLOB</name> |
| <name>LONG RAW</name> |
| <name>LONGFILE</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="BOOLEAN_1" keyConstraintSupported="true" multipleColumnsSupported="true" primitiveType="BOOLEAN" jdbcEnumType="16" javaClassName="boolean"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>BOOLEAN</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="BIT" keyConstraintSupported="true" identitySupported="true" primitiveType="BOOLEAN" jdbcEnumType="-7" javaClassName="boolean"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <name>BOOLEAN</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="DECIMAL_1" scaleSupported="true" precisionSupported="true" keyConstraintSupported="true" multipleColumnsSupported="true" maximumPrecision="38" maximumScale="38" primitiveType="DECIMAL" jdbcEnumType="3" javaClassName="java.math.BigDecimal"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>DECIMAL</name> |
| <name>FIXED</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="FLOAT_1" precisionSupported="true" keyConstraintSupported="true" multipleColumnsSupported="true" maximumPrecision="38" primitiveType="FLOAT" jdbcEnumType="6" javaClassName="double" defaultPrecision="16"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>FLOAT</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="DOUBLE_PRECISION_1" keyConstraintSupported="true" identitySupported="true" multipleColumnsSupported="true" primitiveType="DOUBLE_PRECISION" jdbcEnumType="8" javaClassName="double"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>DOUBLE PRECISION</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="INTEGER_1" keyConstraintSupported="true" identitySupported="true" multipleColumnsSupported="true" maximumValue="2147483647" minimumValue="-2147483648" primitiveType="INTEGER" jdbcEnumType="4" javaClassName="int"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>INTEGER</name> |
| <name>INT</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="SMALLINT_1" keyConstraintSupported="true" multipleColumnsSupported="true" maximumValue="32767" minimumValue="-32768" primitiveType="SMALLINT" jdbcEnumType="5" javaClassName="short"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>SMALLINT</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="DATE_1" keyConstraintSupported="true" primitiveType="DATE" jdbcEnumType="91" javaClassName="java.sql.Date"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>DATE</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="TIME_1" keyConstraintSupported="true" primitiveType="TIME" jdbcEnumType="92" javaClassName="java.sql.Time"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>TIME</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="TIMESTAMP_1" keyConstraintSupported="true" primitiveType="TIMESTAMP" jdbcEnumType="93" javaClassName="java.sql.Timestamp"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>TIMESTAMP</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="BINARY_VARYING_1" lengthSupported="true" keyConstraintSupported="true" multipleColumnsSupported="true" maximumLength="8000" primitiveType="BINARY_VARYING" jdbcEnumType="-3" javaClassName="byte[]" defaultLength="1" displayName="VARCHAR({0}) BYTE" displayNameSupported="true"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>VARCHAR() BYTE</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions xmi:id="BINARY_1" lengthSupported="true" keyConstraintSupported="true" multipleColumnsSupported="true" maximumLength="8000" primitiveType="BINARY" jdbcEnumType="-2" javaClassName="byte[]" defaultLength="1" displayName="CHAR({0}) BYTE" displayNameSupported="true"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <defaultValueTypes>LITERAL</defaultValueTypes> |
| <name>CHAR() BYTE</name> |
| </predefinedDataTypeDefinitions> |
| <predefinedDataTypeDefinitions multipleColumnsSupported="true" primitiveType="CHARACTER_LARGE_OBJECT" jdbcEnumType="-1" javaClassName="java.lang.String" orderingSupported="false" groupingSupported="false"> |
| <defaultValueTypes>NULL</defaultValueTypes> |
| <name>LONG ASCII</name> |
| <name>CLOB ASCII</name> |
| <name>CLOB</name> |
| <name>LONG</name> |
| </predefinedDataTypeDefinitions> |
| <storedProcedureDefinition returnTypeSupported="true" maximumActionBodyLength="131072" maximumIdentifierLength="32"/> |
| <triggerDefinition maximumActionBodyLength="131072" perColumnUpdateTriggerSupported="true" maximumIdentifierLength="32"/> |
| <columnDefinition computedSupported="false" maximumIdentifierLength="32"/> |
| <constraintDefinition maximumPrimaryKeyIdentifierLength="32" maximumForeignKeyIdentifierLength="32" maximumCheckConstraintIdentifierLength="32"> |
| <parentDeleteDRIRuleType>RESTRICT</parentDeleteDRIRuleType> |
| <parentDeleteDRIRuleType>CASCADE</parentDeleteDRIRuleType> |
| <parentDeleteDRIRuleType>SET_NULL</parentDeleteDRIRuleType> |
| <parentDeleteDRIRuleType>SET_DEFAULT</parentDeleteDRIRuleType> |
| </constraintDefinition> |
| <indexDefinition includedColumnsSupported="true" maximumIdentifierLength="32"/> |
| <tableDefinition maximumIdentifierLength="32"/> |
| <sequenceDefinition cacheSupported="true" orderSupported="true" noMaximumValueString="NOMAXVALUE" noMinimumValueString="NOMINVALUE" noCacheString="NOCACHE" cacheDefaultValue="20"/> |
| <queryDefinition identifierQuoteString=""" hostVariableMarkerSupported="true" defaultKeywordForInsertValueSupported="true"/> |
| <SQLSyntaxDefinition> |
| <keywords>ABS</keywords> |
| <keywords>ABSOLUTE</keywords> |
| <keywords>ACOS</keywords> |
| <keywords>ADDDATE</keywords> |
| <keywords>ADDTIME</keywords> |
| <keywords>ALL</keywords> |
| <keywords>ALPHA</keywords> |
| <keywords>ALTER</keywords> |
| <keywords>ANY</keywords> |
| <keywords>ASCII</keywords> |
| <keywords>ASIN</keywords> |
| <keywords>ATAN</keywords> |
| <keywords>ATAN2</keywords> |
| <keywords>AVG</keywords> |
| <keywords>BINARY</keywords> |
| <keywords>BIT</keywords> |
| <keywords>BOOLEAN</keywords> |
| <keywords>BYTE</keywords> |
| <keywords>CASE</keywords> |
| <keywords>CEIL</keywords> |
| <keywords>CEILING</keywords> |
| <keywords>CHAR</keywords> |
| <keywords>CHARACTER</keywords> |
| <keywords>CHECK</keywords> |
| <keywords>CHR</keywords> |
| <keywords>COLUMN</keywords> |
| <keywords>CONCAT</keywords> |
| <keywords>CONSTRAINT</keywords> |
| <keywords>COS</keywords> |
| <keywords>COSH</keywords> |
| <keywords>COT</keywords> |
| <keywords>COUNT</keywords> |
| <keywords>CROSS</keywords> |
| <keywords>CURDATE</keywords> |
| <keywords>CURRENT</keywords> |
| <keywords>CURTIME</keywords> |
| <keywords>DATABASE</keywords> |
| <keywords>DATE</keywords> |
| <keywords>DATEDIFF</keywords> |
| <keywords>DAY</keywords> |
| <keywords>DAYNAME</keywords> |
| <keywords>DAYOFMONTH</keywords> |
| <keywords>DAYOFWEEK</keywords> |
| <keywords>DAYOFYEAR</keywords> |
| <keywords>DEC</keywords> |
| <keywords>DECIMAL</keywords> |
| <keywords>DECODE</keywords> |
| <keywords>DEFAULT</keywords> |
| <keywords>DEGREES</keywords> |
| <keywords>DELETE</keywords> |
| <keywords>DIGITS</keywords> |
| <keywords>DISTINCT</keywords> |
| <keywords>DOUBLE</keywords> |
| <keywords>EXCEPT</keywords> |
| <keywords>EXISTS</keywords> |
| <keywords>EXP</keywords> |
| <keywords>EXPAND</keywords> |
| <keywords>FIRST</keywords> |
| <keywords>FIXED</keywords> |
| <keywords>FLOAT</keywords> |
| <keywords>FLOOR</keywords> |
| <keywords>FOR</keywords> |
| <keywords>FROM</keywords> |
| <keywords>FULL</keywords> |
| <keywords>GET_OBJECTNAME</keywords> |
| <keywords>GET_SCHEMA</keywords> |
| <keywords>GRAPHIC</keywords> |
| <keywords>GREATEST</keywords> |
| <keywords>GROUP</keywords> |
| <keywords>HAVING</keywords> |
| <keywords>HEX</keywords> |
| <keywords>HEXTORAW</keywords> |
| <keywords>HOUR</keywords> |
| <keywords>IFNULL</keywords> |
| <keywords>IGNORE</keywords> |
| <keywords>INDEX</keywords> |
| <keywords>INITCAP</keywords> |
| <keywords>INNER</keywords> |
| <keywords>INSERT</keywords> |
| <keywords>INT</keywords> |
| <keywords>INTEGER</keywords> |
| <keywords>INTERNAL</keywords> |
| <keywords>INTERSECT</keywords> |
| <keywords>INTO</keywords> |
| <keywords>JOIN</keywords> |
| <keywords>KEY</keywords> |
| <keywords>LAST</keywords> |
| <keywords>LCASE</keywords> |
| <keywords>LEAST</keywords> |
| <keywords>LEFT</keywords> |
| <keywords>LENGTH</keywords> |
| <keywords>LFILL</keywords> |
| <keywords>LIST</keywords> |
| <keywords>LN</keywords> |
| <keywords>LOCATE</keywords> |
| <keywords>LOG</keywords> |
| <keywords>LOG10</keywords> |
| <keywords>LONG</keywords> |
| <keywords>LONGFILE</keywords> |
| <keywords>LOWER</keywords> |
| <keywords>LPAD</keywords> |
| <keywords>LTRIM</keywords> |
| <keywords>MAKEDATE</keywords> |
| <keywords>MAKETIME</keywords> |
| <keywords>MAPCHAR</keywords> |
| <keywords>MAX</keywords> |
| <keywords>MBCS</keywords> |
| <keywords>MICROSECOND</keywords> |
| <keywords>MIN</keywords> |
| <keywords>MINUTE</keywords> |
| <keywords>MOD</keywords> |
| <keywords>MONTH</keywords> |
| <keywords>MONTHNAME</keywords> |
| <keywords>NATURAL</keywords> |
| <keywords>NCHAR</keywords> |
| <keywords>NEXT</keywords> |
| <keywords>NO</keywords> |
| <keywords>NOROUND</keywords> |
| <keywords>NOT</keywords> |
| <keywords>NOW</keywords> |
| <keywords>NULL</keywords> |
| <keywords>NUM</keywords> |
| <keywords>NUMERIC</keywords> |
| <keywords>OBJECT</keywords> |
| <keywords>OF</keywords> |
| <keywords>ON</keywords> |
| <keywords>ORDER</keywords> |
| <keywords>PACKED</keywords> |
| <keywords>PI</keywords> |
| <keywords>POWER</keywords> |
| <keywords>PREV</keywords> |
| <keywords>PRIMARY</keywords> |
| <keywords>RADIANS</keywords> |
| <keywords>REAL</keywords> |
| <keywords>REJECT</keywords> |
| <keywords>RELATIVE</keywords> |
| <keywords>REPLACE</keywords> |
| <keywords>RFILL</keywords> |
| <keywords>RIGHT</keywords> |
| <keywords>ROUND</keywords> |
| <keywords>ROWID</keywords> |
| <keywords>ROWNO</keywords> |
| <keywords>RPAD</keywords> |
| <keywords>RTRIM</keywords> |
| <keywords>SECOND</keywords> |
| <keywords>SELECT</keywords> |
| <keywords>SELUPD</keywords> |
| <keywords>SERIAL</keywords> |
| <keywords>SET</keywords> |
| <keywords>SHOW</keywords> |
| <keywords>SIGN</keywords> |
| <keywords>SIN</keywords> |
| <keywords>SINH</keywords> |
| <keywords>SMALLINT</keywords> |
| <keywords>SOME</keywords> |
| <keywords>SOUNDEX</keywords> |
| <keywords>SPACE</keywords> |
| <keywords>SQRT</keywords> |
| <keywords>STAMP</keywords> |
| <keywords>STATISTICS</keywords> |
| <keywords>STDDEV</keywords> |
| <keywords>SUBDATE</keywords> |
| <keywords>SUBSTRING</keywords> |
| <keywords>SUBTIME</keywords> |
| <keywords>SUM</keywords> |
| <keywords>SYSDBA</keywords> |
| <keywords>TABLE</keywords> |
| <keywords>TAN</keywords> |
| <keywords>TANH</keywords> |
| <keywords>TIME</keywords> |
| <keywords>TIMEDIFF</keywords> |
| <keywords>TIMESTAMP</keywords> |
| <keywords>TIMEZONE</keywords> |
| <keywords>TO</keywords> |
| <keywords>TOIDENTIFIER</keywords> |
| <keywords>TRANSACTION</keywords> |
| <keywords>TRANSLATE</keywords> |
| <keywords>TRIM</keywords> |
| <keywords>TRUNC</keywords> |
| <keywords>TRUNCATE</keywords> |
| <keywords>UCASE</keywords> |
| <keywords>UID</keywords> |
| <keywords>UNICODE</keywords> |
| <keywords>UNION</keywords> |
| <keywords>UPDATE</keywords> |
| <keywords>UPPER</keywords> |
| <keywords>USER</keywords> |
| <keywords>USERGROUP</keywords> |
| <keywords>USING</keywords> |
| <keywords>UTCDATE</keywords> |
| <keywords>UTCDIFF</keywords> |
| <keywords>VALUE</keywords> |
| <keywords>VALUES</keywords> |
| <keywords>VARCHAR</keywords> |
| <keywords>VARGRAPHIC</keywords> |
| <keywords>VARIANCE</keywords> |
| <keywords>WEEK</keywords> |
| <keywords>WEEKOFYEAR</keywords> |
| <keywords>WHEN</keywords> |
| <keywords>WHERE</keywords> |
| <keywords>WITH</keywords> |
| <keywords>YEAR</keywords> |
| <keywords>ZONED</keywords> |
| <operators>|</operators> |
| <operators>+</operators> |
| <operators>-</operators> |
| <operators>*</operators> |
| <operators>/</operators> |
| <operators>DIV</operators> |
| <operators>MOD</operators> |
| <operators>AND</operators> |
| <operators>NOT</operators> |
| <operators>OR</operators> |
| </SQLSyntaxDefinition> |
| <schemaDefinition maximumIdentifierLength="32"/> |
| <viewDefinition maximumIdentifierLength="32"/> |
| </DBDefinition:DatabaseVendorDefinition> |