Enabling the ASE for XML Feature

To use the ASE for XML feature, install it and properly configure ASE.

You can configure Adaptive Server Enterprise manually or with the ASE Features Enabling wizard.

To manually enable XML:

  1. Establish an isql session to Adaptive Server Enterprise:

    isql -Usa -P<password> -S<server>

  2. Enable XML:

    sp_configure "enable xml", 1

  3. Verify that 'select … for xml' returns results:

    select * from sysobjects for xml

Parent topic: Adaptive Server Enterprise Configuration
Related tasks
Enabling Adaptive Server Enterprise Features
Enabling ASE Real-Time Messaging Services
Enabling the ASE Web Service Consumer
Creating an ASE Connection Profile

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com