Exporting a query in AS/400

30 pts.
Tags:
AS/400 administration
AS/400 Administrator
AS/400 Query
How do I export a query that I'm currently viewing?
ASKED: March 19, 2011  9:22 PM
UPDATED: February 28, 2012  7:57 PM

Answer Wiki

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

Do you mean the results or the actual *QRY object you created?
Tell us what you ware doing and we will give you an answer

Yes, I mean the results. Is there a way to export results? Thanks

Discuss This Question: 3  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
  • HIM
    Yes, I mean the results. I want to export the results. Thanks.
    30 pointsBadges:
    report
  • CharlieBrowne
    If the results are a DB file, you can use FTP to send them to another system. If the results are a spool file(s), you can send them as attachements in an email. There have been many Q & A on this website that explain different ways of sxporting either a spool file ot database file to another system and/or a ifferent user. The fact that it is an output from a querry is not relavent. Just treat it the same as any ohter file or spool file.
    39,780 pointsBadges:
    report
  • TomLiotta
    Define "export". If this is an outfile created by running a Query/400 *QRY object, the export is done as CharlieBrowne said -- you do it the same as you would for any database file. Your major decision will be based on the target of the export. Is it another AS/400? Is it SQL Server on Windows? Is it Oracle? Something else? How will the target import the data? Once a target platform is determined, the connection needs to be known. Will the connection be through the network? Is the target on the same network as the AS/400? Is the connection through the internet? Will the data be sent through FTP? Through e-mail? Something else? It might also help to know the AS/400 operating system version and release. Recent releases have more options than earlier releases. The version of the target platform might also be helpful. Tom
    125,585 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