If you edit the schema of a stream created using Sybase CEP Engine version 5.4 or older, and the schema is defined in a .ccs file, you can choose a different schema file or create a new file.
To choose a different schema file:
- Click the name of the stream in the Explorer view.
- Click the Open an existing schema file button in the Stream Schema Editor or click CCS File Editor on the Tools menu.
- Navigate to the file you want to use and then click Open. The Stream Schema Editor now shows the contents of the file you opened.
Note that, if you edit a schema definition file that is used by more than one stream, the schema changes for all of the associated streams.
To create a new schema file:
- Click the name of the stream in the Explorer view.
- Click the Create a new schema button in the in the Stream Schema Editor.
- Navigate to the directory where you want to create the new schema file and then enter a name for the file into the Filename box.
- Click Save. The Stream Schema Editor now shows a blank schema.
- Use the Insert row button to add a column to the schema, and then enter the name and type of a column.
- Define additional columns as needed. Use the Insert row button to add a column, the Delete row button to delete a column, and the Move row up and Move row down buttons to move column definitions up and down in the editor.