Warehouse Libraries - Number Functions Implementation Notes

• Upload to CTL:
• lib_number.sql

• Run the following in order:
• CTL script: lib_number.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_number_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_number_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_number_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_number_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.