Convert J.D. Edwards Dates to Other Formats

Hey, Howard:

I want to convert a J.D. Edwards date, (CYYDDD where C represents the century, YY represents the year, and DDD represents the day of the year) to a more readable format, (like YYYY-MM-DD). I can do this in Crystal Reports, but is there a way to do it in SQL?

-- Domenic

READ MORE >

Edit with Parentheses in Query/400, Take Two

Hey, Ted:

I read your response to the question posted in the August 28 issue of Midrange Guru, and since I don't work much with negative numbers, I changed data to try your solution. I think I found something, but I don't know why or how it works.

-- Doug

READ MORE >

Reader Feedback and Insights: Copying Records in RPG

I'm writing about the August 23 Midrange Guru Tech Tips regarding moving records between files with different field names . One option that I didn't see, and the one I now prefer, with RPG IV is using the prefix keyword to rename the fields from one of the files.

-- Scott