Maybe iSeries Navigator is easier for you. Open your list of spooled files (printer output) in Navigator, drag/drop the one you want to your PC, then open it in Excel.
You can smiply use Mgmt central to exort Sysval to execl sheet …
dspsysval is for the system value to be displayed….but u suddenly ask for splf? maybe you can actually tell us what you are actually looking for.
yep jin.. i used the cmd prtsysifo todisplay all the server settings, but i can able to see only as spool file, i would like to make it as excel sheet, could u help me with it.
ok i will try, when u open download ur splf, it shud be like a text file..
Open your excel, and head to file, and open the text file…
that’s where the delimated will bring you thru step by step..hope it works…
Run a command similar to this:
qsh cmd('touch -C 819 mysplftxt.spl &&
catsplf -j 633301/TOML/QPADEV000B QSYSPRT 3 >mysplftxt.spl')
The first part uses the Qshell touch utility to prepare a file named mysplftxt.spl as a simple ASCII text file. (CCSID 819 works fine.) You can use any name you want. I didn’t include a path, so the mysplftxt.spl file will be in my current directory.
The second part uses the Qshell catsplf utility to copy a spooled file into the mysplftxt.spl file. It says to get the spooled file from a job named 633301/TOML/QPADEV000B. The name of the spooled file is QSYSPRT and it’s the third spooled file in that job.
You can display the attributes of the spooled file to get all the pieces needed to paste into that command.
If your current directory is shared out to the Windows network, then all you have to do after that is open the file with Excel.
So in short, create your spooled file, run a command like the one above with the right attributes, and then open the file with Excel.