<http://schema.org/articleBody>
"You're right Rob, so I took it upon myself to solve this weird issue. And I wanted to solve this wholly within SQL rather than use RPG. Here is my solution. I expect that someone has a cleaner method, but I didn't want to burn too much time on it. Given a similar data set to before, a list of dec(8,0) numbers that are expected to represent dates in YYYYMMDD format. ....+....1. NBRDTE 20,140,228 20,140,229 20,140,430 20,140,431 20,140,304 20,140,532 20,140,631 19,840,228 19,840,229 19,880,228 19,890,228 20,0..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/201405/msg00270.html>