Archives of the TeradataForum

Message Posted: Fri, 27 Aug 2010 @ 13:51:44 GMT

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

Dear users,

When I execute below bteq script

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

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

I get below report. I get two lines of titles and two single quotes (' ') and 3 dashes (---). How can I modify the above select statements to have only one line of titles and have space between reports without two single quotes and three dashes?

     'This generates Privileged Account Use daily report.'
     -----------------------------------------------------
     This generates Privileged Account Use daily report.
     UserName                        JDate        Count(*)
     ------------------------------  --------  -----------
     SYSDBA                          10/08/27        55508
     SYSTEMFE                       10/08/27            1
     ' '
     ---

     'This is Access Violatons Daily Report.'
     ----------------------------------------
     This is Access Violatons Daily Report.
     LogonDate LogonTime UserName                       DatabaseName
     TVMName                        StatementText
     --------- --------- ------------------------------
     ------------------------------ ------------------------------
     -------------------------------------
      10/08/26  13:55:41 XXXXX                         DBC
     DBCInfoTbl                          EXPLAIN Select * From "DBC"."DBCInfoT
      10/08/26  13:55:41 XXXXX                         dbc
     Dbase                                  SELECT DatabaseName FROM dbc.Dbase WH
      10/08/25  09:31:07 XXXXX                         dbc
     Dbase
     ' '
     ---

Thank you for your support,

James

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