Iam trying to export data to flat file which needs to be sent as email to everyone.
Iam having difficulty in getting the alignment of the header and the data
Currently Iam getting the email like below .Can anyone help me on how to generate a email report
CUST_D_CORE 1803886264080 63.67 360777252816
BTEQ export script
select '--DATABASENAME-------OLDMAXPERMSPACEVALUE-----SPACEUSEDPRCNT-----SPACEALLOCATEDFROMSYSDBA'; select ' '; select ' '; SELECT CAST(DATABASENAME AS VARCHAR(20)) ,TRIM(MAXPERMSPACEVALUE) AS OLDMAXPERMSPACEVALUE ,TRIM(SPACEUSEDPRCNT) ,TRIM(SPACEALLOCQNTY) FROM SYSDBA.GT_MOVESPACE GROUP BY 1,2,3,4;
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.