Hi ,
I have a stored procedure which will update the table. I have added it as right click on Name space --> create --> Query Subject -->Stored Procedure --> Selecte it from DB --> Validate it and then add it.
i didn't maintain presentation layer so this is the final layer i have.
After selecting it in the Package definition and Publishing the same the added query subject is not available in the path in the published package. What could be wrong here.
Does the stored procedure have a return value? If not, try adding a
select
@@ rowcount as rowCount
Note that in FM you can denote if a procedure modifies data or is expected to return data (result set).
The former is intended for Event Studio and the latter reporting.
If a stored procedure does not a resultset then it would be used in a reporting package.
More details should be in the documentation