A string with defined length is returned.
make_string returns a new string of length count, filled with binary zeros.
If count is zero, an empty string '' is returned.
Make a string and fill it with character sequence containing the alphabet upper case characters from A to Z.
SQL> create procedure
alphabet_string ()
{
declare _inx integer;
declare _str varchar;
_str := make_string (26);
while (_inx < 26)
{
aset (_str, _inx, _inx + 65);
_inx := _inx + 1;
}
return (_str);
}
;
Done. -- 6 msec.
SQL> select alphabet_string ();
callret
VARCHAR NOT NULL
_______________________________________________________________________________
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1 Rows. -- 4 msec.