I am using the below sql to get the day of week but i am getting :NumWeekDay as 0
I am using V5R3...can some help me on this to get the day of week.
C/Exec SQL Set :NumWeekDay = DayOfWeek_ISO(:MyDate)
the above sql to get the day of week
July 27, 2012 10:17 AM