Archives of the TeradataForum

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

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

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>>