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 one or more SQL files to the current project, or save a SQL file 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 routine procedural object.
Related reference
SQL Editor Preferences
Bookmarks view
Code Assist Preferences
SQL Files/Scrapbooks Preferences
Templates Preferences

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