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
"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

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.


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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by 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].