Formatting exported data

[John McKee <jmmckee@xxxxxxxxxxxxxx>]

This could be a long story, so I will skip some of the nasty details.

An application was written, using IQ.  Initially, selected database fields were
extracted and written to a file in QDLS.  The IQ product has some issue with
the use of a leading / on a filename and also does not allow the filename to be
quoted.  Thus, the use of QDLS.  It is very likely that a relatively simple RPG
program could also be used.

Now, the weirdness.  I had this wild idea to modify the IQ query to output to a
database file in QTEMP, and then CPYTOIMPF to an IFS file.  Sort of works,
except that CPYTOIMPF insists on inserting a separator character (decimal
point) on one field.  First thought that comes to mind is to have IQ create a
new field that has no decimal positions.  Which may be all that is needed.

Is CPYTOIMPF command the proper command to use, and all I really need to do is
modify the numeric field to not have a decimal value?  Or, is there a better
method?  Just gets me that all the other data fields get formatted exactly as
needed.

John McKee