31 Aug 2006
use (title '') for each filed.select APP_NAME(title ''),RUN_NAME(title ''), GROUP_NUMBER(title ''), RUN_ORDER (title '')from $DBPREFIX.dm_driver_steps_t where run_status = 'S' and run_order = 40;use set underlines and titledashes to off.--Sparan
31 Aug 2006
Sparan,Thanks for the help. This solution is just what I needed.
31 Aug 2006
Another way without specifying (title '') for each column:.export DATA file=.....set recordmode offExports in REPORT mode without any header...But don't ask my WHY it's working this way :-)Dieter
31 Aug 2006
Thanks Dieter
16 Oct 2006
.SET TITLEDASHES OFF;will do if you only want to get rid of the dashes.
input output putput
You must sign in to leave a comment.
I am trying to run BTEQ with a .EXPORT command as below...cat << !* > $getpth .logon $SCHEMA/$USER,$PASSWORD; .EXPORT REPORT FILE = kbtstfile; select APP_NAME, RUN_NAME, GROUP_NUMBER, RUN_ORDER from $DBPREFIX.dm_driver_steps_t where run_status = 'S' and run_order = 40; .EXIT !* Everything works and returns expected rows, but how can I get rid of the column headers and -------- that return below??APP_NAME RUN_NAME GROUP_NUMBER RUN_ORDER ------------------------- ------------------------- ------------ --------- edw STG_ODS 100 40