Thanks a lot for your reply. It explains a lot and add many things to my knowledge. As I said, I am not much familiar with software side so i might have put wrong description to explain system versions. I work on business planning side.
but regarding formulas, I will try to explain in better way.
First I logged into iSeries communicator and wrote a new query (using query profile). For that I selected a file (abc) and then parameter sorting, output format etc.
I saved that query. After running that query, I opened MS Excel and imported data using Addin tab. On addin tab, I clicked on import data -> import data from iseries -> located library -> file name -> import.
So till this point, I got the data, which I was supposed to get when I wrote query. But problem here is - I want to know what formulas are used in file abc. abc has three parameters in it. (numbers, average, 12 month average). I can write queries using file abc, I can import data into Excel after running queries but I am not able to understand what formulas are used behind these three parameters into iseries file.
In short, when I go to option - Display database file (in iSeries communicator), I see parameters and their values on the screen but I cannot see how they are calculated (e.g. 12 month average, mean, deviation etc. ) Is there anyway to go behind these parameters to see formulas?
does it tell you more about my problem ?