I am having a brain fart using the arsdoc delete command. I know I must be missing a quote or something but I have tried a couple of variations and can't get it to work. I am getting either the SQL0401N or the SQL0180N error. The command I am entering is below.. What am I missing? The IDate is the AppGrp database name for the Index Date/Time Stamp and I got the values using the arsdate -z command.
arsdoc delete -u userid -p passwd -h ondemand -f "T E S T Statements" -v -G TSTSTMT -i "WHERE AcctNo='123456789' AND IDate BETWEEN 1487930400 AND 1487934900"
Is the account number field a string, or an number? (No quotes on numeric fields.) Also, double-check your date field to see if it's a date or date/time field. Date fields will have numbers between 1 and 36525, and date/time fields will have much larger numbers, provided the document you're looking for isn't before 11am on January 1st 1970.
Finally, I think the between operator needs parenths...
BETWEEN (1487930400 AND 1487934900)
-JD.