In Interactive SQL, you can view HTML and XML data from the result set of a query in a separate window.
You must have the privileges necessary to execute your query.
In Interactive SQL, connect to the database.
Execute a query that returns a result set that contains HTML or XML data.
In the results, select a cell that contains HTML or XML content, click ..., and then click View in Window.
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>';
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|