I have some doubts, or who knows some suspicion of bugs.

1)
I can submit this query (for example from a tool like IBAdmin) :

SELECTssp.some_output_param, st.some_colum
FROM some_stored_procedure ssp JOIN some_table st ON
(ssp.some_output_param = st.some_colum)

Why can't I create a VIEW from this ?


2)
In Stored procedure I am using the code below to Set a MyNEWVAR value to a
Generator :
...
somevar = - 1 * Gen_Id( "SOME_GEN", 0 );
somevar = Gen_Id( "SOME_GEN", somevar );
somevar = Gen_Id( "SOME_GEN", MyNEWVAR );
....

Is there any other way to do this ?


TIA,


MNobre