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.
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.