Re: Formatting exported data

I tried creating a field with no decimals and multiplying the original field
content by 100. But, CPYTOIMPF "helped". In this case, instead of getting 5
zeros (I had told IQ to not edit the data), I got one zero, centered in the
field. Next test, after some sleep, is to take the field with no decimal
positions, and convert that to a character field.

Only issue with using RPGLE is that I can't recall if this query did any
sorting. If the query does not do sorting, and the character field does not
get around the issues, then RPGLE is the next logical step. This was supposed
to be easy.

John McKee

Quoting Jim Franz <franz400@xxxxxxxxxxxx>:

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.

--
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.