Express (Distributed operating systems), v8.0 > Reference > Command-line utilities > EJB deployment tool > Reference > The ejbdeploy command
SQL reserved keywords
If an abstract field or bean name for a container managed persistence (CMP) entity beans uses a SQL reserved keyword, the top-down mapping adds a numeric suffix to the column name when generating the data definition language file (Table.ddl). This is to avoid SQL command conflicts when SQL reserved words are used as the column name. The numeric suffix is added when you run ejbdeploy command to generate deployment code for container managed persistence (CMP) entity beans.Each of the database back end supported by the ejbdeploy command have their own list of SQL reserved keywords. Select one of the following links to see the set of SQL reserved keywords for a particular database back-end vendor:
- DB2 V8.1 for Linux, UNIX and Windows
- DB2 V8.2 for Linux, UNIX and Windows
- DB2 V9.1 for Linux, UNIX and Windows
- DB2 V9.5 for Linux, UNIX and Windows
- DB2 V9.7 for Linux, UNIX and Windows
- DB2 V9.8 for Linux, UNIX and Windows
- DB2 V8 for z/OS
- New functions of DB2 V8 for z/OS
- DB2 V9 for z/OS
- DB2 V10 for z/OS
- DB2 V5R3 for iSeries
- DB2 V5R4 for iSeries
- DB2 V6R1 for iSeries
- DB2 V7R1 for iSeries
- Apache Derby V10
- Apache Derby V10.1
- Apache Derby V10.5
- Oracle, V10g
- Oracle, V11g
- Informix Dynamic Server, V10.0
- Informix Dynamic Server, V11.0
- Informix Dynamic Server, V11.5
- Informix Dynamic Server, V11.7
- Sybase Adaptive Server Enterprise, V12.5
- Sybase Adaptive Server Enterprise, V15.0
- Sybase Adaptive Server Enterprise, V15.5
- Microsoft SQL Server 2005
- Microsoft SQL Server 2008
Related
The ejbdeploy command
Feedback