Sybase 12.4.2 Manuale Utente

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

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