Re: Output IBM i query to networked drive

totaly agree.. do not use QDLs, and folders...

QDLS is outdated.

FTP would only be one part of the solution...

as other mentioned, they are many possibilities to exchange data between
systems...
depending on what systems start the process and the level of automation...
you could

- from the server or a workstation use ODBC and acces your DB2 database
from Excell ... (you define your SQL query in the data source in
excell)...
- from System i Navigator, you can run any SQL script and export
immediately to your server drive...
http://www-01.ibm.com/support/docview.wss?uid=nas8N1011114
- I do not know SEQUEL but instead of using QDLS, you canprobably write
a file directly to a shared drive of your windows file server. /QNTC is
perfect for that...
http://www-01.ibm.com/support/docview.wss?uid=nas8N1018146

Paul





From: Bradley Stone <bvstone@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 09/03/2016 22:54
Subject: Re: Output IBM i query to networked drive
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



No. Do NOT use QDLS. Ever for new development.

I'm normally not black or white on an issue.. but this is one of the rare
ones.

http://fieldexit.blogspot.com/2015/03/please-no-more-qdls.html

Brad
www.bvstools.com

On Wed, Mar 9, 2016 at 3:48 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

actually they want to use the QDLS.

Well we would use SEQUEL like here: SEQUEL/EXECUTE VIEW(lib/view)
PCFMT(*PDF) TOSTMF('/QDLS/folder/file.pdf')

How can I view this part QDLS/folder/ ? Then the next step is to map

the

PC server to the QDLS?
Where do I do that in the IBM i?

On Wed, Mar 9, 2016 at 4:37 PM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

Yes, FTP would probably be the easiest I would think. As long as the

FTP

server is up and running on the server you want to send information to

that

is. :)

Brad
www.bvstools.com