title: Where does the NOT LOCAL AFTER JOURNAL get stored in the Teradata Catalog tables
body: <p>When I run this below query, </p>
  
  <pre><code>CREATE SET TABLE "DBC1"."NotLocalTable",FALLBACK, BEFORE JOURNAL , NOT LOCAL AFTER JOURNAL , CHECKSUM = LOW  (
      "Column1" CHARACTER(5) NOT NULL,
      "Column2" CHARACTER(5)
  );
  </code></pre>
  
  <p>I see the catalog Journal column contains a value <strong>SS</strong>, which indicates both the before and after journals are <strong>Single</strong> But actually I have run <strong>NOT LOCAL</strong> for AFTER JOURNAL. Since am not sure why in catalog tables the value is shown as <strong>S</strong> (SINGLE AFTER JOURNAL). Meanwhile I checked the Teradata documentation, where it does not show any support/How it gets stored in the Catatlog table, for NOT LOCAL AFTER JOURNAL.</p>
  
  <p>The JournalFlag Column contains only the below values,</p>
  
  <hr>
  
  <h2>Value     |     Description          |</h2>
  
  <p>N        -->      No journal (default)</p>
  
  <p>S        -->      Single journal</p>
  
  <p>D        -->      Dual journal</p>
  
  <p>L        -->      Local AFTER journal</p>
  
  <p>Since I could execute the query without any errors, I see the Teradata accepts NOT LOCAL AFTER JOURNAL, but where does it get stored in the catalog tables ? any Idea ?</p>
  
  <p>Regards,</p>
  
  <p>Ravi</p>