|
My preferred method is to use GoAnywhere. I love that product. Every--
time I try something new, the flexibility of it amazes me.
Nope, no more COMMON's for me. Our company has made the decision to move
to a new ERP (vendor TBD) and is not considering the IBM platform at all
(don't get me started). So, my assumption is I'll be learning Microsoft
Dynamics AX, or SAP, or Oracle, or ??? in the (semi) near future.
No more investment in this platform although, just last week, we moved to
a pair of new Power 8's (8286-42A) with all SSD's. The local box is LPAR'd
for Prod & Dev and the other is an HA machine in another state. What
screamers!! At least, I get to work with nice new hardware and current OS
for the next few years until the new ERP comes on line.
BTW... As a native, I consider Los Angeles to be the "Southland". Though
not the deep south, I guess.
Next time COMMON is in Anaheim, I'll mosey out there one evening and buy
you that Dr. Pepper.
Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
________________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxx> on behalf of Vernon
Hamberg <vhamberg@xxxxxxxxxxxxxxx>
Sent: Monday, March 28, 2016 11:59 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Another FTP question for the group
Hi Roger
Just to add a thought - we use a basic script for FTP - just changing a
sequential number in a file name each day. It used to override STDOUT or
OUTPUT (I forget just now) to an OUTFILE that is copied to a history file.
We've started using Scott's FTPAPI, and it is really nice - every FTP
subcommand has its own CL command, which has a return code and can get
you the FTP error, if any.
I now write stuff to the job log, then retrieve whatever is in the job
log for the process - using msg keys before and after and retrieving
them all.
It'd be easy to add to that the kind of timestamp thing you describe.
Using the FTPAPI, we are able to halt the process in the event of a
fatal error - like when you can't find the host address, of a directory
cannot be changed to, etc.
This might not help you in the future, but maybe it'll be of use to
someone reading the archives.
Will you be at COMMON this year? Gotta get that Dr Pepper - tastes best
in the Southland!
Vern
On 3/28/2016 1:27 PM, Roger Harman wrote:
We have a number of old processes not migrated to GoAnywhere (yet... butthey're on my hit list) that use this technique.
info. So, what I started doing was to add a header and trailer record to
What I have been frustrated with is the inability to track date/time/job
the output files using CL's RUNSQL. All these processes use a QTEMP copy
of the file anyway and then copy it back to a production keeper.
Paul <PSteinmetz@xxxxxxxxxx>
RUNSQL <insert into ...... **START** date/time/job info>
<do the ftp process>
RUNSQL <insert into ...... **END** date/time/job info>
<copy/add the qtemp file to production>
Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
________________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxx> on behalf of Steinmetz,
Sent: Monday, March 28, 2016 8:36 AMto troubleshoot the failure.
To: 'rpg400-l@xxxxxxxxxxxx'
Subject: RE: Another FTP question for the group
Something to think about.
If you turn off these logs, and you have a failure, you will not be able
The logs contain the details of the failure.more than X days old.
Think about a purge process that deletes the spoofile and/or IFS log
We have both in place.OVRDBF location of OUTPUT.
Also, normal FTPs OUTPUT append to the same member depending on the
Ours are all stored in QFTPSRC for each application.the latest FTP process.
You could add a CLRPFM of the OUTPUT prior to the FTP, thus keeping only
Calabro
/* FTP file to server */
OVRDBF FILE(INPUT) TOFILE(*LIBL/QFTPSRC) +
MBR(FTPBACPUTI) OVRSCOPE(*JOB) /* Input +
is keyboard */
Optional - CLRPFM FILE(QFTPSRC) MBR(FTPBACPUTO)
OVRDBF FILE(OUTPUT) TOFILE(*LIBL/QFTPSRC) +
MBR(FTPBACPUTO) OVRSCOPE(*JOB) /* Output +
is screen */
FTP RMTSYS('X.X.X.X')
Paul
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck
Sent: Monday, March 28, 2016 11:06 AMwith
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Another FTP question for the group
On 3/28/2016 10:37 AM, Bill Howie wrote:
We have an automated FTP process that runs about every 10 minutes.
Currently this process generates a spool file of the log of the FTP
commands whenever the process is run. Is there a keyword somewhere
that will shut off the printing of these logs? As you might imagine,
can'trunning the process every 10 minutes these can tend to pile up. I
alwaysthink of what it would be off the top of my head. Any info is as
them. Use WRKSPLF to find the job name that is generating these reports.appreciated. Thanks!The answer depends intimately on the nature of the process generating
Armed with that, you can WRKJOB and find the call stack or job log, which
will tell you the name of the program generating them. Armed with that,
you can then investigate /why/ those logs are being generated and how to
stop them.
helps you, and because it's public, you'll help someone else, too!
--
--buck
Visit wiki.midrange.com and register for an account. Edit a page that
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-lhttp://archive.midrange.com/rpg400-l.
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
questions.
Please contact support@xxxxxxxxxxxx for any subscription related
--mailing list
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
To post a message email: RPG400-L@xxxxxxxxxxxxquestions.
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
