Generating XML Schema for Real-Time Messaging Services

Generate an XML schema with SQL File Editor, XML Editor, or Visual SQL.

For the appropriate ASE connection profile and database, select the appropriate procedural object.

Object	How to select
Stored procedure	Expand the Stored Procedures folder, right-click the stored procedure, and select Edit.
Trigger	Expand the Tables folder, expand the table, and then expand the Triggers folder. Right-click the trigger and select Edit.

In the Source page, place the cursor in the desired location within the SQL code, right-click and select Sybase_ASE_15.x > SQL/XML Wizard.
You can also open the SQL/XML wizard from the ASE XML Services icon on the toolbar.
Select SQL to XML Mapping Functions.

Modify the following input fields.

Field	Example
Variable or Query	Select Variable or Query. Variable – enter a variable or choose an existing variable. Variable names begin with "@". Query – construct a SQL query in one of two ways: Enter a SQL query. Click SQL to construct a query using Visual SQL.
Output	Select one of the following output types: Schema DTD Result Set All – output for schema, DTD, and result set

Field

Example

Variable or Query

Select Variable or Query.

Variable – enter a variable or choose an existing variable. Variable names begin with "@".

Query – construct a SQL query in one of two ways:

Output

Select one of the following output types:

Click Next.
If you selected All as an output type, provide input variables to store mapping results for result set, schema, and DTD output types, and click Next.
Specify the listed options for the output types you selected and click Finish.