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, from WorkSpace Navigator, and from the Database Development perspective.
  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

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.