Hi JayaShree,

I guess, there is no possibility of missing decimal fields while downloading to Excel.
Verify the fields you have defined using QRY400.

And, You can view the Layout of the report by taking ‘F13′ in Define Result Fields screen.

Pradeep.

Execl drops insignificant digits. That is because it imports numeric fields as general number format. No simple export to Excel will do any better. It will also drop leading zeros from dates. ssn and part numbers. You might preceed numbers that must retine the leading zero in a ‘.
Phil

If i download report…

Are you downloading a report created by Query/400? Or are you downloading an output file generated out of a Query/400 query?

If you are downloading a file, how are you running the download? What is the definition of the field in the Query/400 output file?

Tom

Hi,

I am downloading a report created by query400. In tables, amount columns are numeric fields having length 15 with 0 decimal positions. In query 400, result fields, if i give decimal position as 4, it is showing report output as 15+4. decimal position is not getting included in total length 15.

if i give length 11 and decimal 4, it is showing some replacement character ‘+’ in report.

Please clarify how to display amount columns with decimal positios?

So do you want the result column to be width 19 digits 4

The result should contain only 15 digits including decimal positions

So the report, using 15-4 is ok.?
The download isn’t.
Are the missing digits zero?
How do you download your file to excel?

Now that I read your statement I’m confused. Are you chaning the width/decimals in Query/400 to 15 4, do you expect this to move the decimal point .. like dividing by 10000?

I am downloading a report created by query400.

How are you doing the download?

If you tell us how, some of our confusion should clear up and we can help better.

There are many ways to get output from Query/400 into Excel. Which way are you doing it?

Tom

Am downloading the report using IBM Iseries..

Am downloading the report using IBM Iseries..
Yes, well we kind of suspected that, but what do you do to get the report spool file to Excel? What do you do on the 400? What programs do you use on your pc and how does a report spool file end up in Excel columns.

Am downloading the report using IBM Iseries..

How do you do that?

What programs do you use? Or what buttons do you click? Or what menu options do you select? Or do you drag and drop the report? Or do you do something else?

Tom