Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008

    Question Unanswered: Help Needed Comparing Date in DB2 Table to Yesterday's Unix System Date

    In the following Korn shell script, I am attempting to get a count all of the rows from a db2 table in which the PROCESS_DT is equal to yesterday's UNIX system date. The script runs without error, but returns a count of 0 when I am 100% certain that there are over 3 millions records with a PROCESS_DT equal to yesterday's date. Does any one have any suggestions?

    DATE_STAMP=`TZ=CST+24 date +%Y-%m-%d`
    RecCount='db2 -x "select count(*) from schema.tablename where PROCESS_DT=DATE("$DATE_STAMP")`
    echo "$RecCount"
    echo "$DATE_STAMP"

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    Sure it doesn't give you syntax error? You have a straite quote after
    RecCount='db2 ... instead of a back-tick.
    Here +---^
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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