How can I use optional input parameters on a MetaMatrix Virtual Procedure?

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In