Sybase 12.4.2 manual Viii

Contents
	Handling conversion errors on data import	220
	Tuning bulk loading of data	221
	Improving load performance during database definition	221
	Setting server startup options	222
	Adjusting your environment at load time	222
	Reducing Main IQ Store space use in incremental loads	223
	Changing data using UPDATE	224
	Deleting data	225
	Importing data by replication	226
CHAPTER 6	Using Procedures and Batches	229
	Overview of procedures	229
	Benefits of procedures	230
	Introduction to procedures	230
	Creating procedures	231
	Calling procedures	232
	Dropping procedures	232
	Permissions to execute procedures	233
	Returning procedure results in parameters	233
	Returning procedure results in result sets	234
	Introduction to user-defined functions	235
	Creating user-defined functions	235
	Calling user-defined functions	236
	Dropping user-defined functions	237
	Permissions to execute user-defined functions	237
	Introduction to batches	238
	Control statements	239
	Using compound statements	240
	Declarations in compound statements	241
	Atomic compound statements	242
	The structure of procedures	243
	SQL statements allowed in procedures	243
	Declaring parameters for procedures	244
	Passing parameters to procedures	245
	Passing parameters to functions	245
	Returning results from procedures	246
	Returning a value using the RETURN statement	246
	Returning results as procedure parameters	247
	Returning result sets from procedures	249
	Returning multiple result sets from procedures	250
	Returning variable result sets from procedures	250
	Using cursors in procedures	251
	Cursor management overview	252
	Cursor positioning	252

viii