RE: Dynamic SQL

["Fisher, Don" <Dfisher@xxxxxxxxxxxxxxxxx>]

For the numeric fields you must use the %EDITC or %EDITW built-in functions
to make the EVAL statement think they are character fields.  Of course, you
also need to determine which fields are numeric since you don't know the
field definitions.  The only way I know of to do that is to use DSPFFD
<filename> *OUTFILE and then read the file.

Donald R. Fisher, III
Project Manager
The Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@roomstoreeast.com

<clip>
I am trying to output some data from a RPGLE program to a file(table) that
is created in the program.  I have done this before but in this case the
data types are both CHAR and NUMERIC.

I don't  want to have the file created before hand as it is a varible to
the program.  The biggest issue is how to construct the EVAL statement so
that I can mix both CHAR and numeric data while keeping the varible file
name.
<clip>