How can I use optional input parameters on a MetaMatrix Virtual Procedure?
Issue
- I have a virtual procedure with two parameters -- MemberIdentifier_In and SourceSystem_In. I query it using the following syntax:
select * from Canonical_Router.Member where sourcesystem_in='WGS' - When I execute the query, I receive the following error message:
No valid criteria specified for procedure parameter Canonical_Router.Member_MemberIdentifier_In
Environment
-
MetaMatrix Enterprise Server
-
MetaMatrix Virtual Procedure with MemberIdentifier_In parameter set to NULLABLE
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
