we trying to export SELECT * FROM TableName from db2 to flat file. By default it exports with comma as separtor and puts double quotes before and after the varchar columns.
Now when we trying to replicate the same using bteq using report mode, we are not getting double quotes.
Please and kindly help me to figure out the problem. Is anything specific to TeraData and bteq script.
need urgent response.
I have written query which is actually giving undesired result.
23234, 45345, "TeraData"
If you see, there is space in between result set which we do not want in Textfile.
Kindly help, its on urgent basis:
Query is as follow:
bteq << ! > ./test_b.log
.SET ERROROUT STDOUT
.os rm ./test_b.txt
.EXPORT REPORT FILE=./test_b.txt
.set width 65531
.set separator ','
.SET TITLEDASHES OFF;
.SET NULL AS "";
select cast(SITE_ID as varchar(10)) (title ''),
cast(ENTITY as varchar(10)) (title ''),
cast(SITE_SEQ_NBR as varchar(10)) (title ''),