SQL files provide a capability similar to stored procedures: they group SQL statements for execution. Unlike stored procedures, SQL files have the following characteristics:
SQL Files do not have a parameter passing mechanism.
SQL Files can contain a much larger subset of SQL statements or commands.
Stored procedures reside on the database servers, whereas SQL files reside in the file system or in Sybase WorkSpace where they are grouped under projects.
A stored procedure must contain valid SQL syntax and conform to miscellaneous database rules, whereas a SQL file is not subject to those constraints until execution time.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com