RE: SQL Check If File Exists (via RPG)

No "DB2 Multisystem".

Ideally, having the correct temporal information would be the true solution.  It's an old JBA ERP system and the tables just don't support what we need for this particular circumstance.

Since, as I mentioned, non-existence should be a rare to none condition I'll likely just attempt the update and deal with a possible error.  

Probably just baggage from how I was taught that I think to try and avoid certain errors first rather than dealing with it after the fact.  Not applicable in this case though.

Roger Harman
COMMON Certified Application Developer – ILE RPG on IBM i on Power


----------------------------------------

To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL Check If File Exists (via RPG)
From: rob@xxxxxxxxx
Date: Tue, 3 Nov 2015 07:04:32 -0500

I don't suppose you have "DB2 Multisystem" loaded, do you? Then you could
partition (member) the historical file with a partition by year/month.

It would be really nice if this existed
http://archive.midrange.com/midrange-l/201505/msg00150.html
then it would take care of updating the historical table for you.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Roger Harman <roger.harman@xxxxxxxxxxx>
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
Date: 11/02/2015 06:48 PM
Subject: SQL Check If File Exists (via RPG)
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



I have a situation where I need to update/add/delete records in a
historical snapshot file (or files) if the current live file is changed
(retro-active changes).

The historical files are named by year/month and may or may not exist for
a selected record.

Looking for suggestions on the quickest easiest way to verify a file's
existence. This will be in a trigger program.

Thanks.


Roger Harman
COMMON Certified Application Developer – ILE RPG on IBM i on Power



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.