Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 db2 sql script create txt file name

views
     
TSaMaZinG
post Apr 14 2014, 01:25 PM, updated 10y ago

Getting Started
**
Junior Member
69 posts

Joined: Jan 2010


hi, can help me with the sql script to output data into text file rclxub.gif
i would like to generate the text file and name it to TRANSACTIONS_<extraction date>_<total records>.txt icon_question.gif


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')





 

Change to:
| Lo-Fi Version
0.0111sec    0.39    5 queries    GZIP Disabled
Time is now: 29th March 2024 - 07:41 AM