Need to add spaces in header

Tools & Utilities
Enthusiast

Need to add spaces in header

I have bteq script to create flat file as follows. I need to add spaces in header after date. But when I add like ' ' it is not working. How to create spcaes in header after date.

/*** Create header record ***/

SELECT

'^000' || '|' ||

(EXTRACT(year FROM date) (format '9(4)') (char(4))) ||

(EXTRACT(month FROM date) (format '9(2)') (char(2))) ||

(EXTRACT(day FROM date) (format '9(2)') (char(2))) || ‘ ‘ Header;

/*** Create detail record ***/

select

cast('^' as char(1)) || '|' ||

COALESCE(cast(acct_nbr as varchar(13)),'') || '|' ||

'|' ||

COALESCE(cast(acct_nbr as varchar(14)),'') || '|' ||

'|' Data_records

from DB_GBLTMP_TKN.wrd_gt

order by bst_land_acct_nbr;

/*** Create trailer record ***/

SELECT

cast('^' as char(1)) ||

'999' || '|' ||

(count(*)+2 (format '9(10)') (char(10)) ) || ‘ ‘ Trailer

from DB_GBLTMP_TKN.wrd_gt;