File Format for Externally Loaded Views

File extensions for externally loaded views must be .SQL for Oracle views and .SAS for SAS views. An SAS and SQL load file must exist for each view loaded. The Load External Views function does not do error checking, so if an invalid syntax is specified, view maintenance fails.

See the following:

• Example 1: Oracle Format
  
• Example 2: Oracle Format with Substitution Parameters
  
• Example 3: SAS Format