Home › Discussions › Questions & Answers › Dynamically Converting Hardcoded Values in Discoverer SQL

Dynamically Converting Hardcoded Values in Discoverer SQL

Avatar photoCustomer Questions & Answers 5 replies

When importing Discoverer SQL, we frequently encounter hardcoded filter values (literals). Is there a profile that automatically converts these literals into proper bind variables during the import process?

5 replies

  • Support Enginatics

    Yes, you can use the profile option ‘Blitz Report Discoverer Import Literals as Binds’. When set to ‘Yes’, Blitz Report automatically replaces literals with binds during Discoverer import.

  • Avatar photoCustomer

    What is the default setting for this profile?

  • Support Enginatics

    The default setting is ‘No’.

  • Avatar photoCustomer

    Does this only affect Discoverer Worksheet imports?

  • Support Enginatics

    The profile is listed under the Discoverer import settings and applies specifically to the conversion process of Discoverer SQLs.

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