×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I have a query that receives a 4 byte branchnbr as a parameter and then outputs data to a file. The fields in the query are branchnbr (4, 0) sequence (2, 0) Description (25) FinlTot (14,2). The first three fields come directly from the file being queried.
FinlTot is a result field. When I run the query using strqmqry the lengths stay the same on the first three fields, but the lenght of Finltot is changed from 14,2 to 20,2.
If I use dfu to display the file that's created, or I use it in a program, I have no problem. The field is longer, but the data is okay. However, when I try to use the file in a query, the data gets shifted. 600.00 becomes 6000.00. Obviously I can create a result field and divide Finltot by 10. But Long story short, is there a way to stop query manager from changing the length in the first place?
Emily
CONFIDENTIALITY NOTICE: This email message is private,
confidential property of the sender, and the materials
may be privileged communications intended solely for
the receipt, use, benefit, and information of the intended
recipient indicated above. If you are not the intended
recipient, you are hereby notified that any review,
disclosure,distribution, copying or taking of any
other action in reference to the contents of this message
is strictly prohibited, and may result in legal liability
on your part. If you have received this message in error,
please notify the sender immediately and delete this
message from your system. We believe that this email
and any attachments are free of any virus or other defect
that might affect any computer system that it is received
and opened in, however, it is the responsibility of the
recipient to ensure that it is virus free and the sender
accepts no responsibility for any loss or damage.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.