Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SPL Statements > DEFINE >

BYTE and TEXT

The only default value valid for a BYTE or TEXT variable is NULL. The following example defines a TEXT global variable that is called l_blob:

CREATE PROCEDURE use_text()
   DEFINE i INT;
   DEFINE GLOBAL l_blob REFERENCES TEXT DEFAULT NULL;
   ...
END PROCEDURE 

Here the REFERENCES keyword is required, because the DEFINE statement cannot declare a BYTE or TEXT data type directly; the l_blob variable is a pointer to a TEXT value that is stored in the global environment.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]