How to: Disable SQL Parser

This article discusses three different ways to disable SQL Parser

Why disable SQL Parser?

It may be necessary to disable SQL Parser if your get false failures (SQL Parser incorrectly fails forecast).

Three ways to disable SQL Parser

1. Globally at the project level

2. At folder level in SQL repository

3. At changeset level

Instructions

For disabling SQL Parser globally at the project level

In Datical GUI:

1. Open your project

2. Browse to settings tab

3. Expand “Deployment Setting” and uncheck the box for “Enable Oracle SQL Parser”

   1. Open

      

       

4. Be sure to commit your project back to you Git repository.

For directly editing the datical.project file:

1. Open datical.project file in your favorite text editor.

2. On line #2, scroll to the section where it says enableSqlParser=”true” and change it to enableSqlParser=”false”

3. Save your file.

4. Be sure to commit your project back to you Git repository.

For disabling SQL Parser at folder level in SQL repository

1. Identify the folder where you want to disable SQL Parser

2. In that folder, open the metadata.properties file. If one does not exist, you can create one.

3. In your favorite text editor, add the following line: disableSqlParser=”true”

4. Save your file.

5. Be sure to commit your project back to you Git repository.

For disabling SQL Parser at a changeset level

1. In you favorite text editor open your changelog.xml file from your Datical repository

2.  Find the relevant changeset where you want to disable SQL Parser.

3. Add disableSqlParser=”true” in the changeset, as follows:

   1. <changeSet appdba:scriptChecksum="9f8a11051d1478faf2752baacb76cf0e" author="J Doe" created="2020-08-10 18:37+0000" datical:origFileName="adding_test_new_001.sql" datical:origFilePath="scripts/sql_direct" datical:version="1" datical:versionStrategy="DEPLOY_ALL" id="20200810183704986_adding_test_new_001" labels="509,deploy-test1,deploy-test1,adding_test_new_001.sql"> <appdba:sqlplus disableSqlParser="true" enableRollbackOnError="true" path="sql/20200810183704986_adding_test_new_001.sql" removeSpools="First" schemaName="SCHEMA1"/> <comment>Test script</comment>

       

4. Save your file.

5. Be sure to commit your project back to your Git repository.