Warehouse Libraries - String Functions Implementation Notes

• Upload to CTL:
• lib_string_a.sql
• lib_string_h.sql
• lib_string_b.sql

• Run the following in order:
• CTL script: lib_string_a.sql
• CTL command: EXEC lib_util.create_grants;
  
• STA command: EXEC lib_util.create_synonyms;
• VAL command: EXEC lib_util.create_synonyms;
• ODS command: EXEC lib_util.create_synonyms;

• Run the test script; CTL: lib_string_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.
• Run the test script; STA: lib_string_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.
• Run the test script; VAL: lib_string_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.
• Run the test script; ODS: lib_string_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.