RE: AW: SQL Check If File Exists (via RPG)

[Roger Harman <roger.harman@xxxxxxxxxxx>]

Thanks Birgitta.  I had entertained that thought also.  


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







----------------------------------------
> From: Hauser@xxxxxxxxxxxxxxx
> To: midrange-l@xxxxxxxxxxxx
> Subject: AW: SQL Check If File Exists (via RPG)
> Date: Tue, 3 Nov 2015 06:52:17 +0100
>
> You may check the existence of a table or view against the SysTables-View
> located in the QSYS2 schema.:
>
> Select 1 into :Exists
> From SysTables
> Where Table_Name = :YourTableName and Table_Schema =:YourTableSchema
>
> The SQL statement above checks for the long names. If you prefer the
> short/system names, those can be found in the System_Table_Name and
> System_Table_Schema columns.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
> Roger Harman
> Gesendet: Tuesday, 03.11 2015 00:48
> An: midrange-l@xxxxxxxxxxxx
> Betreff: SQL Check If File Exists (via RPG)
>
> 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.