Exporting a query in AS/400
How do I export a query that I'm currently viewing?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 19, 2011 9:22 PM
UPDATED:
February 28, 2012 7:57 PM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
Yes, I mean the results. I want to export the results. Thanks.
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.
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