Developing a SQL File

Use Database Development tools to create and update SQL files.

Like a stored procedure, a SQL file groups SQL statements together for execution. Unlike a stored procedure, a SQL file does not pass parameters and does not reside on a database server. Also, while a stored procedure is subject to syntax and database rules, a SQL file is free to contain a more broad selection of SQL commands.

  1. Changing Content Assist Key Preferences
    Specify the Content Assist key preferences.
  2. Creating a SQL File
    Use Database Development tools to create SQL files.
  3. Saving a SQL File
    Save a newly created or edited SQL file to the current project, to a different project, or to a different file name.
  4. Executing a SQL File
    You can execute a SQL file from the SQL File Editor or from WorkSpace Navigator.
  5. Viewing SQL Results
    Use the SQL Results view to see the results of an executed SQL query or procedural object.
Related reference
SQL Editor Preferences
Code Assist Preferences
SQL Files/Scrapbooks
Templates Preferences

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com