RE: Callable statement with RPG

Have a SQL RPGIV program that does the joins and returns back a the result
set as a Data Structure.    It could be a Multiple occurance for a blocked
fetch.  Have the RPGIV program also pass back a copy(easiest way)  of the
SQLCA data structure so the calling program can look at the SQL warning
message to see how many rows were actually retrieved.

You could send to the SQL RPGIV the WHERE and the ORDER BY statements and
have it do the PREPARE and DECLARE .

Very easy.  Pass back a data structure that looks like the "Format" of what
the join would look like.

John Carr
----------------------


Has anyone used a Callable statement that exec an RPG program that uses
native I/O and return a result set.  We are passing a parm ID that reads a
master file for all matching ID's, we then take the color code from the
master file and read the color file for it's description, then the same
with
a size file and so on.  We want to return the compiled data as a resultset,
but don't want to join 5 tables.

Any ideas.

Thanks Barry