hi, can help me with the sql script to output data into text file
i would like to generate the text file and name it to TRANSACTIONS_<extraction date>_<total records>.txt
export to C:\temp\TRANSACTION_20140101_4023.txt of del
modified by coldel| nochardel
select * from (
select A.USERID, B.ICNO, A.ACCOUNTNO, A.REFERENCENUMBER, A.TYPE, B.BRANCHCODE, B.STATUS,
varchar_format(TRXTIMESTAMP,'MM/DD/YYYY HH:MM') AS TIME,to_char(A.AMOUNT)
FROM TABLE1 AS A, TABLE2 AS B
WHERE A.USERID=B.USERID AND TRXTIMESTAMP >= '2014-01-01' AND TRXTIMESTAMP < '2014-02-01')
db2 sql script create txt file name