Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   BTEQ Formatting
 
From:   JAMES PARK

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