If you plan to take advantage of the ASE select ... for xml feature, then Adaptive Server Enterprise must be properly configured. You can configure Adaptive Server Enterprise manually or with the ASE Features Enabling wizard.
Use the following procedure to manually enable XML.
Establish an isql session to Adaptive Server Enterprise:
isql -Usa -P <password> -S <server>
Invoke the sp_configure stored procedure to enable XML:
sp_configure 'enable xml', 1
Verify if ‘select … for xml’ works by entering ‘select * from sysobjects for xml’
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com