Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 27 Aug 2010 @ 18:38:16 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   How can I have space between outputs
 
From:   JAMES PARK

Now I don't get two lines of same titles as you see below. But there is no space between the two outputs. What do I need to have a space between the two results?

     select 'This generates Privileged Account Use daily report.'(title '');
     Exec prov_acc_use ;
     /* .IF ERRORCODE<> 0 THEN .QUIT  */

     select 'This is Access Violatons Daily Report.'(title '');
     Exec Access ;
     /* .IF ERRORCODE<> 0 THEN .QUIT  */



     This generates Privileged Account Use daily report.
     UserName                 JDate        Count(*)
     -----------------------  --------  -----------
     SYSDBA                   10/08/27        55581
     SYSTEMFE                 10/08/27            1
     This is Access Violatons Daily Report.
     LogonDate LogonTime UserName        DatabaseName        TVMName

     --------- --------- --------------- ------------------- ------------
      10/08/26  13:55:41 XXXXX           DBC                 DBCInfoTbl

      10/08/26  13:55:41 xxxxx           dbc                 Dbase

      10/08/25  09:31:07 xxxxx           dbc                 Dbase


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016