A simple batch consists of a set of SQL statements, separated by semicolons. For example, the following statements form a batch that creates an Eastern Sales department and transfers all sales representatives from Massachusetts (MA) to that department.
See ”Introduction to batches” in SQL Anywhere Server - SQL Usage.
For examples, use the Sybase IQ demo database iqdemo.db.
For installation information, see “The demo database”.
INSERTINTO Departments ( DepartmentID, DepartmentName )VALUES ( 220, 'Eastern Sales' ) ;UPDATE EmployeesSET DepartmentID = 220WHERE DepartmentID = 200AND state = 'GA' ;COMMIT ;
