RE: [SYSTEM21] Running S21 tasks from outside S21

[<forums@xxxxxxxxxxxxxx>]

Another quick option of getting data down to your PC program may be found in
some free tools I found just this passed weekend while working with IBM's
CGIDEV api's. The tool is called DB2XTOOL and gives you a simple command to
take your data down to the IFS as either text, csv, xml or html. My guess is
csv would be your best option if you wanted to run something like excel over
it.

Once the file is extracted to the IFS you can pick it up on your PC through
an IFS share.. The command will even launch EXCEL for you if you so choose
once the file is built. Clever stuff!!

You can learn more at http://www-922.ibm.com/db2xtool


-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Chris Tringham
Sent: Thursday, April 21, 2005 6:20 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Running S21 tasks from outside S21





Hi,

We need to run a S21 (bespoke) task in order to extract some data to be
used by a PC progarm.

A search of the archives comes up with with the suggestion of using
EXCAMTASK.  Unfortunately when I try this in Aurora it does nothing.  The
old RUNAMTASK does seem to work, but a very wise person has advised that
this is an old command that we shouldn't use.  Does anyone have any advice
on that subject?

The second part of the question is whether it's better to use FTP, Client
Access or some clever stuff with database triggers (i.e. the PC program
uses ODBC to write to an AS/400 DB file that has a trigger on it).  Again,
I'd be grateful for any advice on this.

Best Regards
Chris

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.