RATE THIS ANSWER
+1
Click to Vote:
1
0
Last Answered:
Mar 11 2008 10:27 AM GMT
by Gilly400
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.