Error while BCPing a views data (with Warning: Null value is eliminated by an aggregate or other SET operation)

Problem:
Unable to BCP a view

Error:
SQLState = 01003, NativeError = 8153
Warning = [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.

Why:
obviously that view giving aggregating some nulls

Solution Looking for:
Way to SET ANSI_WARNINGS OFF inside the view
or some other bcp switches
or some other settings
so that i wont get that warning and so that the bcp won't fail

Solutions not looking for:
Workarounds like, avoid getting those nulls using NOT NULL etc.,

Other info:

I checked db options "ansi warnings" is set to off

Background:

I have a view which has SUM aggregation on few columns
some times for some reason some of these columns gets NULL and for obvious reason SQL server gives a warning message "Warning: Null value is eliminated by an aggregate or other SET operation."

i checked db properties and found ansi_warnings is set OFF

i cross checked using this query as well

select name,is_ansi_warnings_on from sys.databases

which is showing 0 (meaning OFF? correct if am wrong)

use a dummy view i created to simulate the issue

thanks for your help in advance

-- Create this view to simulate the issue
CREATE VIEW VW_DUMMY 
AS
SELECT * FROM (
SELECT SUM(CAST(NULL AS INT)) AS SOME_FILED )AS X WHERE SOME_FILED IS NOT NULL
go
 
-- and bcp using below command-line
 
bcp mydbname..vw_dummy out dummy.txt -Smyservername -T -c
 
SET ANSI_WARNINGS ON
select * from vw_dummy -- switch to messages tab, shows a warnig message
SET ANSI_WARNINGS OFF
select * from vw_dummy -- now it wont

Select allOpen in new window