Chapter 12 Working with Web Services

Generating Web services directly in ASA 9

You can generate Web services directly in ASA 9. To do so, you must connect to a data source in ASA 9 via an ODBC driver.

The following procedure assumes you have at least one Web service defined for ASA 9.

Steps To generate Web services directly in ASA 9:

  1. In the menu bar, select Database→Generate Triggers & Procedures.

    The Triggers and Procedures Generation dialog box appears.
  2. Click the Select a Path button, beside the Directory box, to select a path for the script file.
  3. Type a file name in the File name box.
  4. Select the ODBC generation radio button.
  5. Click the Web services tab.

    The Web services page appears.
  6. Select the generation parameters.
  7. Click the Options tab.

    The Options page appears.
  8. Select script options.
  9. Click the Selection tab.

    The Selection page appears.
  10. Select a model from the Model dropdown listbox.
  11. If you want to generate Web services for tables owned by a particular owner, select an owner from the Owner dropdown listbox. Select <None> for all owners.
  12. Click the Tables tab at the bottom of the page.

    The Tables page appears listing the tables available in the selected model.
  13. Select the tables that need to be generated with the Web services.
  14. Click the Web Services tab at the bottom of the page.

    The Web Services page appears with the list of Web services available in the selected model.
  15. Select the Web services you want to generate in ASA 9.
  16. Click OK.

    The Connect to an ODBC Data Source dialog box appears.
  17. Select the Machine data source radio button, then a data source from the dropdown listbox.

    or

    Select the File data source radio button, then click the Select a File DSN button to browse to the directory containing the .DSN file.
  18. Type your user ID and password.
  19. Click Connect. If prompted by your data source, enter additional connection parameters.

    The Execute SQL Query dialog box displays the Web services script file.
  20. Click Run.

    The SQL statements contained in the script file are executed. (See bottom panel)
  21. Click Close.

The generated Web services appear in ASA 9. (Refresh the Web Services folder if necessary)

 

Copyright (C) 2005. Sybase Inc. All rights reserved.