Message-ID:

War is never imperative. -- McCoy, "Balance of Terror", stardate 1709.2

computers / comp.sys.ibm.as400.misc / Exporting Data From AS400

Exporting Data From AS400

<3274f092-6ef9-4bb5-b2b3-4401e02e6cfdn@googlegroups.com>

https://www.novabbs.com/computers/article-flat.php?id=19&group=comp.sys.ibm.as400.misc#19

copy link Newsgroups: comp.sys.ibm.as400.misc

X-Received: by 2002:a05:622a:5c8:: with SMTP id d8mr89229qtb.63.1634652358269;
Tue, 19 Oct 2021 07:05:58 -0700 (PDT)
X-Received: by 2002:ac8:5715:: with SMTP id 21mr143909qtw.56.1634652358031;
Tue, 19 Oct 2021 07:05:58 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Tue, 19 Oct 2021 07:05:57 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=66.43.241.107; posting-account=FCRO0goAAADo9NxwvXGTY1MlrD4ChURE
NNTP-Posting-Host: 66.43.241.107
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <3274f092-6ef9-4bb5-b2b3-4401e02e6cfdn@googlegroups.com>
Subject: Exporting Data From AS400
From: dough...@gmail.com (Doug H)
Injection-Date: Tue, 19 Oct 2021 14:05:58 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 9

by: Doug H - Tue, 19 Oct 2021 14:05 UTC

I have a VDI connection that has IBM iSeries Access for Windows and ISeries Navigator on it. There is an ODBC connection setup.

I am able to write sql queries and retrieve data from some tables using the
iSeries Navigator.

I'd like to be able to create scripts and execute batches that will run the queries and output the data to files into Windows folders.

Is there a way to do this with just these tools (I'm familiar with sql queries, extracts, etc but not against an AS400 system) or do I need some additional software to be able to create routines that can be executed to produce the output?

Thanks for any info.