converting character to numeric in query/400
Hello, Is there a way of converting character to numeric data in WRKQRY? I've read Query/400 manuals and found no simple way of data conversion. Thanks in advance!
Software/Hardware used:
Software/Hardware used:
ASKED:
March 11, 2008 3:45 AM
UPDATED:
March 11, 2008 12:36 PM
RELATED QUESTIONS
Answer Wiki:
Hi,
I don't believe there is a simple way to do this in WRKQRY. You might have more success with Query Manager (command STRQM) or SQL (command STRSQL).
If you really need to convert character to numeric for WRKQRY, what you could do is create an identical DDS described file with a numeric field in the place of your character field (with the same lengths) and use CPYF with FMTOPT(*NOCHK). But I'm sure there are better solutions than this.
Regards,
Martin Gilbert.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
