Results 1 to 3 of 3
  1. #1
    Senior Member
    Join Date
    Dec 2003
    Location
    Greater Toronto Area Canada
    Posts
    428
    Thanks
    4
    Thanked 8 Times in 8 Posts

    Default Getting the date at the end of a query

    I know that I can do a command for the admin command line like: q drm > c:\tmp\q_drm.txt and the data will go to a txt file. I also know that I can append by using >>. My question is this. Is there a way to add the system date on to the outuput so that it would be like: q drm > c:\tmp\q_drm.date or something like that? Anyone?

  2. #2
    Moderator Harry_Redl's Avatar
    Join Date
    Dec 2003
    Location
    Czech Republic
    Posts
    2,210
    Thanks
    3
    Thanked 98 Times in 97 Posts

    Default

    Hi,

    what about
    issue message I SystemDate
    select date_time from actlog where message like 'ANR1496I SystemDate%' and cast(minute(current_timestamp-date_time) as decimal) < 5 >>sysdate.txt

    Harry

  3. #3
    Senior Member
    Join Date
    Dec 2003
    Location
    Greater Toronto Area Canada
    Posts
    428
    Thanks
    4
    Thanked 8 Times in 8 Posts

    Default

    Thank you. I will give that a try.

Similar Threads

  1. Where do I find End Of Support date (EOS)?
    By nohup in forum TSM Installation, Upgrade and Configuration
    Replies: 2
    Last Post: 06-14-2010, 04:19 AM
  2. IBM 3583 Library End of support date.
    By huttivoli in forum Tape / Media Library
    Replies: 1
    Last Post: 12-30-2009, 05:02 PM
  3. No Backup Start or End Date
    By jrd31 in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 11-03-2009, 08:46 AM
  4. Query expiration date backup/archive
    By xefil in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 11-21-2008, 12:21 PM
  5. Replies: 4
    Last Post: 08-22-2006, 05:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •