The Generate XML Schema Definition File option generates an XML schema definition (XSD) file based on the selected SQL statement, stores the file in your Eclipse workspace, and opens it in the XSD Editor. You select individual SQL statements from the SQL file and invoke the Generate XML Schema Definition File command.
To generate the XSD, the command calls the SYSXML GEN_QUERY_CANONICAL_SCHEMA_U stored procedure. To access the command in the SQL Editor menu, you must have the SYSXML database installed. Also, you must have permission to execute the SYSXML stored procedure. If the command is successful, you then enter the location and name of the XSD file. After the XSD file is created, it opens in the XSD Editor.
This command option allows a single SQL statement. If multiple SQL statements are passed to the command option, you are asked if you want to continue, and only the first SQL statement is chosen. The command does not support statements that use parameter substitution.