Midrange News for the IBM i Community

Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
Fixing '40404040' in a numeric field
has no ratings.
Published: 19 Jul 2012
Revised: 23 Jan 2013 - 3448 days ago
Last viewed on: 02 Jul 2022 (5463 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Fixing '40404040' in a numeric field Published by: Chris Proctor on 19 Jul 2012 view comments(5)

Good morning. I have a file that has '40404040' in a numeric field and I'm having a heck of a time writing either a program or SQL to set them to zero. Does anyone know of a simple way to fix these records? I'd appreciate the input.


Return to midrangenews.com home page.
Sort Ascend | Descend