Re: rpgle, pcml & arrays

"Tim M" <scott1328@xxxxxxxxxxxxxxxxxxxx> writes:

Hi Tim,

SQL provides a way for a stored procedure to return a result set. You
can construct result set from a query or from an array.

look at the SET RESULT SETS FOR CURSOR statement.

You can use this in a stored procedure written in a HLL using embedded
SQL or in a store procedure in SQL stored procedure statements.

Ok, thanks a lot for the tip. It will probably help me in another project.

I was planning to use dynamic arrays but LWI (web services server)
doesn't support dynamic lenght parameters in the invoked ile code.

There are few limitations in the product, but it is very easy to provide
web services access to legacy code using a thin ile wrapper.

Thanks for your help

Regards

--
SL> Au fait elle est mieux ma signature maintenant ?
Oui. T'enlève encore les conneries que t'as écrit dedans et c'est bon.
-+- JB in <http://www.le-gnu.net> : Le neueuttoyage par le vide -+-
.

Relevant Pages

  • Re: rpgle, pcml & arrays
    ... allocation. ... If the program allocates memory on demand to store the array, ... SQL provides a way for a stored procedure to return a result set. ...
    (comp.sys.ibm.as400.misc)
  • Re: Passing arrays to a stored procedure
    ... sql developers around the world and Joe your attitude was quite frankly rude ... I am also writing a stored procedure and have to put an array of values into ... > into scalars. ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored procedure to set defaults
    ... AFields() will give you an array of field names, types, etc. ... >I dont know the basis of stored procedure.. ... > "Dan Freeman" wrote in message ...
    (microsoft.public.fox.vfp.dbc)
  • Passing VARBINARY/BINARY param to a stored proc
    ... VARBINARY parameter in an SQL Server 2000 stored procedure. ... Value is an array. ... Dim Proc As Command ...
    (microsoft.public.data.ado)