Re: insert and concatenation
On Thu, Jul 29, 1999 at 06:13:12PM +0200, Christiane Schuchard wrote:
> While trying to create a trigger via sql which contains the following
> lines
>
> referencing new as neu;
> for each row
> (
> insert into tablename(id, key) values(1, neu.id || neu.od);> )
>
> informix created a syntax error message concerning the concatenation
> operator.
> In all other databases this works. Why not in Informix? Is there
> something I missed?
> And no I don't wanna define a procedure in which I define a string
> variable to contain the concatenation.
> Thanx in advance.
I'm not sure it will suit your needs (actually I'm sure it will not,
since it is not portable among database servers), but you can try
> referencing new as neu
> for each row
> (
> insert into tablename(id, key) select 1, neu.id || neu.od
from systables
where tabid=1
> )
Best Regards,
Octav
--
Octav Chiriac Phone: (373) 2 22 99 67
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 22 84 88
Moldova, Republic of mailto:com@netinfo-moldova.com