DROP PROCEDURE lt_test5;

CREATE PROCEDURE rmvreg2:lt_test5 ( )
RETURNING char(1),char(10),char(8);

DEFINE cd CHAR(1);
DEFINE des CHAR(10);
DEFINE abr CHAR(8);

FOREACH

SELECT owner_cd,owner_des,owner_abr 

INTO
cd,
des,
abr
FROM vl_vhowner 
RETURN cd ,des,abr WITH RESUME;

END FOREACH;
END PROCEDURE;

-- Permissions for routine "lt_test5"
grant execute on lt_test5 to 'public';

IfxDataAdapter adapter = new IfxDataAdapter();

            IfxConnection connection = new IfxConnection();
            connection.ConnectionString = ConnetionString;

            //Set the command object properties.
            adapter.SelectCommand = new IfxCommand();
            adapter.SelectCommand.Connection = connection;
            
            adapter.SelectCommand.CommandText = "lt_test5";
            adapter.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;

            
            adapter.Fill(ds._Tax);