Adding Complete Directory Path in the Master Script

You can add the complete directory path in the master script codegen_workflow_Run.sql by editing the master script file.

To add the complete directory path in the master script:

1. Open the master script codegen_workflow_Run.sql, and locate the following lines:

   -- Workflow run

   @@"INSUR_CUST_LTV_SAMPLE BUILD.sql";

   @@"INSUR_CUST_LTV_SAMPLE APPLY.sql";

   @@"Class Build.sql"; @@"Coefficients.sql";

   @@"MODEL_COEFFCIENTS.sql";

   @@"Apply.sql";

   @@"SCORED_CUSTOMERS.sql";

2. Edit the master script file to add the complete directory path, where the scripts will be stored in the target or production database host computer. In this example, it is assumed that the script files will be deployed to home/workspace directory. For example:

   -- Workflow run

   @@"/home/workspace/INSUR_CUST_LTV_SAMPLE BUILD.sql";

   @@"/home/workspace/INSUR_CUST_LTV_SAMPLE APPLY.sql";

   @@"/home/workspace/Class Build.sql";

   @@"/home/workspace/Coefficients.sql";

   @@"/home/workspace/MODEL_COEFFCIENTS.sql";

   @@"/home/workspace/Apply.sql";

   @@"/home/workspace/SCORED_CUSTOMERS.sql";

3. Save and close the master script file.