Re: Arrays of Characters in SPL

KONE wrote: > I hope I'm just doing something stupid, but I cannot seem to > define an array of character variables in SPL. [...] > What am I missing? > > create procedure updannpcalcs ( p_cusip char(8) ) > define p_yrqtr array [20] of char(6);> # ^ > # 201: A syntax error has occurred. > # > define p_pda_yr array [20] of smallint; > define p_pda_yr array [20] of smallfloat; > define p_pda_yr array [20] of smallfloat; > define i smallint; > You're only missing the section of the manual which doesn't say that you can declare arrays in stored procedures, because you cannot do so. I'm afraid you'll have to think again. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>