| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
XML Services in Adaptive Server Enterprise |
![[-]](/dwicons/i_colpse.gif)
| Chapter 5 XML Mappings |
Chapter 5
The for xml clause in select statements and the forxmlj function map SQL result sets to SQLX-XML documents, using the SQLX-XML format defined by the ANSI SQLX standard. This chapter describes the SQLX-XML format and the options supported by both the for xml clause and the forxmlj function.
| SQLX options |
| SQLX option definitions |
|
| SQLX data mapping |
| Mapping duplicate column names and unnamed columns |
| Mapping SQL names to XML names |
![[+]](/dwicons/i_expand.gif)
| Mapping SQL values to XML values |
|
| SQLX schema mapping |
| Overview |
| Option: columnstyle=element |
| Option: columnstyle=attribute |
| Option: nullstyle=omit |
| Option: nullstyle=attribute |
|
|