I am new to Informix. I tried creating timeseries calendar pattern which should store data only for weekdays (Monday-Friday).
I inserted the data below for that into CalendarPatterns table:
INSERT INTO CalendarPatterns (cp_name, cp_pattern)
VALUES ('5day_ptrn', '{1 off, 5 on, 1 off}, day');
While trying to inserting record into a table which is using this calendar pattern, it's storing data for Saturday and Sunday but not storing data for Thursday and Friday.
Please advise where I am going wrong.