OK I have another problem.
I want to automate a query to run and pull all new info as of the day before. So, when i run it I want it to do this:
where timestamp= current date timestamp- 1 day.
but i want it to run it as of midnight today - 1 day
I am having trouble explaining this and I am sorry.
JH
hathewj
Last Activity: Jan 25 '08, 06:05 PM
Joined: Jan 24 '08
Location:
-
Thanks, but I have to run the export in QMF for windows. I know QMF pretty well, but that is about it.
I tried but no go in QMF -
Export DB2 file with correct date
My export line looks like this:
EXPORT DATA TO C:\IMPORT\ASSET S.CSV (DATAFORMAT = CSV
This works OK, but this file is eventually sent automatically via FTP to another location and the file has to be in this format:
ASSETS-YYYY-MM-DD.CSV where the yyyy,mm,and dd are todays date.
Rather than rename each after the proc has run, is there a way to allow DB2 to add that date?
Thanks
No activity results to display
Leave a comment: