Re: stored procedures
>1. What`s the syntax to define a whole table record in SPL?
> When I use DEFINE r_table RECORD LIKE Table.*, I get a=20
> compilation error :-(
There isn't one. Grrrr :-(
>3. And now the difficult one (for me):
>
> table xy
> =20
> no name
> ------------
> 1 Michael
> 1 Michael
> 2 Thomas
> 3 David
>
> What=B4s the SQL-syntax to get the name for all records which have more
> than one entry.
>
> The result should be:
> >>>> 1 Michael.
SELECT *
FROM xy
GROUP BY no, name
HAVING COUNT(*) > 1
Or something like that... :-)
HTH.
--
Cheers,
Billy.
----------------------------------------------------------------------------=
-
billy.wheeler@pixie.co.za +27 11 803=
2151
p.o. box 3463, rivonia, rsa, 2128 +27 83 250=
2324
informix developer at large (and i mean _large_)
----------------------------------------------------------------------------=
-