How to create a Spool file

770 pts.
Tags:
AS/400 Spool Files
AS400 Command
I queried on a file it gives me hundreds of records. Is it possible to create a spool file with these record? If yes then please tell me how?

Software/Hardware used:
AS400

Answer Wiki

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

Discuss This Question: 5  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
  • philpl1jb
    What did you use to query the file?
    49,730 pointsBadges:
    report
  • ankit2002
    @philpl:we need to fetch some employee names according to their process level and job code,that is the reason we query on the file.
    770 pointsBadges:
    report
  • philpl1jb
    There are a lot of different tools that can query this data.  What tool are you using? 
    49,730 pointsBadges:
    report
  • philpl1jb
    On the AS/400 there are Query/400, QM/query, Interactive SQL and any number of third party products that can query the data. Of course then there are all sorts of client products from IBM ( client access, navigator ) or from third parties.  The answer would be different for each. 
    49,730 pointsBadges:
    report
  • ankit2002
    Hi All,         Thanks a lot for all the help and responses. I found a method to do this task.Please go through the following steps:Step 1: Give STRSQL commandStep 2: Give SHIFT + F1  then option 1(Change Session Attributes)Step 3: Give option 2 (For *printer) in SELECT Output Option.Step 4: Press Enter Twice.Step 5: Now run your query and check your spool file. The records will come as spool file.
    770 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