DSPSYSVAL

344655 pts.
Tags:
AS/400 commands
AS400 Job Status
SPLF
How to convert the SPLF to Excel? Where the spool file is generated using PRTSYSINF CMD?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can smiply use Mgmt central to exort Sysval to execl sheet …

Take care

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • jinteik
    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.
    17,600 pointsBadges:
    report
  • Rajasekhar15
    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.
    1,395 pointsBadges:
    report
  • jinteik
    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...
    17,600 pointsBadges:
    report
  • TomLiotta
    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. Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    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. Tom
    125,585 pointsBadges:
    report
  • ITKE
    [...] One member wants to use DSPSYSVAL to convert the SPLF to [...]
    0 pointsBadges:
    report
  • ITKE
    [...] One member wants to use DSPSYSVAL to convert the SPLF to Excel. .topsy_widget_shortcode,div.topsy-sm {display:inline;} .post [...]
    0 pointsBadges:
    report
  • dinuas400
    When you use this command PRTSYSINF the spool file will be generated in your session. You can take out using the iseries navigator
    510 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following