Re: Formatting exported data

Rather than mess around with a tool like IQ with it's limitations,
I would write with RPGLE directly to the IFS, and have complete
control over all formatting.
Scott Klement has a tutorial and working code - very easy to follow
if you are comfortable in rpgle
http://www.scottklement.com/rpg/ifs.html

Otherwise, does IQ support creating a field with zero decimals from
your current field?
Jim

----- Original Message ----- From: "John McKee" <jmmckee@xxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, October 31, 2008 10:25 PM
Subject: Formatting exported data

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.