Re: Variable Concatenation in SPL??
Hi !
> DEFINE s_descr CHAR(255);
> DEFINE s_value CHAR(30);
>
> FOREACH
> select value
> INTO s_value
> from table>
> LET s_descr = s_descr || s_value; --does not work
> LET s_descr = s_descr || 'Howdy';
I have not tested but in my opinion, no one of these statements could work : you
are trying to concatenate CHAR strings : the result of the concatenation can't
be stored in s_descr varaible (you are putting 255 + 30 characters in 255
characters ! ). This kind of statement could only work with VARCHAR
strings...assuming that you are not going over the string length.
--
- -------------------------------------------------------------- -
- Arnaud ANDRIEUX arnaud.andrieux@aql.fr -
- Ingenieur en developpement -
- Direction Metier Industrie -
- -------------------------------------------------------------- -
- ALLIANCE QUALITE LOGICIEL http://www.aql.fr -
- Rue de la Chataigneraie -
- B.P. 127 -
- 35513 CESSON SEVIGNE -
- tel : (33) (0)2.99.12.50.00 -
- fax : (33) (0)2.99.63.70.40 -
- -------------------------------------------------------------- -