Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL

 

Viewing HTML and XML data in Interactive SQL

In Interactive SQL, you can view HTML and XML data from the result set of a query in a separate window.

Prérequis

You must have the privileges necessary to execute your query.

 Task
  1. In Interactive SQL, connect to the database.

  2. Execute a query that returns a result set that contains HTML or XML data.

  3. In the results, select a cell that contains HTML or XML content, click ..., and then click View in Window.

Résultat

The Value of Column column-name window appears.

Suivant

Click OK to close the window.

Exemple

To view a sample result set that contains HTML, run the following query:



SELECT '<html>
 <head>
  <meta http-equiv=Content-Type content="text/html; charset=windows-1252">
   <title>Tee Shirt</title>
 </head>
 <body lang=EN-US>
  <p>
   <span  style=font-size:10.0pt;font-family:Arial>
   We have improved the design of this perennial favorite. 
   A sleek and technical shirt built for the trail, track, or 
   sidewalk. UPF rating of 50+.
   </span>
  </p>
 </body>
</html>';

To view a sample result set that contains a well-formed XML document, run the following query:

SELECT '<?xml version="1.0" encoding="UTF-8"?>
<parent>
    <children>
        <child name="Tim" />
        <child name="Katie" />
    </children>
</parent>';