Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   How can I have space between outputs

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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020