I have a need to run a sql statement against DB2 and based on the results of
that query write the output to a TXT file.
SQL Looks like this.
=============-----------------===================------------------
SELECT
SAPDW.DW_CALENDAR.sales_cur_date,
SAPDW.DW_BILLTO.BILLTO_NBR,
SAPDW.DW_BILLTO.BILLTO_NAME,
SAPDW.DW_BILLTO.BILLTO_COUNTRY_DESC,
SAPDW.DW_BILLTO.BILLTO_SALES_CHANNEL_CODE,
SAPDW.DW_BILLTO.SUB_CHANNEL_CODE,
SAPDW.DW_COMPANY.COMPANY_CODE || ' - ' || SAPDW.DW_COMPANY.COMPANY_DESC
FROM
SAPDW.DW_CALENDAR,
SAPDW.DW_BILLTO,
SAPDW.DW_COMPANY,
SAPDW.DW_LINE_TYPE,
SAPDW.DW_SALES,
SAPDW.DW_CURRENCY_RATE CURRENCY_RATE_BUS_DAYS
WHERE
( SAPDW.DW_SALES.LINE_TYPE_SK=SAPDW.DW_LINE_TYPE.LINE_TYPE_SK )
AND ( SAPDW.DW_CALENDAR.DATE_KEY=SAPDW.DW_SALES.GL_DATE_SK )
AND ( SAPDW.DW_SALES.BILLTO_SK=SAPDW.DW_BILLTO.BILLTO_SK )
AND ( SAPDW.DW_BILLTO.BILLTO_RECORD = 'Y' )
AND ( SAPDW.DW_COMPANY.COMPANY_SK=SAPDW.DW_SALES.COMPANY_SK )
AND ( CURRENCY_RATE_BUS_DAYS.CURRENCY_TYPE='EURXYTD' AND
SAPDW.DW_SALES.COMPANY_CURRENCY=CURRENCY_RATE_BUS_DAYS.CURRENCY_FROM
)
AND ( SAPDW.DW_CALENDAR.SALES_CUR_YEAR=CURRENCY_RATE_BUS_DAYS.FISCAL_YR )
AND ( SAPDW.DW_CALENDAR.SALES_CUR_MONTH=CURRENCY_RATE_BUS_DAYS.MONTH_NBR )
AND
(
SAPDW.DW_BILLTO.BILLTO_NBR <> 0
AND
SAPDW.DW_BILLTO.SUB_CHANNEL_CODE In ( '10','20','30' )
AND
SAPDW.DW_BILLTO.CUSTOMER_GROUP5_CODE = ' '
AND
SAPDW.DW_COMPANY.COMPANY_CODE = 'OPTR'
AND
SAPDW.DW_LINE_TYPE.LINE_TYPE_CODE In ( 'GR','ZR','DR','CD','AR' )
)
=============-----------------===================------------------
How would I go about writing the results to a text file?