title: Alter variable format using SQR programming language
body: <p>I am new to Peoplesoft and Peoplecode/SQR in general and I want to ask a question. </p>
  
  <p>What I wish to do, is to try and output a large (clob) string variable on a PDF file using SQR programming language, on 3 columns on the page, just as you can change the layout of a text in Microsoft Word by going to Layout -> Columns -> Three </p>
  
  <p>What I have until now is this: </p>
  
  <pre><code> begin-select
     TXT.U_PO_TXT &amp;TXT.PO_TXT
     from PS_U_PO_DISC_TXT TXT
     where TXT.BUSINESS_UNIT = &amp;PO.BUSINESS_UNIT
     and TXT.PO_ID = &amp;PO.PO_ID
   end-select
  </code></pre>
  
  <p>So, </p>
  
  <pre><code> TXT.U_PO_TXT
  </code></pre>
  
  <p>is a CLOB stored in the database of 10000 characters and I want to output </p>
  
  <pre><code> &amp;TXT.PO_TXT
  </code></pre>
  
  <p>on the PDF using the layout described above. </p>
  
  <p>I have tried using COLUMNS and NEXT-COLUMN SQR commands but to no avail. 
    I find the documentation of SQR on the Oracle website poorly written. </p>
  
  <p>This is the example I have found, applied to my case: </p>
  
  <pre><code>columns 10 50 110
  move 55 to #bottom_line
  begin-select
   TXT.U_PO_TXT &amp;TXT.PO_TXT
   if #current-line &gt;= #bottom_line
   next-column goto-top=1 at-end=newpage
   else
   position (+1,1) !what is this even, it throws me an error "Unknown command"
   end-if
   from PS_U_PO_DISC_TXT TXT 
    where TXT.BUSINESS_UNIT = &amp;PO.BUSINESS_UNIT
    and TXT.PO_ID = &amp;PO.PO_ID
  end-select
  </code></pre>
  
  <p>I couldn't find an answer anywhere. Please help me.</p>