Home › Discussions › Questions & Answers › Lexical Parameter Placeholder Usage

Lexical Parameter Placeholder Usage

Avatar photoCustomer Questions & Answers 5 replies

I need to ensure a parameter value is inserted literally as text into the SQL, rather than being treated as a bind variable. This is necessary to force database reparsing when the value changes.

5 replies

  • Support Enginatics

    If you require the parameter value to show up as lexical text in the SQL, you must use the specific placeholder in the Parameter SQL text field.

  • Avatar photoCustomer

    What is the key benefit of using this method?

  • Support Enginatics

    The primary benefit is enabling you to purposefully enforce reparsing for different parameter values, which can be useful for advanced dynamic SQL features.

  • Avatar photoCustomer

    And this must be combined with the &lexical anchor type?

  • Support Enginatics

    Yes, this technique is used with the &lexical anchor, as that anchor type completely replaces the placeholder with the parameter SQL text at run-time.

  • You must be logged in to reply to this post.